See SQLite db contents

Issue

I'm developing an android app using sqllite db and I wanted to know if there way a way to explore this db's current content.

Solution

Download SqlLite Database Browser.

you need to pull a copy of the database from the device or emulator as explained below and work on that copy that can be restored later on.

The database for a specific app lives in /data/data/[packagename]/databases

The packagename is the package you define in your manifest, for instance /data/data/org.example.com/databases/counts.db.

You can view it with adb shell, to see database type sqlite3 /data/data/org.example.com/databases/counts.db

Or you can pull it from the device to look at it with a third party utility, with a command like adb pull /data/data/org.example.com/databases/counts.db ..

Answered By - Chirag