Some instances and groups are very chatty (*gestures to /lemmyshitposts), so much so that they dominate the All page.

I knew that there would be a point that browsing /all would no longer be a pleasant or feasible experience, but I quite liked having a pulse on what everyone in the #threadiverse (that kbin.social federates to, anyway) are thinking. But right now it seems @memes is dominating everything.

I don’t want to fully block them from showing up in my feed, but i don’t want to let them full send either. Would it be feasible to add a feature in future releases to be able to adjust the algorhythm on the user-side that would allow for mutes, or deranking it in your feed, instead of outright blocking it?

  • curiosityLynx@kglitch.social
    1·
    1 year ago

    My naive guess to how Reddit does it would be that they do two SQL commands that look something like this

    WITH CTE AS (
    SELECT  *
           ,row_number() OVER(PARTITION BY magazine ORDER BY heat) AS row_num
    FROM    posts
)
SELECT   *
FROM    cte
WHERE   row_num = 1
ORDER BY heat;

    followed by

    SELECT *
FROM posts
WHERE id<> $IDs_of_previous_request
ORDER BY heat;