Android browse SQLite database on phone

Question

How can I browse the SQLite database that I am creating in my app on my Android myTouch phone?

When I log in through adb shell, sqlite3 gives me a permission denied. Is there another way to check if my database and tables are actually being created, and if rows are being inserted?

I am not able to use the emulator, since it doesn't play videos etc. very well that is the main feature of my app, so I can only test on phone.

Thanks Chris

Answer 1

The entire database is a single file, so via the DDMS view in Eclipse or via the command line you can pull that file from the phone. You can then use SQLite DataBase Browser to view the contents, for example.