This is awesome! We made similar functionality (plus more) available through an API. If anyone is interested to try it out and share feedback, please message me and I’ll hook you up.
The demo video you have is really well put together. The language is great, it has good pacing & touches all the right points. I really liked the tone & attitude of the person recording it. It's MVP'd in a way that it's not over produced, but uses simple tools to achieve a high quality regardless. Well done!
I was reading up on WAL mode this week and came across a mailing list where you asked for clarification on this same topic. That post helped me understand, thanks for asking the question! The confusing thing here for me is that the majority of other PRAGMAs (that I know of) are per-request, so this one differs from that pattern