SQLite database on SD card

by

I haven’t tried to do what you describe there, but presumably it could be done and might work — with a few caveats. First, the external storage (SD card) is not secure, so any other application, or the user, could read/write to it. Second, as you noted, when it’s unmounted the DB goes away.

Because of these disadvantages, you would probably be better off to try to use an internal storage database (the default), that is small and possibly includes pointers to external data (like images or files) — that themselves can be on the external storage (and that have placeholders, or other handling, when the external storage is not available).

Still, if you want to try it, you might be better off override the getDatabasePath method of Context, such as with your own Application object, and then pass that into a regular SQLiteOpenHelper. Then you wouldn’t have to worry about the cursor factory (which is optional, as the source confirms — so just pass null if instead you want to go that route).

More Related Contents:

  1. I am getting this error on my code [closed]
  2. Sqlite for Android
  3. How can I avoid concurrency problems when using SQLite on Android?
  4. How to store(bitmap image) and retrieve image from sqlite database in android? [closed]
  5. Best way to work with dates in Android SQLite [closed]
  6. How do I join two SQLite tables in my Android application?
  7. How can I create a user-defined function in SQLite?
  8. How do I transfer an image from its URL to the SD card?
  9. SQLite Android Database Cursor window allocation of 2048 kb failed
  10. Android Open External Storage directory(sdcard) for storing file
  11. Android SQLite: Update Statement
  12. How to delete SQLite database from Android programmatically
  13. How do I create a database in android? [closed]
  14. Android SimpleCursorAdapter doesn’t update when database changes
  15. How to implement Export sqlite To excel/csv file in android?
  16. How to store and retrieve a byte array (image data) to and from a SQLite database?
  17. SDCard content exist but cant see them
  18. problem about sqlite database, no such table:
  19. Getting all the total and available space on Android
  20. Using the LIMIT statement in a SQLite query
  21. Android: Display Image from SD CARD
  22. sqlite encryption for android
  23. Retrieve large blob from Android sqlite database
  24. Attempt to reopen an already-closed object sqlitedatabase
  25. How insert image in room persistence library?
  26. How to access an existing sqlite database in Android?
  27. DB File in Assets Folder. Will it be Updated?
  28. Compare dates (stored as string) in android sqlite database?
  29. Queries with prepared statements in Android?
  30. Backup Room database

Leave a Comment