regarding multiple writes - I think hardest part would be to find an sqlite version where "read is a combination of all the files". Speaking of multiple writer

regarding multiple writes - I think hardest part would be to find an sqlite version where "read is a combination of all the files". Speaking of multiple writers, I've recently heard about "BEGIN CONCURRENT" feature of SQLite [1] - currently it lives on its separate branch, but I hope they will eventually merge it to the main branch. Not sure if it can be used in your case, but worth mentioning anyway, I think. [1]: https://www.sqlite.org/cgi/src/doc/begin-concurrent/doc/begin_concurrent.md https://www.sqlite.org/cgi/src/doc/begin-concurrent/doc/begi...