Browse an Android Emulator SQLite Database in Eclipse

UPDATE - It appears the Questoid SQLite Browser is no longer available from the maker's website, sorry! Perhaps this link will be of use: http://www.java2s.com/Code/Jar/c/Downloadcomquestoidsqlitebrowser120jar.htm

After a fresh format in Ubuntu I needed to browse an Android emulator's SQLite database inside Eclipse. After a bit of research, I recalled this is how it can be done with DDMS and a cool plugin for Eclipse called Questoid SQLite Browser.

1. Download the Questoid Plugin
2. Place the plugin .jar file in your Eclipse plugins folder (e.g. /usr/lib/eclipse/plugins)
3. Restart Eclipse
4. Start up an Android Emulator w/ Debugging in Eclipse
5. Switch to the DDMS Perspective in Eclipse
6. Go to the 'File Explorer' tab to locate your device's database file
7. Navigate to: e.g. 'data -> data -> com.myproject -> databases -> myproject
8. Open the database file in Questoid (see screen shot)
9. Switch to the 'Questoid SQLite Browser' tab that appears (mine appears next to LogCat by default)
10. Switch to the 'Browse Data' sub tab
11. Select your table from the drop down menu
12. Browse your data here and onward into the digital sunset

By clicking the icon, sqliteManager Window comes and here we can see the table structure.

and then the Browse Data tab shows the whole data

Hopefully i think you cleared all doubts about SqliteManager Plugin

Note : If you’re using a plug-in for which no Update Site is available, you can use the “dropins” folder in your Eclipse installation directory.

Plug-ins are typically distributed as .jar files. To add a plug-in to your Eclipse installation, put the plug-in .jar file into the Eclipse “dropins” folder and restart Eclipse. Eclipse should detect the new plug-in and install it for you.

Note : if your SQLiteManager Plugin is not enabled, then check your sqlite db file extension. It should be a “.db” extension.