Re:The Design Of SQLite4
by seanalltogether on Sunday May 25, 2014 @03:43PM
(#7797314)
I'm sure this sounds arbitrary, but I'd love it if the sqlite file header allowed for more room to add program specific metadata. The fact that more and more apps are using sqlite files to store user facing files, it would be nice if space in the header was given to identify the expected usage of the sql file.
[ Parent
| on HN ]
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
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