One of the reasons I started writing Marmot ( https://maxpert.github.io/marmot/ ) was for replicating bunch of tables across regions that were read heavy. I even used it for cache replication (because who cares if it’s a cache miss, but a hit will save me time and money). It’s hard to make such blue prints in early days of product, and by the time you hit a true growth almost everyone builds a custom solution for mul…
Also, very interesting project. I love SQLite and what the community is contributing to it - yours included!