From: D'Arcy J.M. Cain <darcy@druid.net>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: John Mitchell <mitchelljj98@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: How do I connect postgres table structures and view structures to an existing svn repository?
Date: Wed, 1 Aug 2007 14:17:24 -0400
Message-ID: <20070801141724.49097d23.darcy@druid.net> (raw)
In-Reply-To: <dcc563d10708010946o4c69542yc876c2bc16768e54@mail.gmail.com>
References: <fa2ac0580708010707n488b1906rf74d487de801673f@mail.gmail.com>
<20070801113812.6a2d6fac.darcy@druid.net>
<fa2ac0580708010845r9108596r14ec88ae4420ce11@mail.gmail.com>
<dcc563d10708010946o4c69542yc876c2bc16768e54@mail.gmail.com>
On Wed, 1 Aug 2007 11:46:11 -0500
"Scott Marlowe" <scott.marlowe@gmail.com> wrote:
> On 8/1/07, John Mitchell <mitchelljj98@gmail.com> wrote:
> > I am trying to store schema definitions in version-control which I can do by
> > saving the definition and then importing into svn, but I would like it
> > to be automatic , so that when an update occurs to a table or view within
> > postgres then that table or view is flagged within svn. This would be
> > similar to what I currently do with source code that I have for a web app
> > within eclipse.
>
> My point being that you need to drive the changes from the svn side,
> not the database side. I've seen no reliable way to do it otherwise,
> but would love to be pleasantly surprised.
You are right. It is always difficult to add structured control to
unstructured development methods. The method that I suggested was the
best I could think of to handle a database that is changed ad hoc with
no design work beforehand. If you work from the design side first you
can create schema documents that feed your database creation and use
svn to save those versions and document exactly why things changed.
--
D'Arcy J.M. Cain <darcy@druid.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: darcy@druid.net, scott.marlowe@gmail.com, mitchelljj98@gmail.com
Subject: Re: How do I connect postgres table structures and view structures to an existing svn repository?
In-Reply-To: <20070801141724.49097d23.darcy@druid.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox