This would be neat to generate forum avatars, to show something similar to your real face.

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.

Thank you, fixed!

Pictrs is only made for images (and videos), as the name implies. Supporting other types of files in pictrs wouldnt make much sense. This means that other file types would have to be stored by a different backend tool, or directly in Lemmy. As we are only two fulltime developers on Lemmy, we dont have the time or resources to work on this, and need to focus on the most popular features.

There is no way for admins or mods to modify user comments or impersonate users, except directly through the db which is unavoidable.

We had a very long discussion recently how vote privacy should be handled, and the current behaviour seems to be the best compromise.

Multi-communities is one of those popular features we are going to implement soon.

And yet the article manages to get people upset, makes the talk about it and get shared. Basically free marketing for SH2. It’s a win-win for eurogamer and for the game publisher. All it takes is a single troll on Wikipedia and some PR work.

No domestic flight, just Europe -> Texas -> Mexico.

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.

Or you guys like to be shouted at. There is no other country that does this.

Not like that, they didn’t let me board my flight from Europe to Texas. Even though I had a connecting flight to Mexico few hours later. Why can’t they have a visa free transit zone like every other country in the world?

I only stopped there for transit on a flight to Mexico. Just before boarding my flight I was told that I need a visa for the US, which is extremely weird because normally airports have transit zones where you don’t need any visa. But apparently the US is special, so you actually have to enter the country before going right back into the airport. This nonsense made me miss my flight.

Also I remember in the airport there was a security guard doing nothing but shouting nonstop that it’s not allowed to carry water. Why not simply put up a sign?

To decide if I should merge the linked PR or not (I did merge it).

Thats even more verbose so the second option is better.

@DemocratPostingSucks@lemm.ee @Deebster@programming.dev @al4s@feddit.org Thanks for the feedback! Personally I prefer the first option, but based on your comments I will merge the PR with the second option.