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