debug android : connect to sqlite db on phone

Question

I'm building an application with a SQLite db in it. Some data is not erased as it should be, I'd like to run ad hoc queries in the existing db to debug.

Is there a way to connect to the SQLite db on the phone (or the emulator) while in debug mode?

Answer 1

Yes, you can connect to your device (or the emulator) using this manual. Use adb to connect to the emulator:

$ adb -s emulator-5554 shell

and then launch the sqlite3 application with the database you need:

# sqlite3 /data/data/com.example.google.rss.rssexample/databases/rssitems.db

Then you can run any SQL query you want.