losfair / mvsqlite

Distributed, MVCC SQLite that runs on FoundationDB.
https://github.com/losfair/mvsqlite/wiki
Apache License 2.0
1.39k stars 39 forks source link

vfs: Commit hook #2

Closed losfair closed 2 years ago

losfair commented 2 years ago

Transaction commit is done in the xUnlock VFS method currently. When concurrent read-write transactions happen on the same DB, all except one writer process is abort()-ed so the application doesn't wrongfully think its transaction was committed. This behavior is not optimal.

A better option is to use commit hooks.