On: Serverless SQLite

[donut]

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

[warpech → donut]

Two-phase commit[0] could do the job

[0] https://en.m.wikipedia.org/wiki/Two-phase_commit_protocol

[johncena33 → warpech]

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

[warpech → johncena33]

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...