[sqlite] Re: Longest "real" SQL statement

2007-05-10 Thread Charles Cazabon
Sorry for the lateness of this reply. I don't have the query anymore (wrote it at my previous job), and it wasn't specifically for sqlite, but here goes. A company I worked for built a system to calculate and report various health statistics from a huge database which was itself a composite of

[sqlite] Re: Longest "real" SQL statement

2007-05-09 Thread Dave Dyer
I've recently been storing images in Sqlite datbases, and for various reasons don't want to use the normal "blob" mechanisms. Consequently, a 10mb JPG image file would be encoded as slightly larger than 10mb sqlite "insert xx" command. The size of the commands required by this method is limited