Load image from a SQLite database

Solar2D General Questions/Discussion
#1

Is there way to load an image that is stored in a blob field of a database, or alternatively save the field first as a file then load it from there?

Thanks in advance! Pete. [import]uid: 110859 topic_id: 25628 reply_id: 325628[/import]

#2

Anyone any ideas on this? [import]uid: 110859 topic_id: 25628 reply_id: 104186[/import]

#3

I would like to know the solution to this too.

#4

Corona SDK can only load images from the file system. You in theory could read blob data from the database, write it out as a binary file and then use display.newImage() or display.newImageRect() to load them in. However I have never believed that you should store image data in the database. By all means save the file name in the database. I don’t see the benefit of it.

Rob

#5

I would like to know the solution to this too.

#6

Corona SDK can only load images from the file system. You in theory could read blob data from the database, write it out as a binary file and then use display.newImage() or display.newImageRect() to load them in. However I have never believed that you should store image data in the database. By all means save the file name in the database. I don’t see the benefit of it.

Rob