I'm also going down this rabbit hole, and it's about to get even crazier with multi-tenant SQLite[1] and Beamer[2] replication. It's not quite ready yet, but the foundation is there.

[1] https://www.youtube.com/watch?v=Sc4FJ0EZTAg

[2] https://www.youtube.com/watch?v=lcved9uEV5U