FYI
https://github.com/chetmurthy/myxogastria/tree/main/docs
This collection of documents describes a design for a Twitter replacement system, "Myxogastria". Alternate name "Linepithema".
High-Level Goal of the Design
The goal of this design a system that will feel like Twitter to users — from the POV of what data they see, what interactions they can perform — and yet will be fully federated and sharded, in the sense that a typical instance (in the sense of Mastodon) need not contain more than a small fraction of the entire data-set of the system.
It is also designed to be efficient and wherever possible to not repeat computations, repeat data transfers, that were already performed.