4 ms·
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 http://www.sqlite.org/
by ccgus 12y ago
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 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.