Updating database schemas

[Toshio Kuratomi]

Hello to other web app developers,

Xavier Lamien sent a message to me today about incompatibilities in 
database schemas between FAS versions 0.8.4 and 0.8.5.  This prompted me 
to think about how we can help people update their databases if changes 
occur between versions of the database.  For this particular update I 
added sql scripts to FAS in the updates/ directory and listed how to 
invoke them in the README.  If you are updating your database schema and 
you are also packaging the software for general consumption (for 
instance, packaged in rpm form in Fedora proper), please consider how to 
manage this for your users.  There's a variety of ways ranging from what 
I did to the `migrate`_ project (I haven't seen this appear in Fedora 
yet.  Any takers?) leveraging tg-admin sql might work for simple cases 
like adding a new table but I haven't found that it will update existing 
tables.

In any case, remembering to document the procedure for other members of 
the code will be great.

.. migrate: http://code.google.com/p/sqlalchemy-migrate/

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 197 bytes
Desc: OpenPGP digital signature
Url : http://lists.fedoraproject.org/pipermail/infrastructure/attachments/20080614/db738d33/attachment.bin