3 ms·
I have a Google Cloud Function that uses SQLite to store a user's previous day tweets and do some minor sorting and filtering of data. Works very well and saves
by JustARandomGuy 6y ago
I have a Google Cloud Function that uses SQLite to store a user's previous day tweets and do some minor sorting and filtering of data. Works very well and saves me the cost of a "real" SQL instance.
- donut 6y agoWhere'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...