Display a Blob image from SQLite

Getting Started Newbie Questions
#1

I have an SQLite database with a bunch of png files stored as BLOB’s that I would like to be able to query out into an array and randomly display. I have searched for hours and have been unable to come up with any solution to this. The closest thing that I need I found here:

http://developer.anscamobile.com/forum/2011/04/25/image-memory#comment-form

but they had the same question I do with no replies. How do I display a blob directly from the SQLite database. Any help/direction is genuinely extremely appreciated. [import]uid: 81333 topic_id: 14377 reply_id: 314377[/import]

#2

Try writing the BLOB value into a file and saving it with a .png extension.

You should be able to use display.newImageRect with that newly written file then.

EDIT: Sorry, I see what you want to do now. Without writing to a file, I don’t know. [import]uid: 26769 topic_id: 14377 reply_id: 53215[/import]

#3

Can someone from the development team confirm whether it’s possible to display BLOB data? I’d have thought it would be a solution to the problem in Android of not being able to use subfolders, this way I could put all my images in an SQLite database.
[import]uid: 95579 topic_id: 14377 reply_id: 64472[/import]

#4

BLOB data can not be directly displayed. You would need to save it to a file first. [import]uid: 7559 topic_id: 14377 reply_id: 64771[/import]