SQLite Forum

Exclusive write-only lock? (Allow only one process read-write, and multiple read-only)
Login
Thanks, all, for the answers. My fault, I didn't formulate the question clearly. Certainly, I know that I can write and read with the same database and use corresponding flags. What I meant is if it was possible to _force any_  process that I may not be aware of (3rd party) to access the DB only in readonly mode when my app uses it. As I can see now, that's not possible. (I had a suspicion it could be possible when I saw there are distinct WAL locks used in the [WAL-index file](https://www.sqlite.org/walformat.html), e.g., `WAL_WRITE_LOCK` and `WAL_READ_LOCK`).