is there some way I can view a SQLite db?

Question

I'm encountering a very odd behavior where a SQLite db entry is not throwing any exceptions, but when I later do a select where I search for the row I have inserted, it doesn't turn up.

I'm at a loss as to how to debug this, as I have no way to verify that the insert is actually working. I've examined all the SQL calls and they look right, so now I'm just stuck.

Is there a phone resident db tool of some sort that I can use to view the db? Or an ADB command line SQL thing of some sort?

Walt Armour · Accepted Answer · 2011-07-28 00:05:11Z

3

Yes. ADB will let you examine databases from the shell.

See this page on the Android site: http://developer.android.com/guide/developing/tools/adb.html#sqlite

answered Jul 28, 2011 at 0:05

Walt Armour

3543 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Shaunak · Accepted Answer · 2011-07-28 00:05:22Z

1

If you want this for development - you can use MOTODEV Studio from Motorola It has UI for SQlite. Its free!

answered Jul 28, 2011 at 0:05

Shaunak

18.2k5 gold badges59 silver badges86 bronze badges

1 Comment

Eric Cloninger Over a year ago

thanks for the mention. Yes, you can use MOTODEV Studio to view a database on the emulator or a developer/rooted phone. If the database is on a commercial phone, you will need to store it to the SD card on the phone explicitly with the CreateDatabase() API using '/sdcard/myfolder/mydb.db'.

Nikola Despotoski · Accepted Answer · 2011-07-28 00:06:01Z

1

Pull out the db file from the emulator. Open it with SQLite Browser.

And there are adb commands:

$ adb -s emulator-5554 shell
# sqlite3 /data/data/com.example.google.rss.rssexample/databases/rssitems.db
SQLite version 3.3.12
Enter ".help" for instructions
.... enter commands, then quit...
sqlite> .exit

answered Jul 28, 2011 at 0:06

Nikola Despotoski

50.7k15 gold badges124 silver badges151 bronze badges

Collectives™ on Stack Overflow

is there some way I can view a SQLite db?

3 Answers 3

Comments

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Related