The sqlite database file format has two fields to identify the application the database file belongs to. The first field, application_id
, is supposed to identify the application. The second field, user_version
, can identify the version of the file format used by the database file in case there is more than one file format for an application.
These fields can be queried and set with pragmas:
PRAGMA application_id; -- get application ID
PRAGMA application_id = ?; -- set application ID
PRAGMA user_version; -- get user version
PRAGMA user_version = ?; -- set user version
Is there an official place where I can register my application ID to make sure that it is unique?
The only registry is the magic.txt file in the source repository.
To register an application_id
value, ask the developers by sending a mail to the SQLite mailing list.