On 25 Sep 2015, at 2:39am, Allen <allenpmd at gmail.com> wrote: > I wanted > to confirm the readers would work correctly while another connection > held an EXCLUSIVE lock, because if they didn't, and the lock > eventually went EXCLUSIVE automatically, that might be a problem,
Don't forget to have each connection set a timeout using one of <https://www.sqlite.org/c3ref/busy_timeout.html> <https://www.sqlite.org/pragma.html#pragma_busy_timeout> This makes SQLite automatically retry (using monotonic backoff) if the database is locked. Simon.