Hacker News new | ask | show | jobs
by jasonjayr 1941 days ago
Have you tried journal_mode=wal?

https://sqlite.org/pragma.html#pragma_journal_mode

This lets sqlite read w/o a write lock (among other things)

Since it stores the log to an adjacent file you have to make sure the process can write to the whole directory containing the db.

1 comments

Will give that a shot, thanks!
Please update us about this!