Shit dude, you still going on about the GitHub issues?
Is it your cult loyalty to the pro-China project leaders speaking? The authoritarianism that you honor? Do you have blind faith in machine code and are unable to see the level of effort they make to avoid the performance critical code in the application?
Did their words "high performance" on GitHub mesmerise you into believing it without actually installing the Rust code and looking at their performance your own self?
It's amazing how you have fallen hook line and sinker into believing that the problem is difficult to solve. It's the agenda that is the problem.
They have people like you who will not read actual code to see that they only care about the fact that "Rust is cool programming language" and crashing code doesn't get any priority.
They even started a new front-end Rust application this month, because they don't care to bother with the core of the site, PostgreSQL doing INSERT and SELECT statements to load comments.
For the rest of your post, I don’t know what that has to do with people aggreating on LW.
And, factually, the project leaders telling everyone to create 1000 new instances and shutting down sign-up on Lemmy.ml caused more performance problems.
They had a bug in their PostgreSQL TRIGGER logic where 1500 instances were updating + 1 comment and +1 post counting instead of WHERE site_id = 1, a single database row. So each new Lemmy server that went online made the table larger and crashes more frequent on lemmy.ml
The developers of Lemmy seem to make every effort they can to avoid using Lemmy itself to discuss their !postgresql@lemmy.ml learning 101. They have made massive mistakes in SQL TRIGGER logic that they avoided to such a degree that their social motives are in question now. Github Issue 2910 was opened June 4, almost a month before the Reddit API deadline, and they ignored it. Just like they hang out on Matrix Chat and don't use Lemmy their own self to discuss code.
They have cultivated a kind of voodoo attitude towards PostgreSQL where people using Lemmy won't actually scrutinize the Rust code or PostgreSQL tuning parameters.
For the rest of your post, I don’t know what that has to do with people aggreating on LW.
aggregation refers to the lemmy database tables, site_ aggregates, community, person. The SQL TRIGGER logic lemmy_server uses that has been the source of so many crashes the past 60+ days.
Lemmy's machine-generated ORM SQL and hand-made flawed PostgreSQL TRIGGER logic is so bad, bloated. The developers on GitHub brag about "high performance". It's unbeliable.
In reality, small instances work because it has so many SQL performance problems that it mostly only is stable with little posts and comments in the database. They dd everything they could to avoid using Lemmy itself to discuss !lemmyperformance@lemmy.ml topics and hang out on Matrix Chat to avoid using the constantly-crashing servers they created.
If you go to a server with no users creating comments and posts and only has a tiny amount of data, it does crash a lot less.
A reminder to move to smaller instances for a better experience
A reminder that this constant advice people blindly parrot to install and flock to smaller instance has now created something like 1000 new servers in 50 days that are poorly run and already going offline as quickly as they went online.
Github Issue 2910 is the kind of PostgreSQL problems that the developers ignored for months and people still defend the developer choices to have the code doing real-time counting of every single comment and post for numbers nobody needs to needs done in real-time.
PostgreSQL is voodoo to this project, they do everything they can to avoid going to !postgresql@lemmy.ml community and asking for help, learning 101 about how to fix their SQL TRIGGER logic like Github Issue 2910 spelled out June 4.
Please answer me since you went out of yoru want to engage me as a human being.
Do you support Edward Bernays techniques of media marketing?
Do you support Cambridge Analytica techniques of power?
Do you believe deception as a means to power is a good thing by politicians you support?
As I find many social media users use low-effort replies to bandwagon on powerful people, dehumanizing individuals who don't agree with the popular powerful people they support.
Thank you. I love all humanity, I love you. Love is far better than hate. Hate is bad. Love is good.
"There's another reason why you should love your enemies, and that is because hate distorts the personality of the hater. We usually think of what hate does for the individual hated or the individuals hated or the groups hated. But it is even more tragic, it is even more ruinous and injurious to the individual who hates. You just begin hating somebody, and you will begin to do irrational things. You can't see straight when you hate. You can't walk straight when you hate. You can't stand upright. Your vision is distorted. There is nothing more tragic than to see an individual whose heart is filled with hate. He comes to the point that he becomes a pathological case. For the person who hates, you can stand up and see a person and that person can be beautiful, and you will call them ugly. For the person who hates, the beautiful becomes ugly and the ugly becomes beautiful. For the person who hates, the good becomes bad and the bad becomes good. For the person who hates, the true becomes false and the false becomes true. That's what hate does. You can't see right. The symbol of objectivity is lost. Hate destroys the very structure of the personality of the hater. [...] when you start hating anybody, it destroys the very center of your creative response to life and the universe; so love everybody. Hate at any point is a cancer that gnaws away at the very vital center of your life and your existence. It is like eroding acid that eats away the best and the objective center of your life. So Jesus says love, because hate destroys the hater as well as the hated."
Is it your cult loyalty to the pro-China project leaders speaking? The authoritarianism that you honor? Do you have blind faith in machine code and are unable to see the level of effort they make to avoid the performance critical code in the application?
Did their words "high performance" on GitHub mesmerise you into believing it without actually installing the Rust code and looking at their performance your own self?