[PyCS-devel] RE: [Pyds-dev] sqlite vs postgres / mysql / metakit
Status: Alpha
Brought to you by:
myelin
|
From: Garth T K. <ga...@de...> - 2004-07-07 00:46:33
|
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 |