News for hackers. Stuff that matters.
Re:Show HN: Versioning Filesystem for SQLite by punnerud on Sunday August 28, 2022 @12:01PM (#32629413)
Could this be used to have multiple writes? where every write have their own sqlite3 and read is a combination of all the files
Re:Show HN: Versioning Filesystem for SQLite by Lex-2008 on Sunday August 28, 2022 @02:58PM (#32630970)
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/begi...

Re:Show HN: Versioning Filesystem for SQLite by devnull3 on Sunday August 28, 2022 @12:05PM (#32629440)
Not sure I understood your question fully, but if there are multiple versions, then read will be over multiple files but writes go to a single active version.
Re:Show HN: Versioning Filesystem for SQLite by remram on Sunday August 28, 2022 @02:32PM (#32630747)
Each writer can get its own branch but you would never be able to re-combine them.