4 ms·
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 ap
by seanalltogether 12y ago
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.
- ccgus 12y agoYou're aware of the application_id pragma? That's what this guy was created for: http://www.sqlite.org/pragma.html#pragma_application_id http://www.sqlite.org/pragma.html#pragma_application_id
- seanalltogether 12y agoAh, no I wasn't. The file format page simply marks that region as reserved. http://www.sqlite.org/fileformat.html http://www.sqlite.org/fileformat.html
- eridius 12y agoHah, I read that and thought "Hmmm, I wonder if Gus knows about this? He should use it in Acorn". Then I read your username :)
- frik 12y agoThat'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.
- emillon 12y agoYou can always embed a "metadata" table in your schema. Not ideal but would probably do the job in a lot of cases.