this post was submitted on 29 Jul 2023
153 points (94.2% liked)

Fediverse

17788 readers
4 users here now

A community dedicated to fediverse news and discussion.

Fediverse is a portmanteau of "federation" and "universe".

Getting started on Fediverse;

founded 5 years ago
MODERATORS
 
you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 14 points 1 year ago (1 children)

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.

[–] [email protected] -5 points 1 year ago (3 children)

I know you are salty about how you are getting treated over at GitHub

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.

[–] [email protected] 19 points 1 year ago (1 children)

A 2-line SQL TRIGGER removal takes about minutes to fix.

Then go fix it and open a PR

[–] [email protected] 7 points 1 year ago (3 children)

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.

[–] [email protected] 5 points 1 year ago

Telling someone "you claim you have autism" is extremely ableist to all disabled people.

[–] [email protected] 0 points 1 year ago (1 children)

What is a SQL trigger and why is it taking down servers? Do you know how to fix it?

[–] [email protected] 1 points 1 year ago (1 children)

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.

[–] [email protected] 1 points 1 year ago (1 children)

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?

[–] [email protected] 3 points 1 year ago* (last edited 1 year ago) (1 children)

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.

[–] [email protected] 8 points 1 year ago

Going with the flow is both ways. It’s a community project so everyone’s opinion matters, especially those who contribute PRs.