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

You might enjoy having a look at how atproto (which powers Bluesky) solves this: https://atproto.com/articles/atproto-for-distsys-engineers https://atproto.com/articles/atproto-for-distsys-engineers TLDR: Self-hosting is the source of truth for data; apps aggregate over it.