On 9/4/15, Todd Biggins <tbiggins at gmail.com> wrote:
> Thanks Richard!
>
> So if we remove the remote machine and focus on the same host - running as
> a separate process based on System.Data.SQLite
> can I safely run a SELECT query without harming the database integrity or
> the 3rd party app writing to the database?

That's all you need to do.

There is one corner case:  If the main application is writing
extensively and the secondary reader app does a long-running read
transaction, the read transaction can prevent the main application
from resetting the WAL file.  This can cause the WAL file to grow very
large.  Everything should still work - it will just use more disk
space.  The WAL will reset automatically once the read transaction
completes.

-- 
D. Richard Hipp
drh at sqlite.org

Reply via email to