Retrieve large blob from Android sqlite database

by

You can read large blobs in pieces. First find out which ones need this treatment:

SELECT id, length(blobcolumn) FROM mytable WHERE length(blobcolumn) > 1000000

and then read chunks with substr:

SELECT substr(blobcolumn,       1, 1000000) FROM mytable WHERE id = 123
SELECT substr(blobcolumn, 1000001, 1000000) FROM mytable WHERE id = 123
...

You could also compile your own copy of SQLite and access either the BLOB stream I/O functions or the normal query functions of the C API with the NDK, but that would be too complex in this case.

More Related Contents:

  1. Cursor size limit in Android SQLiteDatabase
  2. SQLite Android Database Cursor window allocation of 2048 kb failed
  3. What is The use of moveToFirst () in SQLite Cursors
  4. When does SQLiteOpenHelper onCreate() / onUpgrade() run?
  5. Where does Android emulator store SQLite database?
  6. Android SQLite Example [closed]
  7. Android database encryption
  8. Android SQLite DB When to Close
  9. Android SQLite issue – table … has no column named
  10. Android error – close() was never explicitly called on database
  11. What is a maximum size of SQLite database on Android?
  12. How to save images into Database
  13. Full text search example in Android
  14. How to get Last record from Sqlite?
  15. rawQuery(query, selectionArgs)
  16. select distinct value in android sqlite
  17. App Crashes On Startup Due To java.lang.IllegalArgumentException: column ‘_id’ does not exist
  18. A pre-populated database does not work at API 28 throws “no such table” exception
  19. How does one check if a table exists in an Android SQLite database?
  20. Could not allocate CursorWindow
  21. When should I do certain SQLite operations on another thread(not the main thread)?
  22. Changing values from Cursor using SimpleCursorAdapter
  23. SQLite exception: Database is locked issue
  24. How can I reset a autoincrement sequence number in sqlite
  25. Sqlite issues with HTC Desire HD
  26. SQLiteOpenHelper – creating database on SD card
  27. SQLite android column not found
  28. SQlite – Android – Foreign key syntax
  29. Inserting values to SQLite table in Android
  30. SQLiteOpenHelper onUpgrade() Confusion Android

Leave a Comment