> What database technology or approach would you go for?
I feel like people consistently underestimate the difficulty of creating a data backend for a social network.
It has to be readable and writable in real time, yet still performant enough for picky consumers. It needs to be able to handle text search. It needs to handle many-to-many relationships at scale (something that mainstream (NO)SQL databases struggle with). It needs a robust authentication layer, and probably a load of other things on top of this.
Building something like Twitter is still, in 2022, a really hard technical challenge.