SQLite Forum

Write large blob, > 2GB
Login
Although blobs (and strings) are presently limited to length 2^31-1, (per [Limits in SQLite](https://sqlite.org/limits.html), at section 1), those ..blob64 APIs evince a clear intention to expand that limit. (Otherwise, they would be useless.) There have been recent changes allowing increased DB size as well.

Hence, to your question,

> Any chance sqlite3_blob_write64 to be added soon?

, the answer seems to obviously be "yes".

As to whether there is a work-around, the above-referenced limits say "no".

You may have noticed that the ..blob64 APIs were not documented except for signature.  Perhaps a note in the function description text should state that the 2^31-1 length limit still applies.  (Or, if not, the limit needs restating.)