Hot take: MySQL has been rock solid for
@pixelfed and
@loops.
Zero re-indexing. Zero performance tuning. It just works, even at pixelfed.social's scale (2nd biggest server).
I know postgres is popular in the fedi, but for me? LEMP stack has delivered reliability when it matters most.
Sometimes boring tech wins. π