News for hackers. Stuff that matters.

A comment on SQLite is not a toy database. Parent comment

Re:SQLite is not a toy database by jyrkesh on Thursday March 25, 2021 @03:12PM (#26584170)
I learned this the hard way when I stuck some app containers down on a few RPis and mapped the folder of stateful stuff (including a SQLite database) to an NFS share on my NAS.

It's....not great.

[ Parent | on HN ]
Re:SQLite is not a toy database by bionoid on Friday March 26, 2021 @03:22AM (#26589587)
The FAQ suggests that NFS is problematic for concurrent access:

> But use caution: this locking mechanism might not work correctly if the database file is kept on an NFS filesystem. This is because fcntl() file locking is broken on many NFS implementations. You should avoid putting SQLite database files on NFS if multiple processes might try to access the file at the same time.

https://www.sqlite.org/faq.html#q5

[ Parent | on HN ]
Re:SQLite is not a toy database by jyrkesh on Monday April 05, 2021 @05:11PM (#26704793)
Oh yeah, I read all that after I started seeing problems, I know I'm in the wrong here. It works just good enough that I haven't addressed it yet (I just kick over the process when things get weird, and the db usually recovers just fine).
[ Parent | on HN ]
Re:SQLite is not a toy database by pdimitar on Thursday March 25, 2021 @06:45PM (#26586577)
Can't remember where did I read this now but about a year ago I have found material saying that sqlite3 over NFS is a very bad idea and even though it's supported it's also strongly advised against as a use-case.
[ Parent | on HN ]