https://www.sqlite.org/lockingv3.html https://www.sqlite.org/lockingv3.html explains what it wants to happen. Note in particular that multiple processes can re

https://www.sqlite.org/lockingv3.html https://www.sqlite.org/lockingv3.html explains what it wants to happen. Note in particular that multiple processes can read at a time, and only slowly escalate into a write lock which is held as short a time as you can before going back to the normal state. While NFS assumes that if you read, you may write, and may not take care to make sure you have the most recent version WHEN you write. (These are all important assumptions to make for random programs written by random programmers. Few programmers can be assumed to take the care that databases do around getting locking logic correct.)