Use WAL mode for sqlite log?

[poVoq]

Feature Description

WAL mode for Sqlite is significantly faster and more resilient than the default methode, especially on modern filesystems like Btrfs, see: https://wiki.tnonline.net/w/Blog/SQLite_Performance_on_Btrfs

Would be nice if this could be used by default.

Thanks!

[brunnre8]

more resilient it is not, speed? Depends on what you do.
The trade offs are enumerated in the sqlite docs quite well.

WAL might be a good for for us though, considering we are mostly append only and write heavy.

The EBUSY stuff could be interesting and we'd need to catch that in the db and retry accordingly