Question for member dglass

[Jerryab]

Hello, dglass

In this thread >http://forums.runrev.com/viewtopic.php? ... lob#p39671 Re: Read an image from SqlLite database

you posted: I'm pretty sure there's a later post in that thread the explains how to do it 'properly', i.e. without the need to base64 the imagedata.

I have searched hi and low for this information and can not find it. Could you post a link to this.

Finding information on storing/retrieving images in Blobs for SQLite is very limited for LiveCode. I know base64code is not the best for images in blobs.
I have done this in another language (LUA) but it does not work in live code.

Any help on this would be very much appreciated.

[bn]

Hi Jerry,

I know nothing about databases.

I did a quick search on the runrev use-list archived among other places here

http://runtime-revolution.278305.n4.nab ... 78306.html

I searched for

blobs image database

I got some hits and this one seems to be relevant for your question

http://runtime-revolution.278305.n4.nab ... 20886.html

I have no idea if this solves your problem.

Kind regards

Bernd

[mwieder]

Jerry-

base64encoding the binary data is probably the easiest way to go, but as you noted it will bloat your data storage. You can also try this method of storing and retrieving binary data from the database.

http://forums.runrev.com/viewtopic.php? ... e64#p22895