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.

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.

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.

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 really program the app to avoid touching the database and create cached output and incoming 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 SQL 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