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.

Reply via email to