For side projects or non-prod environments where a single instance is fine, I use sqlite + litestream and it works reasonably well. I've looked into the more complicated setups with LiteFS/Consul/RAFT and at that point I'm not sure you're saving yourself much headache over running your own DB.
