Where I can access Databases in Eclipse for Android development?

Question

I apologize if this is a stupid question, nevertheless I need to ask. I am new to Android development and have gone through every single tutorial and reference provided. I have been doing great, with the exception of one stupid problem; I cannot find where the databases for some apps are stored.

For example I would like to build my own app that includes thousands of pre-made records from an established SQLite Database. As a reference I tried to use the "Searchable Dictionary" app from the provided programs in the Android SDK, but cannot find it.

I read that all databases are stored in /data/data//databases on the device, but I cannot find this location. So how would I access the database in Eclipse or anywhere else for that matter to set up my pre-configured database?

Thanks so much!

Answer 1

Assuming your package for your app is com.example.androidapp and the database name is db you can do the following:

adb shell

and then in the command line shell

cd /data/data/com.example.androidapp/databases
sqlite3 db

and then in the sqlite3 interface e.g.

.schema

or

SELECT * FROM tablename;

and so on.

Answer 2

not directly in eclipse, but sqlite db browser is petty nice http://sqlitebrowser.sourceforge.net/