SQLite Forum

In-memory database from sqlite file
> If there is some data in the database that you need to access even while it is locked, it might make sense to have the process that locks the database for exclusive access be the one that is responsible for making a copy of the relevant data for third parties to use. Or find a way to not hold long running exclusive locks.

Yeah we thought about that, but unfortunately the process holding the DB lock is a third party process that we have no control over :( thanks for the input anyways!