SQLite Forum

Is write permission required for read-only connections on a WAL database?
Login
Hello,

I can't quite figure out, reading https://www.sqlite.org/wal.html, if the sentence below implies that readers must have write permission on some database file or directory:

> A long-running read transaction can prevent a checkpointer from making progress

Surely the only communication channel between readers and writers is the file system, isn't it?

To ask the same question in another way, can a unix user with only read permission on a database and its directory open a read-only connection on a WAL database and still expect to be able to be granted with snapshot isolation even if there are concurrent writers?

Thank you very much for your answer,

-- 
Gwendal Roué