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