3 ms·
Well, apart from the fact that your "proposal" is incomplete and obviously not thought-through in the slightest (to put it politely) we also already have a cano
by moe 17y ago
Well, apart from the fact that your "proposal" is incomplete and obviously not thought-through in the slightest (to put it politely) we also already have a canonical way to represent relational database schemas; http://en.wikipedia.org/wiki/Data_Definition_Language http://en.wikipedia.org/wiki/Data_Definition_Language
Moreover the problem with database schemas has never been to represent them or reflect on them, but to migrate between them.
See http://www.post-facto.org/ http://www.post-facto.org/ for an interesting approach (presentation by the author: http://hosting3.epresence.tv/fosslc/1/watch/128.aspx http://hosting3.epresence.tv/fosslc/1/watch/128.aspx).
- thwarted 17y agoIf I remember correctly, SQLite parses the DDL for tables and indexes each time the database file is opened. I always thought this was kind of weird, and felt a binary representation would be more appropriate, but when you consider that DDL exists to describe the schema, it makes perfect sense. There's no need for another representation, and parsing the DDL is more future-proof as features are added.