Where is SQLite database located on android

Question

I'm new to programing for android and i'm still learning. So I have a question about the location of the SQLite database. Is it stored in the same file system as the application ? And also i'm not sure can the database be created before the app is installed(can it come with the app) or can the database only be created from inside the app ?

And what if i wanted my app to come with a database that already has tables and records which is local and not on a server. Would that be possible ?

score 0 · Answer 1 · answered Aug 05 '13 at 20:44

0

Database is created after the app installation or after the db changes. The db is stored in /data/data/your_package/databases/

answered Aug 05 '13 at 20:44

be4code

688
4
15

actually you can create your own context for db where you can set path for the db - local or on the SD card. – pvllnspk Aug 05 '13 at 21:10
From what API is it possible? – be4code Aug 05 '13 at 21:14
Thanks. But what if I wanted that the app would come with a database which already has records and is local not on a server ? – tdxius Aug 05 '13 at 21:16
@Rafaeelloo : start from here http://stackoverflow.com/questions/14373863/how-to-store-sqlite-database-directly-on-sdcard – pvllnspk Aug 05 '13 at 21:32
@TDX - try to google with something like this "How to use an existing database with an Android application ..." – pvllnspk Aug 05 '13 at 21:35
@burn.gumbl : thanks, I was thinking that is an option like `saveOnSdCard(true)` – be4code Aug 06 '13 at 07:08

score 0 · Accepted Answer · answered Aug 05 '13 at 20:44

0

SQLite is available on every Android device. Using an SQLite database in Android does not require any database setup or administration.

You only have to define the SQL statements for creating and updating the database. Afterwards the database is automatically managed for you by the Android platform.

Access to an SQLite database involves accessing the filesystem. This can be slow. Therefore it is recommended to perform database operations asynchronously, for example inside the AsyncTask class.

If your application creates a database, this database is by default saved in the directory DATA/data/APP_NAME/databases/FILENAME.

The parts of the above directory are constructed based on the following rules. DATA is the path which the Environment.getDataDirectory() method returns. APP_NAME is your application name. FILENAME is the name you specify in your application code for the database.

You can also follow this tutorial for further understanding.

http://www.androidhive.info/2011/11/android-sqlite-database-tutorial/

answered Aug 05 '13 at 20:44

Jaffar Ramay

1,147
8
13

Kindly don't forget to ACCEPT the answer if it clarified your questions. – Jaffar Ramay Aug 05 '13 at 20:44
But what if i wanted my app to come with a database that already has tables and records which is local and not on a server. Would that be possible ? – tdxius Aug 05 '13 at 20:57
Basically you precreate your database, put it in your assets directory in your apk, and on first use copy to "/data/data/YOUR_PACKAGE/databases/" directory for further reading http://www.reigndesign.com/blog/using-your-own-sqlite-database-in-android-applications/ – Jaffar Ramay Aug 05 '13 at 21:58
Kindly don't forget to ACCEPT the answer if it clarified your questions. – Jaffar Ramay Aug 05 '13 at 21:59

Where is SQLite database located on android

2 Answers2