basequal@lemmy.worldtoLemmy Server Performance@lemmy.ml•GREAT NEWS about Lemmy Server Performance, another major SQL mistake has been discovered today: every single comment & post create (INSERT) is updating ~1700 rows in the site_aggregates table
34·
1 year agoI am always fascinated with these types of comments, specifically for a free and open-source software. There are lemmy instances supporting hundreds of thousands of users and trafic, feedback from both server owners and lemmy devs is almost instantaneous.
A platform like lemmy requires client side knowledge to build both desktop and mobile UI (that are performant), it requires ActivityPub knowledge to integrate with the Fediverse, it requires backend knowledge to build APIs for 100% feature compatibility with 3rd party apps. It requires DB knowledge to optimize queries, it requires devops / platform knowledge to deploy it.
And all of this is built in public.
BuT LEMmY tEaM lAcks dEvEloPmenT SkiLL – sure buddy.
I’m sorry to bring up Reddit, but being interested in US politics (I’m not from the US) I’m impressed with the level of discussion here.
Almost every political reddit comment section I’ve encountered was a cesspool of such polarized left vs right opinions that anything more nuanced and centered was buried right away.