RE: sqlite vs postgres / mysql / metakit
"Garth T Kidd" <garth-OnzZ1s1DREKDegMON/[email protected]> Wed, 7 Jul 2004 10:46:13 +1000
| Newsgroups | gmane.comp.pythin.pyds.devel |
|---|---|
| Organization | Deadly Bloody Serious |
| Message-ID | <[email protected]> |
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: pyds-dev-admin-iYtK5bfT9M//Ad8WF/[email protected] [mailto:pyds-dev-admin-iYtK5bfT9M//Ad8WF/[email protected]] On Behalf Of Phillip Pearson Sent: Wednesday, 7 July 2004 11:08 AM To: Jeremy Bowers Cc: Yasushi Iwata; pyds-dev-iYtK5bfT9M//Ad8WF/[email protected]; [email protected] 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 Pyds-dev-iYtK5bfT9M//Ad8WF/[email protected] http://www.westfalen.de/cgi-bin/mailman/listinfo/pyds-dev