Fossil Forum
Post: Is WAL mode safe and stable to use in Fossil?
SQLite WAL mode is not enabled by default. Is WAL mode safe and stable to use in Fossil? I know there are additional steps to manage the WAL journaling file when the repository database is moved, but are there any features that don't work properly or should be avoided when using WAL mode, and is Fossil tested in WAL mode. Also does backup, cloning, push and pull work seamlessly, and will the clones simply be clones without WAL turned off as the default? The intention is to use WAL only on the master server and not repositories cloned from it.
Is WAL mode safe and stable to use in Fossil?
Yes.
The Fossil self-hosting repository, this Forum, and SQLite all run in WAL mode. WAL is perfectly safe as long as you meet the requirements outlined in the WAL Documentation and especially:
All processes using a database must be on the same host computer; WAL does not work over a network filesystem.
As long as that is your case (and it is the case most of the time) WAL works great and is recommended.
and is Fossil tested in WAL mode.
Yes, I use WAL mode on many of my repositories.