bhups bhups - 1 year ago 90
Android Question

Where does Android store SQLite's database version?

I am unable to find where Android stores the database version within the SQLite database file. Where exactly is the database version stored?

Answer Source

You can read the version using android.database.sqlite.SQLiteDatabase.getVersion().

Internally, this method executes the SQL statement "PRAGMA user_version". I got that from the Android source code.

In the database file, the version is stored at byte offset 60 in the database header of the database file, in the field 'user cookie'.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download