4 ms·
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() - p
by mdoliwa 5y ago
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 5y agoThat's almost the HN formula. Make sure your age is calculated as hours.