Hello all, I've been digging through SQLite.org and these forums, but I was hoping for a final consensus on my conundrum:
I have a third party app that is writing to a local v3.0 SQLite database with WAL. I want to access it outside of the existing app solely for the purpose of SELECT queries (using System.Data.SQLite) - these queries would be run by only one other process, either from the same host or a remote machine (by sharing the database folder through NTFS/SMB) Am I able to run SELECT queries without altering the database integrity for the other app? Since the database is using WAL, it looks like I need write access to the folder structure, and even a SELECT query attempts to generate the -WAL and -SHM file on the database - files which already exist from the 3rd party app. To reiterate - is there a "safe" way to use System.Data.SQLite to passively view tables without altering the database or its cache? Thanks so much for your time!
