the reddit hot alg in ActiveRecord Postgres for rails

reddit.rb

class Story < ActiveRecord::Base
  
  # make likes count whatever basic score you want.  it would be the sum of up plus down votes, or use whatever cache counters you have and weight them accordingly.

#the magic time should just be a unix time right before people started making stuff, for us, its just 6 months before we started makr.io

  def self.ranked
    order("(ln( 1 + posts.likes_count) +  (EXTRACT(EPOCH FROM created_at) - 1327654606)/9000) desc")
  end
 
end