SQLite Forum

Can sqlite blob field be appended with data?

Can sqlite blob field be appended with data?

(1) By maxbad on 2021-03-24 01:43:08 [link] [source]

A large piece of binary data is written into the blob field in batches

(2) By Larry Brasfield (larrybr) on 2021-03-24 01:59:46 in reply to 1 [source]

Because you question is unclear, I paraphrase it thusly: Can a blob stored or just inserted into the database be grown with new data appended?

Strictly speaking, that cannot happen just as stated. The APIs support whole-blob insertion (via sqlite3_bind_blob(...)) or streaming of data into a pre-existing blob (via sqlite3_blob_open(...) and associated APIs). Neither grows a blob in-place such that it can be accurately said to have been appended.

(3) By maxbad on 2021-03-25 01:20:37 in reply to 2 [link] [source]

I don't expect it to work, thank you