How to see the data stored in sqlite in android studio using genymotion as emulator

Question

As i am having AMD processor in my laptop i am using GENYMOTION as an emulator. I have stored the data in sqlite as it is a plugin in android studio. But if i want to see the data using DDMS the file explorer showing nothing. How can i see the data stored in sqlite database using androidstudio and using GENYMOTION. Thanks in advance

Check [this link](http://stackoverflow.com/questions/4867379/android-eclipse-ddms-cant-access-data-data-on-phone-to-pull-files) — Batuhan Coşkun, Feb 19 '15 at 15:59
User Deepika R gave the answer, but it as deleted. Thanks, @DeepikaR ! — Fattie, Jan 06 '17 at 02:22

score 35 · Accepted Answer · edited Jul 19 '15 at 02:24

35

Go to Tools -> DDMS or click the Device Monitor icon next to SDK Manager in Tool bar.
Device Monitor window will open. In File Explorer tab, click data -> data -> your project name. After that your databases file will open. Click pull a file from device icon. Save the file using .db extension.
Open FireFox, Press Alt , Tools -> SQLiteManager.
Follow Database -> connect to Database -> browse your database file and click ok. Your SQLite file will opened now.

edited Jul 19 '15 at 02:24

Gustavo Barbosa

1,340
1
17
27

answered Apr 01 '15 at 06:33

sudharsan

474
4
4

@RohitBandil not sure. I've only tried through Genymotion's emulator. – Gustavo Barbosa Nov 23 '16 at 21:01
1

I followed the process on Android Studio default emulator and it works fine. Instead of FireFox I used [DB browser for SQLite](http://sqlitebrowser.org/). It's awesome! – Hasan Abdullah Jan 20 '17 at 05:58
8

In `data -> data -> your project name`, the first `data` directory doesn't open. What should I do ? (my device is Amazon Fire Tablet) – McLan Apr 27 '17 at 10:48
1

I run my app in an emulator with API 23 and the "File Explorer" in the Monitor shows the content of "data" directory ... – Marcos Sep 19 '17 at 07:09

score 9 · Answer 2 · answered Jun 28 '15 at 19:03

One of the things that hasn't changed on Android Studio is the Android Device Monitor. so this applies to AS and Eclipse.

1) Download the jar SQLite browser plugin from https://github.com/TKlerx/android-sqlite-browser-for-eclipse/releases

2) Put the jar in: [YourAndroidSdkDirectory]/tools/lib/monitor-x86_64/plugins/AndroidSQLiteBrowser_1.0.1.jar

3) Restart the Android Device Monitor.

4) Select the .db file inside the device(rooted) or the emulator and click on the SQLite browser on the top right corner next to the (+) new folder button.

5) Enjoy!

score 7 · Answer 3 · edited Oct 06 '17 at 13:58

7

pull database using adb commands

adb pull /data/data/com.android.packagename/databases/datebase.db

the db will be pulled to current location where terminal is pointing to

then open db using sqliteman

edited Oct 06 '17 at 13:58

Pravin Divraniya

4,223
2
32
49

answered Jul 01 '16 at 07:17

Tushar Saha

1,978
24
29

that seems like a fantastic tip - but how to run "adb" on a Mac, where is it?! – Fattie Jan 06 '17 at 02:15
Getting below error while applying your solution. `D:\Softwares\Installed\Android-SDK\platform-tools>adb pull /data/data/com.android.com.myapp/databases.MyApp.db adb: error: remote object '/data/data/com.android.com.myapp/databases.MyApp.db' does not exist` **MyApp** is my database name. I tried, where my project resides. Got below error. `D:\Projects\Android\Android Studio Workspace\MyApp>adb pull /data/data/com.android.com.myapp/databases.MyApp.db 'adb' is not recognized as an internal or external command, operable program or batch file. ` I'm working with real device. – Maulik Dodia May 01 '17 at 09:27
Do I need to root the device?@TusharSaha – Maulik Dodia May 02 '17 at 11:38
you may root or simply write a function which would copy db from db folder to sdcard/internal storage and then transfer it to pc – Tushar Saha May 03 '17 at 08:35

score 5 · Answer 4 · answered Jan 31 '18 at 07:27

5

Update Android studio to the latest version 3.0 and we have access to Device File Explorer in :

View -> Tools Window -> Device File Explorer

Official Documenation

To View sqlite database:

install Mozilla sqlite plugin adons or any other sqlite manager plugin to view the sqlite database.

answered Jan 31 '18 at 07:27

Stephen

9,899
16
90
137

Under what directory all these folders are located? I couldn't see the parent directory in your image. – Sparkzz Apr 19 '18 at 19:53
@Sparkzz Check data directory – Stephen Feb 20 '19 at 05:21

score 1 · Answer 5 · answered Dec 01 '17 at 01:50

You can use IDEscout. It helps inspect any applications database realtime. You can also edit the database as your need.

All you need is download the IDEscout plugin for android studio. Then for connecting to your project:

Add the dependency to your project level gradle.buid

allprojects {
   repositories {
      jcenter()
      maven {
          url 'http://www.idescout.com/maven/repo/'
      }
   }
}

Add com.idescout.sql:sqlscout-server:2.0 as a dependency to your project's app module:
```
compile 'com.idescout.sql:sqlscout-server:2.0'
```

In the onCreate method of your main Activity invoke the method com.idescout.sql.SqlScoutServer#create as follows:

@Override
public void onCreate(Bundle savedInstanceState) {
    SqlScoutServer.create(this, getPackageName());

Here are some using views for live data visualization and editing

score 0 · Answer 6 · answered Feb 19 '15 at 16:41

Depending on the complexity of the data, you can also use an sqlite browser on the device itself. There are various free sqlite browsers for Android (SQLite Manager comes to mind) that will allow you to browse sqlite data on a rooted devices. Since the genymotion device images are rooted, it's easy to install one of these applications and view the data that way. Again, this works best if the data is simple -- it's a bit cumbersome for larger datasets.

How to see the data stored in sqlite in android studio using genymotion as emulator

6 Answers6

Here are some using views for live data visualization and editing

Linked