Can sqlite blob field be appended with data?
(1) By maxbad on 2021-03-24 01:43:08 [link]
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 [link]
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(...)](https://sqlite.org/c3ref/blob_open.html) 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
I don't expect it to work, thank you