2 ms·
A lot of these aren’t defaults because of backwards compatibility. IMO there is no reason to not use WAL mode, but it’s not default because it came later
by nemothekid 2y ago
A lot of these aren’t defaults because of backwards compatibility. IMO there is no reason to not use WAL mode, but it’s not default because it came later
- bruce511 2y agoAs long as all the processes are on the same machine the wal mode is a good idea. It's not good in the case where multiple machines are sharing the same database. Like say if you had a shared settings file which allowed multiple VMs to be set in one place. Obviously the same-machine situation is the most common. But you asked for a reason for when wal is not appropriate.
- prirun 2y agoThere is a list of 6 disadvantages of WAL mode on the SQLite site: https://www.sqlite.org/wal.html https://www.sqlite.org/wal.html