Re: versioning a [small] MySQL database with svn?

Le Sun, Feb 27, 2005 at 12:25:40PM -0600, Ben Collins-Sussman
écrivait/wrote:
[...]

> I think you've misunderstood me: I'm not saying "a repository should
> never contain anything but source code!" or, "a repository should never
> contain binary data". I'm talking about expecting the the version
> control system to do what a build-system should be doing.

This is probably a matter of terminology. For me, a build system is
building something. And dumping a MySQL database is not building it by
any means (building it would be the opposite - running mysql on the
dump.sql file obtained by mysqldump). More generally, backing up data,
or transforming it into a form suitable for backups and version
control (like the mysqldump command does) is not building.
>
> I have to admit, I still don't quite understand what you want to do.
> You want to keep *both* the binary and the textually-dumped data in the
> repository, both under version control? [...]

Sorry, I probably explained wrongly what I want to do (I am not a
native english speaker).

I only want to version control a project made of C source files, a few
shell scripts, a GNUmakefile, and a MySQL database; of course I don't
version-control mysql binary files (which are not accessible to me),
only the result of mysqldump.

So I will wrap svn commit inside a shell script, but I still believe
it is a pity that *transforming* commands (like mysqldump) cannot be
invoked at commit time by the svn commit command.

I still believe that modern version control systems should be able to
version-control user data which is not in plain textual (or platform
neutral binary) form, of which a database is a typical example (and I
listed others). And I don't want to version-control a huge database,
only a small one. (people think of databases as always being gigabytes
or terabytes, but it does make sense to use MySQL on a database of a
few megabytes at most, and to want to version-control it).

(For information, the Ocaml binary image I talked about previously is
a bytecode file with a neutral format - like .java files are and it is
versioned under CVS).

A big thanks for your reply.

Regards.

-- 
Basile STARYNKEVITCH         http://starynkevitch.net/Basile/ 
email: basile<at>starynkevitch<dot>net 
aliases: basile<at>tunes<dot>org = bstarynk<at>nerim<dot>net
8, rue de la Faïencerie, 92340 Bourg La Reine, France
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org