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
– Karn Shah, Commented Feb 24, 2015 at 8:41
use emulator and you can find your database at /data/data/{yourapp} — K Guru
– K Guru, Commented Feb 24, 2015 at 8:45
@kamran so once emulator is running, how do i find my database? — RSM
– RSM, Commented Feb 24, 2015 at 8:51
open the DDMS perspective --> file explorer --then data folder --->data--yourapp — K Guru
– K Guru, Commented Feb 24, 2015 at 9:01
The BEST solution was @Bob's answer at stackoverflow.com/questions/19194576/… — Jeffrey
– Jeffrey, Commented Jul 1, 2018 at 18:57

Community · Accepted Answer · 2017-05-23 12:01:48Z

1

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

edited May 23, 2017 at 12:01

CommunityBot

11 silver badge

answered Feb 24, 2015 at 8:53

Ratul Sharker

8,0974 gold badges39 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

acostela · Accepted Answer · 2015-02-24 08:41:54Z

0

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}.

answered Feb 24, 2015 at 8:41

acostela

2,7573 gold badges36 silver badges52 bronze badges

Comments

IshRoid · Accepted Answer · 2015-02-24 08:44:37Z

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, 2015 at 8:44

IshRoid

3,7452 gold badges30 silver badges41 bronze badges

Collectives™ on Stack Overflow

View sqlite database on android

3 Answers 3

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Linked

Related