3 ms·
Curious, do you have a better solution?
by krior 2y ago
Curious, do you have a better solution?
- throw__away7391 2y agoThe solution to most social media problems in general is: `select * from posts where author_id in @follow_ids order by date desc` At least 90% of the ills of social media are caused by using algorithms to prioritize content and determine what you're shown. Before these were introduced, you just wouldn't see these types of things unless you chose to follow someone who chose to post it, and you didn't have people deliberately creating so much garbage trying to game "engagement".
- mulmen 2y agoI'd love a chronological feed but if you gave me a choice I'd get rid of lists in SQL first. > select * from posts where author_id in @follow_ids order by date desc SELECT post FROM posts JOIN follows ON posts.author_id = follows.author_id WHERE follows.user_id = $session.user_id;