On 4/10/07, Teg <[EMAIL PROTECTED]> wrote:

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> If not, would others find it useful and handy?

Store the file in chunks and retrieve them a chunk at a time.
Basically create your own random access method.


Following up, as of SQLite 3.4.0 there is a partial read and write of blob
interface from SQLite.  cf:
http://www.sqlite.org/capi3ref.html#sqlite3_blob


Thank you much, drh & company!

Reply via email to