Re: Schema version control - Mailing list pgsql-general

From Alban Hertroys
Subject Re: Schema version control
Date
Msg-id 2758382D-3F7D-4E47-839E-147C93264266@solfertje.student.utwente.nl
Whole thread Raw
In response to Re: Schema version control  (Bill Moran <wmoran@potentialtech.com>)
Responses Re: Schema version control
List pgsql-general
On 10 Feb 2011, at 23:59, Bill Moran wrote:

> The overview:
> You store your schema and data as XML (this is easy to migrate to, because
> it includes a tool that makes the XML from a live database)
> Keep your XML schema files in some RCS.

That reminds me of something I've been wondering about - How well do modern RCSs deal with structured data formats
(likeXML)? It would appear that most of them still use diff, which is line-based with limited context tracking, to
determinechange-sets. 

Is that combination guaranteed to result in valid XML if you merge revisions that are far enough apart? Or are there
RCSsaround that know about XML format (and possibly other structured formats) and handle it differently? 

I've heavily used RCSs (mostly Subversion) with, for example HTML, and merge conflicts haven't been unusual. It doesn't
helpSubversion's diff is a bit simplistic about white-space, I'm sure some of those conflicts were quite unnecessary. 

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.


!DSPAM:737,4d54eac711731788013809!



pgsql-general by date:

Previous
From: Glenn Maynard
Date:
Subject: Re: Schema version control
Next
From: Andre Lopes
Date:
Subject: Re: Schema version control