3 ms·
A different approach to backups is an important aspect here. Also, writing-heavy things can get trickier with concurrency and locks. BLOBs usually have a more
by fforflo 2y ago
A different approach to backups is an important aspect here.
Also, writing-heavy things can get trickier with concurrency and locks. BLOBs usually have a more archive nature.
In a scenario where I had a 5-10MB pdf document (BLOB) for each 4KB JSON document, I had to store these in separate db files.
When I want to use them within the same query, I would use ATTACH https://www.sqlite.org/lang_attach.html https://www.sqlite.org/lang_attach.html