Android check SQLite database version via shell?

Question

Following this question is there a way to check the app's current database version via adb shell? Also how do I check the user cookie field mentioned in the question?

You could show the SQLite version by executing `SELECT sqlite_version();`, but this is not the version number you want; you want the database version. — CL., Mar 25 '13 at 08:24

score 10 · Accepted Answer · answered Mar 25 '13 at 08:25

10

To show the database file's user version number (which is the same as the user cookie), execute this SQL command:

PRAGMA user_version;

answered Mar 25 '13 at 08:25

CL.

173,858
17
217
259

score 0 · Answer 2 · answered Apr 25 '19 at 06:41

0

To check the sqlite version through shell, follow below commands:

adb -s <deviceId> shell
sqlite3 /data/data/<your app's package name>

Source: https://developer.android.com/studio/command-line/adb

answered Apr 25 '19 at 06:41

Dhiraj Aggarwal

118
1
10

Android check SQLite database version via shell?

2 Answers2