/kbin meta

639 readers

1 users here now

Magazine dedicated to discussions about the kbin itself. Provide feedback, ask questions, suggest improvements, and engage in conversations related to the platform organization, policies, features, and community dynamics. ---- * Roadmap 2023 * m/kbinDevlog * m/kbinDesign

founded 1 year ago

Is there a way to derank certain magazines on user side? Something between full blocking and full allowing a magazine? (kbin.social)

submitted 1 year ago by [email protected] to c/[email protected]

38 comments fedilink hide all child comments

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?

you are viewing a single comment's thread
view the rest of the comments

[–] [email protected] 1 points 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;