Have you had a chance to look at atproto? I was a bit surprised to see no mentions of it. It powers Bluesky but is not coupled to it — the idea is essentially that your public data is meaningfully owned by you (can move hosting without losing identity) across all applications in a global collection, and different app backends can “derive” aggregated views (like Bluesky’s database) from the public network data of all users.