Web developer. Lead developer of PieFed

  • 49 Posts
  • 976 Comments
Joined 3 years ago
cake
Cake day: January 4th, 2024

help-circle



  • The main challenge is that we’d need to run the ‘get posts’ database query twice - once with no filters and once with the filters. These are big queries so they’re slow and hard to optimize. You really really don’t want to run them more than once per page load.

    If you wanted a breakdown of which filter caused how many posts then you’d need to run one query per filter and compare it with the no-filter version to see the difference. So, about 6x. Impractical.

    If all the filtering was done in the app logic (rather than on the DB server, using SQL) then it would be trivial to count up which filter did what, as the code looped through the posts. But I’m very sceptical about the performance potential of this, there’s a reason why we do as much filtering as possible on the DB… It’d be an interesting experiment to try.





  • It’s manually-applied and reversible. I can’t reliably code an automatic reposter detection system because they’re all different. It’s going to have to be a human judgement.

    Similar to labelling things as AI-generated or NSFW - being a reposter isn’t necessarily bad. It just means that people who don’t mind whether they see it can do so and those who don’t want to can avoid it, without the conflict that ensues when people with different needs and tastes are forced to share space.