[danabramov]

You might enjoy having a look at how atproto (which powers Bluesky) solves this: https://atproto.com/articles/atproto-for-distsys-engineers

TLDR: Self-hosting is the source of truth for data; apps aggregate over it.