I only know of two FOSS federated alternatives to reddit which is lemmy or kbin.
I think lemmy will scalebmore being written in rust were kbin is written in PHP.
And by scaling I am refering to high user count, high traffic, server resoures, server cost.
Scaling databases, particularly the most used one, PostgreSQL, also seems to be an expertise somewhat lacking across the platforms.
Which I say only to highlight that anyone with experience and expertise on scaling and optimising PostgreSQL is likely to have something rather valuable to contribute to the fediverse if they are willing.
Yep, there’s a reason database admin is a career of its own. We use MySQL at work but same deal everytime: monitoring goes crazy and we poke the devs to fix their queries.
Been meaning to get familiar with Lemmy’s code soon, just need to find some free time 😅