Hello Petr,

You could Mime encode them to text, insert as a string. Pull them back
out as strings, un-mime them. Should be able to do that from a batch
file.

I  keep a bunch of images in Sqlite DB files. It's reasonably fast and
I like having them all in one place. Some of the DB files are > 10 GB.

C



Wednesday, January 18, 2012, 10:14:17 AM, you wrote:

PL> Because of packing. The script should be distributable as one
PL> .cmd file, the database engine and database itself will be embeded
PL> inside od script. Dealing with embeded files in the shell script
PL> is not easy thus I want to minimize its number.

PL> L. 

>> On Jan 18, 2012, at 12:00 PM, Petr Lázňovský wrote:

>>> have windows batch working with sqlite, may I insert image into database 
>>> and than read this images from?

>> As pointed out, you might want to use the 'blob' type to store binary data.

>> That said, why bother storing these images inside the database itself? Any 
>> benefit in doing so? 

>> _______________________________________________
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


PL> _______________________________________________
PL> sqlite-users mailing list
PL> sqlite-users@sqlite.org
PL> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



-- 
Best regards,
 Teg                            mailto:t...@djii.com

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to