Is there a way to directly inspect an SQLite3 database in Android via Eclipse or do I have to do this via the shell?
Add a comment
|
4 Answers
I don't know if you can inspect it from within eclipse but you can pull a copy of the database file from the DDMS perspective in the file explorer in folder
data->data->your.package.name->databases
which you can inspect with a free database manager such as sqlite studio
1 Comment
esilver
I think this only works for unlocked/rooted phones. I cannot explore my data directory; I get an "operation not permitted" error
Unfortunately AFAIK you always have to use the shell currently. (Well, not quite. You can use DDMS in Eclipse to pull the database, but that's not much better than using the shell).
Basically you can either 1) pull the database file from the emulator / phone and then inspect it, or you can 2) manually run some SQL queries from inside the emulator/phone.
For 1, I would recommend creating a script. Here is simple example
$ cat android_pull_db
#!sh
adb shell "chmod 777 /data/data/com.mypackage/databases/store.db"
adb pull /data/data/com.mypackage/databases/store.db
$
To create your own, paste the lines from #!... down to adb pull ... into a text file, and save it somewhere. Modify the package location and database filename. Make it executable, and add it to your path.
For 2, just execute this:
$ adb shell
$ cd /data/data/com.yourpackage/databases
$ sqlite3 your-db-file.db
> .help
Comments
http://sqlitebrowser.sourceforge.net/index.html
This is a simple way of inspecting the contents of a database. Just use the DDMS to pull the database from the device and then open.
Comments
https://github.com/cattaka/TelnetSqlite/wiki
I made it this by following 3 step.
- Embed a small program
- Add code to kick the embedded program in the
Application.onCreate()method - Execute the
telnetand runSQLvia small program
But it is not from Eclipse. It uses telnet or a sql editor named RdbAssistant.
Comments
