Hacker News Reader

Where's the SQLite database written? How do you ensure only one writer is modifying it?

Two-phase commit[0] could do the job

How do you do two phase commit on a sqlite database file?

I don't know SQLite specifically, but I think that it can be implemented in the application logic using the primitives of any RDBMS. This old thread suggests that http://sqlite.1065341.n5.nabble.com/Re-Two-Phase-commit-usin...