How to browse an Android SQLite Database from Eclipse Kepler
http://www.youtube.com/watch?feature=player_embedded&v=sAvlV0uw5zcCellObject SQLite Browser :
http://www.questoid.com/Download.aspx
Questoid website is down and the jar can be downloaded from :
http://www.java2s.com/Code/Jar/c/com.questoid.htm
http://www.java2s.com/Code/JarDownload/com.questoid/com.questoid.sqlitebrowser_1.2.0.jar.zip
Requirements and how to use CellObject SQLite & XML Browser at
http://cellobject.net/Tools/CellObjectSQLiteXMLBrowser.aspx
Java Sources at Google Code :
http://code.google.com/p/cellobject/source/browse/
-----------------------------------
How To Install:
Inside the downloaded .zip/.tar file there's a .jar file named net.cellobject.sqlitexmlbrowser_1.2.0.jar.
Just copy this jar file into the "plugins" folder of your eclipse installation directory, then restart your eclipse.
That's it.
I needed to create an SQLite database for an Android application I was working on. I wanted to browse the database of my application from within Eclipse, instead of pulling it out and browsing with another application.
If you just want to do a little bit of debugging, see if your tables get created the way you want and similar things, there is a very nice plugin for Eclipse that might fit you:
- Download the CellObject SQLite & XML Browser plugin.
- Unzip it
- Put the .jar file you just extracted inside your eclipse plugin folder (/plugins)
- restart Eclipse.
- Start your emulator or plugin in the device on which you installed the application you want to test
- Open the DDMS perspective in Eclipse (Window —> open perspective —> other —>DDMS)
- Select your application database (you find it under data/data/[yourapplicationpackage]/databases)
- Now click on the icon of CellObject browser on the upper right, it will open the CellObject SQLite Browser View.
adb shell
sqlite3 /data/data/com.app.name/databases/DatabaseName.db
adb pull /data/data/com.app.name/databases/DatabaseName.db .
sqlite3 DatabaseName.db
Other solution :
http://www.mysamplecode.com/2011/06/android-emulator-sqlite-database.html
http://sourceforge.net/projects/sqlitebrowser/
http://sqlitebrowser.sourceforge.net/images/slackware9.jpg
http://sourceforge.net/p/sqlitebrowser/svn/73/tree/trunk/src/
Do you have the Jar file for the plugin? their website is down and cannot get it.
ReplyDeleteI have updated the post with alternative download links
Delete