News for hackers. Stuff that matters.
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.
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