The post yes, but not the comments at depth > 50.

No the max comment depth is generally lower now. However this doesnt affect comments created before upgrading.

Changing post.url from varchar(512) to varchar(2000) really messed up database performance so lemmy.ml became unusable. Turns out that column statistics are removed when the type is changed, so we had to run analyze as part of the migration. Seems like a bug in postgres.

https://github.com/LemmyNet/lemmy/issues/4983#issuecomment-2446945046

Dont think I did, it was really a team effort. And in the end the working solution was suggested by @phiresky@lemmy.world, thanks for that!

It will be rejected by the api (or by federation).

With pleasure :)

You’re welcome :)

What a shame, I spent a lot of time working on syncthing-android (probably around four years). But in the end I stopped for the same reason, it’s very demotivating to be so reliant on a corporation like Google which is entirely indifferent or even hostile to open source apps. Every year with the new Android version there are new required features or mandatory changes to implement, and if you don’t comply they don’t allow publishing new app versions. That’s not a big deal for commercial apps with fulltime developers, but it’s a lot of work for small apps maintained by volunteers. And it’s never anything that would benefit syncthing-android or it’s users, just busywork that takes away from bug fixes and feature development.

The good thing about open source is that someone else can always pickup and continue the work. Google’s shenanigans were what drove me to server administration and backend development, which finally led me to work on Lemmy. The experience with syncthing-android definitely taught me a lot about how to run a popular open source project.

In principle it’s finished, but last time we put it on lemmy.ml for testing there were performance problems and we had to revert. So far it’s not clear what caused those problems, so we need to try again somehow.

Good reply, like you explain this wouldn’t work. Just one thing:

Lemmy doesn’t aim to be an uncensorable platform.

https://join-lemmy.org/docs/users/05-censorship-resistance.html

Consider this: half the migrants are collecting welfare, and half of them are taking jobs.

Here: https://github.com/LemmyNet/lemmy/issues

Not sure what more you want to read, but Dessalines and me do AMAs once in a while where we answer all sorts of questions. You can find them in !announcements@lemmy.ml.

And I don’t work on Jerboa, you have to open an issue for this if there isn’t already.

Gern geschehen!

Dont forget 4: Lemmy was created by a German (me)

@threelonmusketeers@sh.itjust.works This. If youre interested to work on this feature or others, feel free to ask for guidance in the relevant issue, or in the dev chat.

With crypto you can make international transfers within a few minutes and only pay a few cents. Using a bank account it takes multiple days, and costs a few euros at least. For me that’s a major use case and something I do regularly.

You can use pg_stat_statements to find slow queries. Try sorting by top total_exec_time.

Its okay, everyone is wrong about some things.

Good example of AI making stuff up instead of simply saying “I don’t know”.