FWIW, I‘ve seen consensus here on HN in another thread on SQLite-on-server, that there must indeed be a central DB for metadata (user profiles, billing etc), and all the rest is then partitioned.
Wrote a bit about it here: https://news.ycombinator.com/item?id=43246212