SQLite Forum

Incremental Blob I/O and virtual tables
As far as I know, it is not implemented (and can't be implemented with the current virtual table module structure without "faking it"). But it is a feature I also wanted, to add such things like:

int(*xBlobOpen)(sqlite3_vtab*,int writeable,sqlite3_int64 rowid,int column,sqlite3_vblob**out,int*size);
int(*xBlobRead)(sqlite3_vblob*,unsigned char*buf,int offset,int length);
int(*xBlobWrite)(sqlite3_vblob*,const unsigned char*buf,int offset,int length);