Skip site navigation (1) Skip section navigation (2)

Re: tracking db changes / comparing databases

From: Mitch Pirtle <mitchy(at)spacemonkeylabs(dot)com>
To: aplst(at)xs4all(dot)nl
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: tracking db changes / comparing databases
Date: 2004-08-18 15:25:54
Message-ID: 41237502.7070902@spacemonkeylabs.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
aplst(at)xs4all(dot)nl wrote:

>How do you share the data-definitions of your project(s) when they change
>(template1) ? Do you create all system-tables at pg_init runtime, and thus
>diff the C-source?
>  
>

The best approach IMHO is to use cvs and diff.  For a more PHP-centric 
approach, you could look at ADOdb:

    http://adodb.sf.net/

Does a lot more than just abstract the database, also provides caching 
of query results, handy utilities for building form elements, etc.  But 
the most topical feature is the inclusion of the data dictionary and 
ADOdb XML Schema (AXMLS):

    http://phplens.com/lens/adodb/docs-datadict.htm

Here you can use database-agnostic XML markup (and also reverse-engineer 
schemas).  You can basically use this to migrate your schemas.  I am 
looking into using this for the next major release of Mambo CMS for 
upgrades and installs.

HTH,

-- Mitch


In response to

pgsql-admin by date

Next:From: Gaetano MendolaDate: 2004-08-18 15:30:05
Subject: Re: [ADMIN] SRPM for 8.0.0 beta?
Previous:From: Tom LaneDate: 2004-08-18 15:09:30
Subject: Re: [ADMIN] SRPM for 8.0.0 beta?

pgsql-general by date

Next:From: Bob ParkinsonDate: 2004-08-18 15:26:48
Subject: Re: scripting & psql issues
Previous:From: Tom LaneDate: 2004-08-18 15:09:30
Subject: Re: [ADMIN] SRPM for 8.0.0 beta?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group