Web developer. Lead developer of PieFed

  • 52 Posts
  • 1.09K 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.





  • Rimu@piefed.socialtoLinux@programming.dev•KDE and AI, and you, and me
    link
    fedilink
    English
    arrow-up
    15
    arrow-down
    1
    ·
    18 days ago

    Attempts to have your cake and eat it too are always going to be pretty fraught when it’s a moral / ethical issue. If you try to compromise then no one is happy except the opportunists who see it as a chance to push for further changes in their direction.

    Several weeks ago, a KDE developer started a mailing list thread asking about how we should handle the flood of AI slop merge requests. Everyone agreed it was a problem, and that we don’t want that crap.

    That bit of context was certainly left out of the story when I first heard it and had I known that I would have read the proposed policy more charitably.

    As an aside - this is the problem with having mailing lists and chatrooms - they are not on the web so it’s impossible to link to the original source / context and this provides an opening for people who want to stir up some shit. I use Matrix a lot less these days, for that reason.