SQLite Forum

Using WAL mode with multiple processes
Login
The documentation at [https://www.sqlite.org/wal.html](https://www.sqlite.org/wal.html) says that you can start WAL mode using:

    PRAGMA journal_mode=WAL;

If I have multiple processes running against the same file - one process that is just reading it, another one (or more) that are writing to it, how should I use this pragma?

If I've run it once in a process, will the other processes automatically pick it up?

Do I need to run the pragma before the other processes open their connections to the database file?

Does it even matter which process first executes the PRAGMA?

If my read-only process executes it, will it affect any other processes that attempt to write to that file?