News for hackers. Stuff that matters.
Re:Cross-Database Queries in SQLite by jasonjayr on Sunday February 21, 2021 @10:19PM (#26220478)
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.

Re:Cross-Database Queries in SQLite by mastre_ on Monday February 22, 2021 @01:31AM (#26221486)
Will give that a shot, thanks!
Re:Cross-Database Queries in SQLite by philipyoungg on Monday February 22, 2021 @07:15AM (#26223621)
Please update us about this!