[OPEN-ILS-DEV] DB versioning

[Mike Rylander]

On 5/23/07, Jeroen Ruigrok van der Werven <asmodai at in-nomine.org> wrote:
> -On [20070523 02:34], Mike Rylander (mrylander at gmail.com) wrote:
> > Dan Scott and I have been discussing on and off over IRC how we might
> > go about versioning the database schema for EG.
>
> Have you ever seen the 'migrate' program/module/package for Python? It's a
> subproject for SQLAlchemy.
> http://erosson.com/migrate/

I have seen that before, and there's a similar mechanism in Perl, but
AFAICT they will both have problems with replication support (Slony,
if not pgpool).  I'm more than willing to be proven wrong of course.

For the time being I'm going to focus on specing what needs to happen
as opposed to which tool to use.  Hopefully the appropriate tool will
be self-evident once we understand the problem more completely ... if
that makes sense.

--miker

>
> --
> Jeroen Ruigrok van der Werven <asmodai(-at-)in-nomine.org> / asmodai
> イェルーン ラウフロック ヴァン デル ウェルヴェン
> http://www.in-nomine.org/ | http://www.rangaku.org/
> Think carefully of what you ask for, because you just may get it...
>


-- 
Mike Rylander