News for hackers. Stuff that matters.
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
Re:The Design Of SQLite4 by eridius on Sunday May 25, 2014 @05:53PM (#7797721)
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 :)
Re:The Design Of SQLite4 by frik on Monday May 26, 2014 @01:08AM (#7798770)
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.

Re:The Design Of SQLite4 by emillon on Monday May 26, 2014 @08:26AM (#7799450)
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