Easy way to store metadata about SQLite Database

You might want to check out the user_version pragma.

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;