X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A5BE35E46BF for ; Wed, 18 Aug 2004 12:27:59 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 20230-06 for ; Wed, 18 Aug 2004 15:28:04 +0000 (GMT) Received: from out001.verizon.net (out001pub.verizon.net [206.46.170.140]) by svr1.postgresql.org (Postfix) with ESMTP id 222165E46C1 for ; Wed, 18 Aug 2004 12:27:55 -0300 (ADT) Received: from [127.0.0.1] ([162.84.149.21]) by out001.verizon.net (InterMail vM.5.01.06.06 201-253-122-130-106-20030910) with ESMTP id <20040818152802.BAEQ24594.out001.verizon.net@[127.0.0.1]>; Wed, 18 Aug 2004 10:28:02 -0500 Message-ID: <41237502.7070902@spacemonkeylabs.com> Date: Wed, 18 Aug 2004 11:25:54 -0400 From: Mitch Pirtle Organization: Spacemonkey Laboratories User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803) X-Accept-Language: en-us, en MIME-Version: 1.0 To: aplst@xs4all.nl Cc: pgsql-admin@postgresql.org Subject: Re: tracking db changes / comparing databases References: <12975.62.4.75.26.1092838173.squirrel@webmail.xs4all.nl> In-Reply-To: <12975.62.4.75.26.1092838173.squirrel@webmail.xs4all.nl> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Authentication-Info: Submitted using SMTP AUTH at out001.verizon.net from [162.84.149.21] at Wed, 18 Aug 2004 10:28:01 -0500 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/164 X-Sequence-Number: 14559 aplst@xs4all.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