Sander Saarend

Closing this in favor of #3639 as that has a bit more info already

Nice! With the indexes, it's even faster on lemm.ee (~20s instead of ~30s), and more importantly, should scale even better as post/comment counts increase.

> The moderation should only federate if Community A is on the same instance than the moderator ( that got site banned from the instance ) This makes sense to...

I just want to point out that while REST is indeed often portrayed as a "best practice" for designing APIs, it's actually just one way among many of designing things,...

Something which I think would be a great improvement Lemmy API is endpoints with combined arrays for: * Reports * Comments & posts (both for user profiles as well as...

I don't think this is strictly required by the GDPR. The GDPR allows retaining data for some purposes, it seems to me that preventing abuse would be a perfectly valid...

@phiresky what do you think about adding some (maybe configurable) throttling to workers, so for example each worker would pause for X milliseconds between handling each activity? Just to prevent...

I think having it as a tuneable parameter with some conservative default would ensure that smaller servers don't get killed by this, and bigger servers have a chance to tune...

I just checked, I have ~40k rows in `sent_activity` for most 24h periods in the past week. This is roughly 0.5 per second, so actually limiting to 1 per second,...

Is prioritizing straightforward to add? It's probably a good idea for those running everything in a single process, but I still think throttling is necessary in general as well