Hacker News new | ask | show | jobs
by adius 883 days ago
That problem should be easily solvable by activating the WAL mode: https://www.sqlite.org/wal.html. Also make sure to set busy timeout to something > 0 (e.g. 5000 = 5 seconds). This will let the database simply try again with a backoff if the database is currently busy (which usually only spans a few milliseconds anyways). This solved many production problems for me.