Browse an Android Emulator SQLite Database in Eclipse

Category: 

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