Re:The Design Of SQLite4
by ccgus on Sunday May 25, 2014 @04:22PM
(#7797442)
You're aware of the application_id pragma? That's what this guy was created for: http://www.sqlite.org/pragma.html#pragma_application_id
[ Parent
| on HN ]
Hah, I read that and thought "Hmmm, I wonder if Gus knows about this? He should use it in Acorn". Then I read your username :)
That's good, but is not enough. A metadata support would be useful!
e.g. It's like with photos (JPG) were you would only know it was shoot with a Canon camera, or a music file (MP3) that only stores the application name media player.
Most common file formats support metadata formarts like JPEG with its EXIV, ITPC, XMP and MP3 with ID3 v1 & v2, etc.
So for SQLite4 a very simple key value format would be great, with some predefined key-fields.
You can always embed a "metadata" table in your schema. Not ideal but would probably do the job in a lot of cases.
Re:The Design Of SQLite4
by seanalltogether on Sunday May 25, 2014 @04:43PM
(#7797501)
Ah, no I wasn't. The file format page simply marks that region as reserved. http://www.sqlite.org/fileformat.html