1

I'm developing simple application for collecting expenses. For now I keep data using SQLiteDatabase. I have 2 questions:

1) When I clear application data in Settings->Application then SQLite db is lost. Is there any way to keep data permanently on device even if application will be deleted ?

2) How about SQLite db capacity ? In case of my app, it should keep data from several months or years. Does sqlite db on android have any size restrictions ?

jason_becker
  • 71
  • 6
  • Regarding question one, one idea is to move your database to external storage. – tidbeck Jan 18 '12 at 14:42
  • for the backup of data see http://developer.android.com/guide/topics/data/backup.html – deepak Sharma Jan 18 '12 at 14:45
  • Depending on the amount of information and desired visual style, you could create a CSV (comma-separated values) file that is saved on the SD card. This could then be viewed on the device, or imported into a spreadsheet program. – cornbread ninja Jan 18 '12 at 14:47

1 Answers1

0

1) No, and you don't want that. When the user deletes the application, he doesn't want any data left on his device. That would be bad practice, and people would give you bad reviews for that.

2) I don't think there's any limit, it will depend on the physical storage available. Check that for more metrics around SQLite.

Also, this has some useful information.

Community
  • 1
  • 1
Guillaume
  • 22,694
  • 14
  • 56
  • 70