I am looking for a way to see realtime (as I debug) what is in my SQL database.
Does anyone know how to do this? I have tried looking through the variables tab but can't seem to find anything.
1
-
1This question, answered here, may help.omermuhammed– omermuhammed2011-06-13 16:42:57 +00:00Commented Jun 13, 2011 at 16:42
Add a comment
|
5 Answers
Open view Window->Show View->File Explorer.
In this view go to data/data/"your app name"/databases/"your database" This is you database file.
I use Questoid SQLite browser (It was available in www.questoid.com/Forums/tabid/59/aff/9/aft/7/afv/topic/Default.aspx) plugin for eclipse.
12 Comments
easycheese
I tried opening File Explorer, it comes up at the bottom but all of the options to open files, etc are grayed out...
woodshy
have you selected your database?
easycheese
Not sure what you mean, there is no option to select anything. There is nothing in the File Explorer Window. Do I need the plugin?
woodshy
refer developer.android.com/guide/developing/debugging/ddms.html DDMS provides a File Explorer tab that ... This feature is useful in examining files that are created by your application or if you want to transfer files to and from the device. To work with an emulator or device's file system: In the Devices tab, select the emulator that you want to view the file system for. To copy a file from the device, locate the file in the File Explorer and click the Pull file button. To copy a file to the device, click the Push file button on the File Explorer tab.
Marcin Orlowski
You need to root your device to be able to do so.
|
I don't know of any way to view it through Eclipse but you can perform queries on the database through the ADB. Check out Examining sqlite3 Databases from a Remote Shell.
1 Comment
easycheese
Thanks, I'm going to try one of the plugins someone mentioned first. I would prefer an Eclipse option as opposed to ADB.
Hi I just found how to show tables on eclipse,
if the database Icon still Gray :
Preference -> Android -> DDMS ->
select open in eclipse instead of save on the disqu...
good luck :)
Comments
Database is stored in data/data/your package name/your database name.
Comments
Follow below step:-
Download .jar file
Place the plugin .jar file in your Eclipse plugins folder (e.g. /usr/lib/eclipse/plugins)
Restart Eclipse
Start up an Android Emulator w/ Debugging in Eclipse
Switch to the DDMS Perspective in Eclipse
Go to the 'File Explorer' tab to locate your device's database file
Navigate to: e.g. 'data -> data -> com.myproject -> databases -> myproject
Open the database file in Questoid (see screen shot)
Switch to the 'Questoid SQLite Browser' tab that appears (mine appears next to LogCat by default)
Switch to the 'Browse Data' sub tab Select your table from the drop down menu Browse your data here and onward into the digital sunset
