Inspecting android sql database from Eclipse

Is there a way to directly inspect an SQLite3 data开发者_开发问答base in Android via Eclipse or do I have to do this via the shell?

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

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

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.

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 telnet and run SQL via small program

But it is not from Eclipse. It uses telnet or a sql editor named RdbAssistant.