[PyCS-devel] RE: [Pyds-dev] sqlite vs postgres / mysql / metakit

[Garth T K. <ga...@de...>]

You could use a data dictionary approach, where everything ends up in four
tables: two dictionary tables, and two content tables. The schema tables are
tablename and tablename/attributename/attributespec, and the data tables are
table/id and table/id/attribute/value. To add or remove logical tables or
columns, just alter the schema tables and add or remove items appropriately
from the data tables. It's still possible to write fast SQL for updates,
too. 

-----Original Message-----
From: pyd...@mu...
[mailto:pyd...@mu...] On Behalf Of Phillip Pearson
Sent: Wednesday, 7 July 2004 11:08 AM
To: Jeremy Bowers
Cc: Yasushi Iwata; pyd...@mu...;
pyc...@li...
Subject: [Pyds-dev] sqlite vs postgres / mysql / metakit

Hmm - just noticed that SQLite doesn't do ALTER TABLE.  That's
unfortunate... it's not that big a deal, but it makes development
annoying...

Cheers,
Phil


_______________________________________________
Pyds-dev mailing list
Pyd...@mu...
http://www.westfalen.de/cgi-bin/mailman/listinfo/pyds-dev