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.

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.