News for hackers. Stuff that matters.

A comment on SQLite in production with WAL.

Re:SQLite in production with WAL by ridiculous_fish on Friday May 21, 2021 @04:38PM (#27239661)
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.

[ Parent | on HN ]
Re:SQLite in production with WAL by nikisweeting on Friday May 21, 2021 @04:46PM (#27239753)
A 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.
[ Parent | on HN ]