Access SQLite DB from IntelliJ for Android

Question

How can I view the DB in IntelliJ to view its content and perform operations on it. Now I have created my tables etc but i have no idea what data is on the DB and I do not want to create queries in java to check it. seems like a slow workflow so ill wait til I know how to access the db that resides on the Android emulator im using.

Is it possible?

https://github.com/jgilfelt/android-sqlite-asset-helper – OneCricketeer Jul 23 '16 at 15:31 — OneCricketeer, Jul 23 '16 at 15:31

score 2 · Answer 1 · answered Jul 23 '16 at 15:42

2

You can also use Stetho. A nice debugging tool from Facebook.

Just simple to use, initialize it in your Application class and access your sqlite and even shared preferences from Google Chrome's developer console.

answered Jul 23 '16 at 15:42

alxsimo

567
1
6
19

BTW, don't use it in production see this [question](http://stackoverflow.com/q/30172308/1523910) regarding that. – Avinash R Jul 24 '16 at 16:50
Right! You should use it with flavors or Dagger. Enabling it for example only on debug flavor. – alxsimo Jul 24 '16 at 16:51

score 0 · Answer 2 · edited May 23 '17 at 10:28

0

see @alexsimo's answer.

Without root you cannot access your database on your device, unless the file is created with a+r permissions.

Since that is something that is unrelated to the issue, you can just search in plugin.jetbrains.com for sqlite and get a variety of plugins.

edited May 23 '17 at 10:28

Community

1
1

answered Jul 23 '16 at 15:18

Avinash R

3,101
1
27
47

Most of those plugins are only for ultimate edition, though – OneCricketeer Jul 23 '16 at 15:20
alternative is to use an outside editor something like, https://github.com/sunnygoyal/jade and work on getting the database from the device. – Avinash R Jul 23 '16 at 15:32

OneCricketeer · Answer 3 · 2016-07-23T15:43:04.290

0

You can create a database file outside of Android and use any tool to create and read it.

Then, you place it in the assets folder and setup your code to read the database from there instead of private app data. Caveat here is that a copy will be made from the assets folder to the app data, so any updates within the app won't be mirrored to the database file in the assets folder.

I believe you can access the DDMS window in Intellij/Android Studio and there is a Database Explorer there

edited Jul 23 '16 at 15:43

answered Jul 23 '16 at 15:23

OneCricketeer

179,855
19
132
245

Do you mean the app->intermediaries->assets folder? and just drag and drop it there? What path should I use in that case? – vasper Jul 23 '16 at 15:29
Nope, an assets folder is either inside of or next to the res folder, can't remember – OneCricketeer Jul 23 '16 at 15:30
in the project structure IntelliJ created its no assets folder in res or rs its inside the "intermediaries" folder – vasper Jul 23 '16 at 15:31
You have to do File > New > Assets – OneCricketeer Jul 23 '16 at 15:32
do u mean create the assets folder inside the res or rs folder? – vasper Jul 23 '16 at 15:37
Not inside intermediates, but yes, if you want an assets folder, you need to create one. I think it's typically next to the res folder, not inside – OneCricketeer Jul 23 '16 at 15:39

Access SQLite DB from IntelliJ for Android

3 Answers3