meet our lord and saviour, Pathologically Eclectic Rubbish Lister
/u/Ernest na jakiej podstawie wyliczasz hot_rank dla obiektu?
Rank = ScaleFactor * log(Max(1, 3 + Score)) / (Time + 2)^Gravity
Score = Upvotes - Downvotes Time = time since submission (in hours) Gravity = Decay gravity, 1.8 is default
– hours_diff:=EXTRACT(EPOCH FROM (timezone(‘utc’,now()) - published))/3600 return floor(10000*log(greatest(1,score+3)) / power(((EXTRACT(EPOCH FROM (timezone(‘utc’,now()) - published))/3600) + 2), 1.8))::integer;
mein gott, pachnie postgresem <3
no side2sidebar
/u/Ernest na jakiej podstawie wyliczasz hot_rank dla obiektu?
Rank = ScaleFactor * log(Max(1, 3 + Score)) / (Time + 2)^Gravity
Score = Upvotes - Downvotes Time = time since submission (in hours) Gravity = Decay gravity, 1.8 is default
– hours_diff:=EXTRACT(EPOCH FROM (timezone(‘utc’,now()) - published))/3600 return floor(10000*log(greatest(1,score+3)) / power(((EXTRACT(EPOCH FROM (timezone(‘utc’,now()) - published))/3600) + 2), 1.8))::integer;
mein gott, pachnie postgresem <3