[manx]

Which voting algorithm are you using? I recently wrote an article about that topic and working on part 2: https://felx.me/2021/08/29/improving-the-hacker-news-ranking...

Happy to help if you want to talk about it.

[mdoliwa]

Not sure where I found it, but I have it coded like this:

scope :ranked, -> { select('posts.*, ((posts.upvotes_count + 1) / POWER(EXTRACT(EPOCH FROM (NOW() - posts.published_at)), 1.8)) AS rank').order('rank DESC') }

[manx]

That's almost the HN formula. Make sure your age is calculated as hours.