Android News Aggregator
Thursday February 9th 2012

Insider

Archives

Debugging database

When I first tried to manage an sqlite database on an adroid device I was not sure about where I fail in it. Can I even insert the records into the database, or I fail only to read the data from it? So I started to search for possibilities to debug the database lifecycle.

The system stores databases in the /data/data/package_name/databases folder by default.

In a command line using the adb (Android Debug Bridge – found in the android sdk tools library) you can access the databases on a running emulator like below:

  1. adb -s emulator-5554 shell
  2.  
  3. sqlite3 /data/data/package_name/databases/database_name

After this you can type normal SQL commands to test the content. For example:

  1. SELECT * FROM table_name;

This will list the table content (in an ugly format), or say that it does not exists.

read more

Read more @ Hello Android – Android OS news, tutorials, downloads

Leave a Reply

You must be logged in to post a comment.