3 ms·
Where's the SQLite database written? How do you ensure only one writer is modifying it?
by donut 6y ago
Where's the SQLite database written? How do you ensure only one writer is modifying it?
- warpech 6y agoTwo-phase commit[0] could do the job [0] https://en.m.wikipedia.org/wiki/Two-phase_commit_protocol https://en.m.wikipedia.org/wiki/Two-phase_commit_protocol
- johncena33 6y agoHow do you do two phase commit on a sqlite database file?
- warpech 6y agoI 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-using-sqlite-Ken-td33882.html http://sqlite.1065341.n5.nabble.com/Re-Two-Phase-commit-usin...