Hello Andrew, Tuesday, April 10, 2007, 3:25:29 PM, you wrote:
AF> Using sqlite3 (3.3.15 or later), is there a method to retrieve portions of a AF> blob rather than the whole thing? AF> The equivalent concept in Oracle's programmatic interfaces to C/C++ is by AF> retrieving a "blob locator" structure instead of the blob itself, and then AF> using procedural code to access as much of the blob through the blob_locator AF> as you wish, piecewise, over time. AF> If not, would others find it useful and handy? AF> My actual use case is to be able to stream in audio data from a BLOB located AF> within the larger database archive. I am aware of alternative solutions, AF> such as storing the file (name) reference in the database and using standard AF> file operations to retrieve portions of the file; I haven't rejected those AF> solutions, I just prefer the "single archive package" solution for AF> distribution. :) AF> --andy Store the file in chunks and retrieve them a chunk at a time. Basically create your own random access method. -- Best regards, Teg mailto:[EMAIL PROTECTED] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
