I think people who single out hate and dehumanization and violence in one spot have tunnel vision. Hate and violence is all bad. Hate is incredibly popular in drawing a crowd, but overall it is better to criticize all hate like Martin Luther King Jr. did. MLKJr would emphasize not just hate from white to blacks in USA, but all hate in the human brain in general. Too many people want to use hate as an organization tool, weaponize gangs of hate over something or another, and I’m sick of all the crossfire. With social media, it’s everywhere.

My contribution to Humanity and #MemeLife platforms - I come from BBS days in high school.

Kids these days. In 1776 when I was 7 years old, we MEME war on CB Radio, Breaker 19!

“Je ne vois pas dans la religion le mystère de l’Incarnation mais le mystère de l’Ordre Social. La religion rattache au ciel une idée d’égalité qui empêche le riche d’être massacré par le pauvre.” (Napoléon Bonaparte / 1769-1821 / au Conseil d’Etat, le 4 mars 1806)

Latest information is often of the highest quality on Wikipedia: https://en.wikipedia.org/wiki/Qaraqosh_wedding_fire

114 deaths reported so far.

kbin is the closest application to Lemmy, and it does have tags. When you create a post you can pick tags and you can browse by tag: https://kbin.social/tag/kbin

I’m assuming this is done for integration with other ActivePub apps

I’d say the debate about using a strongly typed relational database and ORM is probably more of an impact on end-user turn around than typed language.

it sounds like he was listing to sell the actual game, not just 45 minutes of footage of the game…

The constant crashes of Lemmy from performance issues have really been hard on me, because I just don’t like seeing it happen to people. It’s honestly been the worst web site in terms of stability I’ve used in over a decade.

Lots of good comments here on this discussion.

I almost never see someone link to a Discord past conversation on fixing an issue/problem solving. It’s a one-way black hole.

I don’t think it’s the identical issue either, but a developer working on the code would probably try to fix them together.

Although it was opened against 0.17.4, I encourage you to mention what you are seeing on this Github issue: https://github.com/LemmyNet/lemmy/issues/3222

There is a new SvelteKit JavaScript project for a lemmy-ui alternative: https://lemmy.world/comment/258368

One more thing I forgot to mention. The nginx 500 errors people are getting on multiple Lemmy sites could improve shortly with the release of 0.18 that stops using websockets. Right now Lemmy webapp is passing those through nginx for every web browser client.

something like Apache Kafka

Not that I see. A database like PostgreSQL can work, but you have to be really careful how new data flows into the database. As writing to the database involves record locking and invalidates the cache for output.

Or changing to something that can be scaled, like cockroach db or neondb?

Taking the bulk data, comments and postings, outside PostgreSQL would help. Especially since what most people are reading on a Reddit-like website is content form the last 48 hours… and your caching potential dies way down as people move on to the newer content.

The comments alone are the primary problem, there are lot of them on each posting and they are bulky data. Also comments are unique data.

I doubt it is anything that level. The problem is the data itself, in the database.

A reddit-like website is like email, every load from the database has unique content. You really have to be very careful when designing for scalability when almost all the data is unique. Especially in modern times where users block other users, and even 2 people loading the same posting do not get the same comments. It’s anti-cache, and you have to really work hard to design that to run efficiently on small servers.

As opposed to a website like Amazon where the listing for a toothbrush is not unique on every page load. There aren’t new comments and new votes altering the toothbrush listing every time a user refreshes the page. And people aren’t switching brands of toothbrush every 24 hours like the front page of Reddit abandons old data and starts with fresh data.

Lemmy is kind of the reason some apps go NoSQL design.

The problems I see with Lemmy performance all point to SQL being poorly optimized. In particular, federation is doing database inserts of new content from other servers - and many servers can be incoming at the same time with their new postings, comments, votes. Priority is not given to interactive webapp/API users.

Using a SQL database for a backend of a website with unique data all over the place is very tricky. You have to be really program the app to avoid touching the database and create queues and such when you can. Reddit (at lest 9 years ago when they open sourced it) is also based on PostgreSQL - and you will see they do not do live inserts into comments like Lemmy does - they queue them using something other than the main database then insert them in batch.

email MTA apps I’ve seen do the same thing, they queue files to disk before putting into the main database.

I don’t think nginx is the problem, the bottleneck is the backend of the backend, PostgreSQL doing all that I/O and record locking.

Front-end developers

There was a posting I saved about some people saying they were going to code on front-end: https://lemmy.ml/post/1199330