Hi

I use Eclipse 3.5.2 and android-sdk_r05-windows package. I develop an android 1.6 project in it. I could create a new sqlite database and table, insert, update and delete it. Here, I don't know how to browse sqlite database. I mean in mysql, we could browse it in command prompt and in ms sql, browse it from Management Studio. In SQLite, how to? Thank you.

I use SQLite Manager plug-in on FireFox. I usually pull that database from emulator or device, and open it by SQLite Manager.

You have a plugin called Questoid Sqllite manager, it is a plugin for Eclipse. Add it to program and then in ddms you can open your database and view it. It's by far easiest way to view it.

if you want the hard way go to command prompt
then type in the following I'm assuming that your package is anddev.android

Code: Select all

adb -s emulator-5554 shell
          #sqlite3 /data/data/anddev.android/<databaseName>.db