10

I'm planning Android app which extensively uses local DB. DB would contain approx 15 tables , properly normalized (FK, PK etc). 4 Main tables would have up to 1000 entries and about 15 columns with text, date/time and numbers only.

I wondering whether this configuration is feasible on Android phone/tablet. Am I pushing sqlite and Android OS to the limits? I cant find any firm figures about sqlite limitations on Android OS.

Many thanks

Vikas Patidar
  • 42,865
  • 22
  • 93
  • 106
David
  • 282
  • 1
  • 3
  • 12

3 Answers3

2

I compelety agree with @Amokrane's answer but insure that your database should also have backward compactibility. Because you are saying that your database is properly normalized (FK , PK etc). And here Foreign Key support is only available since the SQLite version 3.6.19 therefore this constraint could only be applicable on the Android 2.2 FroYo (which has SQLite 3.6.22 Version) and the above versions.

For more information refer : http://www.sqlite.org/foreignkeys.html

Vikas Patidar
  • 42,865
  • 22
  • 93
  • 106
  • Can you please provide a link to the source, where you've read that froyo supports this sqlite version. – WarrenFaith Feb 20 '11 at 17:17
  • 1
    @WarrenFaith:You can easily find it by using the commands **`adb shell`** and then **`sqlite3`** on your command prompt or terminal. It will displays all this information. See this link [Examining sqlite3 Databases from a Remote Shell](http://developer.android.com/guide/developing/tools/adb.html#sqlite) – Vikas Patidar Feb 20 '11 at 17:33
1

This official SQLite limits page contains many information that you might find interesting.

By the way, I don't think you are pushing SQLite to its limits 15 columns/ 1000 entries is not that huge!

Amokrane Chentir
  • 29,907
  • 37
  • 114
  • 158
1

I've provided an answer to a similar question here. There are details of soft limits and size limits for the table. As far as @Amokrane answer, you'll also need to be aware of limitations not imposed by SQLite, but by android. 50mb is the current maximum app size and there are issues with accessing large datasets on device. Take a look at that answer.

Community
  • 1
  • 1
Nick Campion
  • 10,479
  • 3
  • 44
  • 58