[ccgus]

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

[eridius]

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 :)

[frik]

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.

[emillon]

You can always embed a "metadata" table in your schema. Not ideal but would probably do the job in a lot of cases.

[seanalltogether]

Ah, no I wasn't. The file format page simply marks that region as reserved. http://www.sqlite.org/fileformat.html