Re:Consider SQLite
by metaltyphoon on Thursday December 30, 2021 @03:03AM
(#29734703)
I wouldn’t use a SQLite file over NFS. It has caused me locking problems when used by multiple clients.
[ Parent
| on HN ]
NFS does have a relatively low limit in terms of lock. For some use cases it can handle it fine.
Having clients running on read-only mode, when possible, can help.
Also partitioning the database can help, but then it's too much trouble already.