445
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
this post was submitted on 29 Jul 2023
445 points (93.0% liked)
Fediverse
17735 readers
25 users here now
A community dedicated to fediverse news and discussion.
Fediverse is a portmanteau of "federation" and "universe".
Getting started on Fediverse;
- What is the fediverse?
- Fediverse Platforms
- How to run your own community
founded 5 years ago
MODERATORS
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.
I know you are salty about how you are getting treated over at GitHub, but you should look at it objectively, Blaze is clearly advocating that people join top instances that's not lemmy.world or lemmy.ml, not nobody instances that only have 1-2 users. They certainly aren't going offline as quickly as they come online.
No, it isn't about my personal treatment. It's about the cultist attitude you have towards Lemmy and the leaders without any ability to see what they are doing behind the scenes with the code. I know cults and religious faith is how many people enjoy the world.
A 2-line SQL TRIGGER removal takes about minutes to fix. It was crashing the entire site constantly. They sat by and asked for donations of money.
Then go fix it and open a PR
Do you think I am the one who created the mistake or something? That I have access to the servers to install it?
It's so odd to me that you respond this way, as if it was my coding mistake. It isn't even me who opened issue, that is GitHub "makotech222" - is that your answer to them?
I don’t believe they’re insinuating that you were the one that created the mistake. Rather, that you seem to be knowledgeable of the specific problem and may be the one most capable of fixing it. The two line fix may be obvious to you, but may not to the main Lemmy devs. Until phriskey got involved, a lot of db tuning was being avoided (they’re responsible for most of the big db improvements this version).
and I did not understand or properly relate to that project culture. It had been that way for years and I should have "read the room" "go with the flow".
No, it's everything to do about your personal treatment, stop deceiving yourself. Just because you claim you have autism doesn't immediately grant you the right to be entitled. You don't get your way so you spam create multiple issues to call out the developers, and you expect people to believe it isn't personal for you?
If you aren't happy with the Lemmy developers, fork the project, run your own fork, convince others to use your fork. It's a FOSS world, no one has to do what you say, even if you claim to be autistic.
Telling someone "you claim you have autism" is extremely ableist to all disabled people.
Entitled to what? free money? discount at the car wash? I see you like claiming things that I never said, who talked about deserving things or being entitled?
perhaps you do not grasp that autism impacts my writing and the level of pain I have in communicating, even this very comment. It causes me huge pain and suffering to have my brain touch the keyboard and compose English sentences.
Maybe you lack compassion for my suffering and you are a bully.
No, I never claimed that you said you were entitled. I claimed that you like using your autism as an excuse.
See? Why make yourself suffer?
Why do you deserve my compassion? You are literally hurting yourself by participating in discussions even when you claim, in your own words, "autism impacts my writing and the level of pain I have in communicating, even this very comment. It causes me huge pain and suffering to have my brain touch the keyboard and compose English sentences.". If it hurts so much, get offline.
you used the word entitled, or are you confused? Now you are saying it is an excuse?
It's a fact, it impacts my every word I'm typing on this keyboard, every single English word I speak, read, write, type, hear. It causes bullies and hate-filled people who hate human beings to flock to you to try to "correct" everything about your existence and behavior. Like you are doing.
Do you know the history of Autism in Nazi Europe where it started to get documented? Do you know how humans treat those with mental differences? Is it all your game to imply that love and kindness is shown towards those who speak and behave oddly?
that is all you car about, not having to encounter words you disagree with, to drive off human person you don't like. It's sad to see the popularity of people like you, Donald Trump likes to harm others and gets big crowds too.
If you willingly hurt yourself, or your brain, conversing online, then you shouldn't be using it as an excuse to get your point across. The advice was given, if it hurts, stop doing it, is that really that hard to explain?
to you, yes. As I don't think in flippant attempts to trivialize human beings and reduce things to simpleton answers for something they have struggled with each and every day of their life. It sure is easier to dehumanize me as you keep doing.
writing online is about the only thing in my life that I can do, despite the constant pain, and I'm near death. Once the writing goes, there is zero left, I'm not even really surviving.
Simon Baron-Cohen; July 1, 2003; "The Essential Difference: Male And Female Brains And The Truth About Autism", page 146 quote: "Another man with AS described his life in a very graphic way: 'Every day is like climbing Mount Everest in lead boots, covered in molasses. Every step in every part of my life is a struggle.'"
If it helps clarify things for you, the person you are arguing with doesn't understand what you are trying to say with regards to how autism informs your interactions with others online and is arguing against a point you aren't trying to make. They are however entirely too dug into arguing against that point to easily and effectively get them to understand what you are actually saying and respond to that without the baggage of already deciding that they entirely disagree with you to the point they think they are entitled to be rude to you because you don't agree with them.
The conversation you are in in this thread is more difficult than it ought to be and while some element of that may be due to your autism, there's also a lot of failures from the other side of it making the conversation harder than it should be. At this point you are not being treated kindly and respectfully by the other person (because they are frustrated and handling it poorly.) Better to just disengage with them and shrug it off as a misunderstanding and bad behaviour not of your making as best as you are able to do so.
Reddit convinced people to use Reddit. Elon Musk convinces people to stay on Twitter. Donald Trump convinces people to vote for him.
Just maybe the audience level of knowledge about the topics of media is the problem. You. Maybe you are actually attracted to Lemmy because it crashes, just like people flock to Donald Trump because he does bad things. And people flock to HDTV news instead of reading a book on a subject.
It's odd but not unexpected that you think the problem is code and does not involve the audience being attracted to certain characteristics. I hear McDondl's has a lot of customers.
What is a SQL trigger and why is it taking down servers? Do you know how to fix it?
I think 0.18.3 fixed some of it, but there are likely some more performance issues related to PostgreSQL lurking in Lemmy.
A TRIGGER in SQL is a logic that executes based on other activity.
Lemmy uses them so that when you create a new comment or post, it executes code to insert tracking record for votes and comments on a post. One of the things Lemmy does is called site_aggregates, and there was a bug where it was updating the counts for 1500 servers instead of just the one server. That got fixed in 0.18.3
Deleting accounts in lemmy was causes crashes. I'm not sure if that has been entirely resolved. These things are all kind of hidden in the background of the code, so a lot of developers overlooked that there were problems in them.
Isn’t there a logstream they could tap into to have a separate async tally going on instead of doing it synchronously? Probably a lot of things could be delegated to an async job performed when server load allows?
I've had to really adjust my thinking with this project. They want to do things a very particular way and it goes back 4 years, and a lot of the mistakes are just now getting noticed/attention. For example, comments were not deleting on all the servers, I was testing that after comparing server copies of the same communities and found they were not the same. It just didn't seem to have a lot of people spot-checking it for mistakes. I am learn to just "go with the flow" and face that it's more like how musicians would approach design and running a project. Media-focused systems can be that way.
Going with the flow is both ways. It’s a community project so everyone’s opinion matters, especially those who contribute PRs.