Large images are not stored correctly in SQLite databases

Cook-E-team / Cook-E

A mobile application that helps schedule cooking with multiple recipes

GNU General Public License v3.0

2 stars 1 forks source link

Large images are not stored correctly in SQLite databases #13

Closed samcrow closed 8 years ago

samcrow commented 8 years ago

The DatabaseImageCache class silently fails to store some large images. app/src/main/res/drawable/test_image_1.png (595 kB) does not work, but app/src/main/res/drawable/small_image.JPG (103 kB) works.

SQLite has a configurable limit on the maximum size of BLOB fields. Android may set this limit relatively low.

A solution could either store the images somewhere else or scale the images down to reduce their size.

samcrow commented 8 years ago

The current solution stores images on the file system, working around this issue.