[slyall]

Some people have thought of this before. Here is one implementation

https://git.sr.ht/~martijnbraam/logbookd

Although I'm not sure it uses WAL2 mode, but that should be a trivial change.