Android Sqllite db is static or dynamic in nature?

Question

I'm very new to Android and I have some problem in understanding DB concept in android.

When I create my table in android does android give my app static space? Or the DB size grows in a dynamic way, when I add more data to it?

If it does grows in dynamic way how much space it can grow to the max?

And the DB that is been created by my app is persistent? Android guarantees me that my data wont be removed by the Android OS?

Answer 1

Sqlite is a database management system, but a very light version of sql. Yes Database's size grows as you enter the data into it's table. The data ( text,int,float,image ) it self is made of binary information so it is going to take place.

If it does grows in dynamic way how much space it can grow to the max?

It depends on your available space.

And the DB that is been created by my app is persistent? Android guarantees me that my data wont be removed by the Android OS?

Yes, data style is persistence, it will stay into system as long as you dont remove it by programmatically or by manually.

Answer 2

In android your DB is saved as a file in the internal storage allocated for your application and it is persistent.

The path to your dB in common is

/data/data/<your-package-name>/databases

See implementation limits here

Answer 3

There are main three question in single question

First

how much space it can grow to the max? see this

Second

DB that is been created by my app is persistent? see this

Last

Android guarantees me that my data wont be removed by the Android OS?

Once you have uninstall your app then you will not get back.May be other case if developer had store extra DB file in private path.

Answer 4

When you create a database from an application, the database is saved at /data/data/APP-Name/Databases. As you keep adding tables the size increases, the maximum capacity of the database is 140 Terabytes and it is persistent.