How can I see the contents of a sqlite db of my app in a real device?

Question

I want to see the contents of my database created in my app in the device I deploied it. I can use sqlite commands in shell and see in emulator but not in a real device.

Can anyone know how to do it in real device?

Answer 1

root is not necessary if the application is flagged a debuggable. You can use the run-as adb command.

e.g. to use sqlite :

adb shell "run-as com.your.package sqlite3 databases/database_name"

or copy and pull the database :

adb shell "run-as com.your.package cat databases/database_name > /sdcard/some_name"
adb pull /sdcard/some_name

unfortunately it seems that pre-ICS run-as has quite a few bugs, e.g. issue 20792 or 13965

Answer 2

Actually your Real Device is not Rooted so you don't have a permission to access /data/data/<Application>/database/ directory.

Only one solution copy that file to external Storage .. And see it in SQLiteManager or any other SQLite tools.