Browse an Android Emulator SQLite Database in Eclipse

tyler's picture
Submitted by tyler on Tue, 01/18/2011 - 01:51

Category:

Tags:

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

Comments

Santosh Eswar (not verified)

Wed, 03/14/2012 - 03:23

Apart from viewing the database data can we edit the data in the DDMS itself...?

Thanks in advnce

tyler's picture

tyler

Wed, 03/14/2012 - 09:33

When I used Questoid and SQLite databases, I did not see any way to edit the data when in DDMS. Sorry.

It has been a long time since I have used this plugin, perhaps there is a new version with the feature you need.

These days I've been primarily working with HTML5 local storage instead of SQLite.

企业 (not verified)

Thu, 07/26/2012 - 08:55

I want to to thank you for this fantastic read!
! I absolutely loved every little bit of it. I have you book marked to
look at new stuff you post…

Thet Mon Aye (not verified)

Sat, 04/07/2012 - 05:19

hello, I am not sure why but I see all the icons except that open file in SQLite browser !! god ! how to navigate to data in details steps pls ...thanks in advanced..

Sunil Chavan (not verified)

Mon, 05/21/2012 - 05:41

I can't see sqlite browser...............

PR (not verified)

Mon, 05/28/2012 - 11:30

Hi Guys,

u have to copy the jar file inside the folder into your plugins directory. NOT the whole folder, just the jar file!

tyler's picture

tyler

Mon, 05/28/2012 - 11:57

HI PR, Thank you, I have updated the tutorial to reflect this note.

sand (not verified)

Tue, 07/17/2012 - 02:12

Thanks....:)

userjapan (not verified)

Thu, 01/17/2013 - 01:57

this will only work in emulator, but i develop android app using direct connection to a device like nexus7,galaxy,etc and when i check to DDMS, there's a data folder but it's empty. please help

tyler's picture

tyler

Thu, 01/17/2013 - 11:25

Sorry, I haven't yet tried this out on an actual device, only in emulators. I'd recommend searching around in the file system, specifically looking out for folders that are named com.MYPROJECT, hopefully that will find the database file you are looking for.

JavAndroid (not verified)

Fri, 02/22/2013 - 11:14

Hi Tyler, thanks for the blog post. Altough the plugin doesn't allow edit of data or work on a real device, it is a good start for us programmers to tinker around.  This post helps a lot. Thanks again :)

SoftwareParadise (not verified)

Thu, 03/07/2013 - 02:05

Thank you so much.

It helped me a lot.

Instead of pulling the db out and browsing it from sqlite browser every tiem, now I can browse it in eclipse itself.

Anonymous (not verified)

Sat, 04/13/2013 - 07:14

i need the full information about sqlite........

tyler's picture

tyler

Mon, 04/15/2013 - 09:54

Please elaborate, I'm not sure what you mean.

Add new comment