Android - viewing SQLite databases on device?

views:

159

answers:

+1 Q:

Android - viewing SQLite databases on device?

Is there any tool that will allow me to browse databases on my Android device? Something like Sql Management Studio - you know GUI tool that displays databases, tables, row in tables, etc.

I'm using Eclipse for development (if it is important for plug-in suggestions).

Thanks!

+1 A:

First of all, you will not be able to 'browse' the databases unless you logged in as root (there are several tutorials out there that explains how to get root on Android). Secondly, you can use adb shell (adb is included into the SDK), and when you are there you can use the sqlite3 command to browse the databases.

Of course, sqlite3 does not provide a GUI... but, you can copy the database you want to browse to your computer and use any GUI for sqlite (http://is.gd/chWQ0) there.

Cristian 2010-05-20 20:34:49

Just to be clear, though, you have to have `root` access to even use sqlite3 from `adb shell`

Matt 2010-05-20 20:37:13

That's right... I was not clear enough.

Cristian 2010-05-20 20:47:05

+2 A:

My suggestion is to run your app on emulator (so you could copy db file right from ADT File Explorer) and then view it with SQLite Manager for Firefox.

alex 2010-05-20 20:39:53

ansaurus

tags:

views:

answers:

Android - viewing SQLite databases on device?

related questions