Easy way to store metadata about SQLite Database Easy way to store metadata about SQLite Database sqlite sqlite

Easy way to store metadata about SQLite Database


SQLite offers two slots to store an integer as metadata.

application_id

https://www.sqlite.org/pragma.html#pragma_application_id

Set an application_id to 900

PRAGMA application_id = 900;

Get the application_id

PRAGMA application_id;

user_version

https://www.sqlite.org/pragma.html#pragma_user_version

Set an user_version to 901

PRAGMA user_version = 901;

Get the user_version

PRAGMA user_version;