Lol, #p2p #activitypub is like a trigger word activating my "infodump about databases" training.
Like my eyes just roll to the back of my head and I enter sicko mode. Really glad I wrote up that blog post so I can defer to it instead of flooding every single chat I'm in. :P
@lucid00 I wouldn't go that path personally. SSB is very slow at the moment. Maybe once all the new feed stuff lands it'll be a bit more doable tho. It's got the social-based replication down pat though!
@mauve lately what I've been wondering is how feasible would it be to use SSB as a transport and offline storage mechanism (like how SSB has blog feeds that store posts as blobs), and then have the HTTP side be a SSB Pub server that just publishes the posts as normal.