SQLite Forum

Write large blob, > 2GB
Login
There are 4 APIs that allow writing blobs in excess of 2 GB,

* `sqlite3_bind_blob64` from https://www.sqlite.org/c3ref/bind_blob.html
* `sqlite3_bind_zeroblob64` from https://www.sqlite.org/c3ref/bind_blob.html
* `sqlite3_result_blob64` from https://www.sqlite.org/c3ref/result_blob.html
* `sqlite3_result_zeroblob64` from https://www.sqlite.org/c3ref/result_blob.html

Yet _Incremental Blob IO_ is still limited to 2GB **offsets**.

That the count be limited to 2GB (signed int), that's OK. But  
that offsets cannot be >2GB, that's a real issue; arguably where  
incrementally writing a blob is the most useful. See

* https://www.sqlite.org/c3ref/blob_read.html
* https://www.sqlite.org/c3ref/blob_write.html

Is there a work-around?  

Any chance `sqlite3_blob_write64` to be added soon?  
Same for _read64_ of course.

PS: In this case, I have a 3.5GB blob