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