Re: Version Control?

On Thu, Jun 09, 2005 at 10:12:25PM +0100, Russ Brown wrote:
> Peter Fein wrote:
> >Hi-
> >
> >Any general tips on using version control (CVS, SVN) while doing
> >database design? My thought was to do a text-mode dump (including
> >populated code tables) from PGAdmin.
> >
> >How do people do this?
> >
>
> Currently we just store a dump of the data structure. However, what I
> think is really needed is a specialist diff tool which works out the
> commands needed to move from one schema to another. That would be
> *extremely* useful, but would also probably require a separate
> implementation for each database backend.

I've spent quite a lot of time thinking about this and it's certainly
not trivial, and probably _hard_. If anyone has even half-functional
code to do it I'd be interested in looking at it.

> It's an interesting problem which I've not yet seen a usable solution
> to. I've been looking for an OSS project to either start or contribute
> to. Maybe that's one itch that I might consider scratching...

Yeah...

Cheers,
  Steve