Home ›

SQLite

Debugging database

Fri, 03/12/2010 - 02:25 | by gabor
SDK Version: 
M3

When I first tried to manage an sqlite database on an android 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.

NewsDroid RSS Reader

Sat, 12/01/2007 - 20:10 | by hobbs
SDK Version: 
M3

In Hello Android's first tutorial we will walk through creating a simple RSS reader. This tutorial will show you how to parse XML files and use the SQLiteDatabase for storage.

Syndicate content