SQLite Forum

Changes to support concurrent writes to wal database distributed over network FS
Login
I want to distribute a sqlite database using ceph and let multiple nodes have RW access.
I believe some small changes will allow this. Split WAL into multiple files, each node have exclusive write access to one and read access to all. Only one node is allowed to merge wal files. And a lookup will then require reading all wal files, I don't think this is a huge drawback since number of network nodes usually is small.
This change should allow high concurrent writes while not causing db corruption.. if I'm not missing something.

What do you think about this?