Hello Bruce,

Monday, December 7, 2009, 1:20:10 AM, you wrote:

BR> On Dec 6, 2009, at 6:17 PM, Jean-Christophe Deschamps wrote:

>> I was simply replying to the OP's actual question:
>> 
>>>>> From what I read, it is necessary to have a programmatic interface to
>>>>> put images into a database.  True?
>> 
>> So, no, it isn't _necessary_ (but recommended). 

BR> What is "programatically"

BR> How, in any meaningful way, is this different than running a
BR> shell command (program of an extremely brief size)?

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

Does the shell command have an interface for specifying on disk objects
to insert as blobs? Might be a neat addition.

"INSERT INTO BLA.....'file:/tmp/bbies.jpg'..."

I do it programmatically. I wrote an image interface class for
inserting, deleting and searching on hashes, filenames and meta-data.

Before the parameterized inserts were the norm, I used to encode my
blobs before insert. Using the newer interface, it's pointless to
encode. I crank the page size up to max for my image databases too.



-- 
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