News for hackers. Stuff that matters.
Re:“POSIX advisory locks are broken by design” by pvg on Tuesday July 24, 2018 @09:33PM (#17606310)
there's a reason that databases have processes dedicated to writing

That's going to be a little tricky in an embedded db.

Re:“POSIX advisory locks are broken by design” by emmelaich on Tuesday July 24, 2018 @10:34PM (#17606543)
Sure, but you could still make sure writes are done in a mutex?
Re:“POSIX advisory locks are broken by design” by int_19h on Wednesday July 25, 2018 @03:12AM (#17607416)
Don't forget that it still needs to synchronize across process boundaries, too - two processes, both running SQLite, and both accessing the same database file, is a supported scenario.