View sqlite database on android

Question

I am using android studio to develop my first android app.

I am plugging in my phone, and testing my app on there to test changes as I go.

I am using a sqlite database. How do I view this database, the tables, and the contents (rows) of those tables?

Upon Google searching I found that this can be done when you root your phone. But surely you dont have to root your phone to view your databases when your developing an app?

Update:

People are using terminology assuming knowledge. If you want me to copy a database, explain how, if you want me to use adb, explain what it is. Otherwise it means not much to me. Thanks

copy your database from internal to external storage so that you can access it — Karn Shah, Feb 24 '15 at 08:41
use emulator and you can find your database at /data/data/{yourapp} — K Guru, Feb 24 '15 at 08:45
@kamran so once emulator is running, how do i find my database? — RSM, Feb 24 '15 at 08:51
open the DDMS perspective --> file explorer --then data folder --->data--yourapp — K Guru, Feb 24 '15 at 09:01
The BEST solution was @Bob's answer at https://stackoverflow.com/questions/19194576/how-do-i-view-the-sqlite-database-on-an-android-device — Jeffrey, Jul 01 '18 at 18:57

score 1 · Accepted Answer · edited May 23 '17 at 12:01

Pull the sqlite database named as XYZ.db from your simulator or device using adb shell command or GUI interface provided by the AndroidStudio. Then Open it using The Sqlite Browser. It's a killer app for sqlite browsing.

As android is shipped with the sqlite3, you could use command line to view the data base saved inside the device / emulator. Command reference is Listed Sqlite3 android command

If you feel lazy enough to discover how to pull files from emulator / device using adb pull, following answer may help you. how to pull

score 0 · Answer 2 · answered Feb 24 '15 at 08:41

At least in my case I needed to root my device. After that I installed SQLiteEditor. With this app you can modify and view your database. Or if you don't want to install a new app you can use a root explorer and enter directly into your installed app in the DB. Is inside /data/data/{yourapp}.

score 0 · Answer 3 · answered Feb 24 '15 at 08:44

0

Copy your database to your system

Using copy or paste Or
Using adb pull command

Then Googled for sqlitestudio-2.1.4, download and run , browse your database ,,then you can see your database rows, column, value etc.

answered Feb 24 '15 at 08:44

IshRoid

3,696
2
26
39

View sqlite database on android

3 Answers3