SQLite Database Images

I read Amir Ali's article on retrieving drawable images and storing them in a SQLite database, but the code was for only a single image.

In the app I'm currently developing, I need to display several images at once, plus then be able to display several new images on the next screen. With roughly 400 images in total to display.

I have my Database Table created with data type "BLOB" for the images, but in the table, how do I reference the specific images to go in place?

In the article there is the code:

img1 = c.getBlob(c.getColumnIndex("image"));
...
Bitmap b1 = BitmapFactory.decodeByteArray(img1, 0, img1.length);
imageView.setImageBitmap(b1);

Would I need to do that for every image and specifically put them in the table, or is there another way to reference them?

Thank you in advance for your assistance with my problem.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Oliver Mike6y ago
To store the image in an Android SQLite database, you must convert the URI image to bitmap, then to a sequence of bytes of binary nodes. [url=https://royalukessaywriters.co.uk/dissertation-writing-service/]online dissertation help[/url] set the data type of the table column to BLOB data type. After retrieving the image from the database, convert the byte data type to bitmap to set it as an image view.