While Android
puts a powerful built-in database at your disposal, it doesn't come with the
best set of debugging tools. In fact, unless you have a rooted device, you can't
even get the SQLite tables off your device
without jumping through some hoops.
Fortunately, the Android emulator
doesn't have this restriction.
Within Eclipse, you need to switch to DDMS mode by going to Window | Open Perspective | DDMS. If you've never used DDMS, you'll likely need to go to Window | Open Perspective | Other and then browse for DDMS within the list
Once the DDMS view is active, choose the File Explorer tab. You'll find your database in the /data/data/your.app.namespace/databases directory. There are two virtually indistinguishable icons in the upper right-hand corner of the tab that represent a pull and a push of a file, respectively. Use the pull icon (the one on the left) to save a copy of the SQLite database to your development machine and change extension of the copied file to .sqlite
Now you have a copy of your database on your workstation, but you still need some kind of SQLite viewer to take a peek. I use SQLite Manager, because it is free and runs well
Open the SQLite Manager in the fire fox and select connect database option as shown below
Once you select browse for the file which you have saved in your workstation .
Done:)
You can browse and check your data
Within Eclipse, you need to switch to DDMS mode by going to Window | Open Perspective | DDMS. If you've never used DDMS, you'll likely need to go to Window | Open Perspective | Other and then browse for DDMS within the list
Once the DDMS view is active, choose the File Explorer tab. You'll find your database in the /data/data/your.app.namespace/databases directory. There are two virtually indistinguishable icons in the upper right-hand corner of the tab that represent a pull and a push of a file, respectively. Use the pull icon (the one on the left) to save a copy of the SQLite database to your development machine and change extension of the copied file to .sqlite
Now you have a copy of your database on your workstation, but you still need some kind of SQLite viewer to take a peek. I use SQLite Manager, because it is free and runs well
Open the SQLite Manager in the fire fox and select connect database option as shown below
Once you select browse for the file which you have saved in your workstation .
Done:)
You can browse and check your data
No comments:
Post a Comment