3 ms·
Can anyone share their experiences using SQLite over NFS? It seems like SQLite has major caveats here (no WAL, dot-file locking); how much of a headache is it?
by ridiculous_fish 5y ago
Can anyone share their experiences using SQLite over NFS? It seems like SQLite has major caveats here (no WAL, dot-file locking); how much of a headache is it?
For context, fish shell is considering using SQLite for history, but some users have NFS home directories.
- nikisweeting 5y agoA big headache in my experience. Different NFS servers lie about whether or not they really fsync writes when the clients request it, so you can end up with clobbered writes and corrupted databases in the worst case, and lots of "database is locked" errors that persist for longer than they should in the best case.