Can sqlite blob field be appended with data?
A large piece of binary data is written into the blob field in batches
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.