Skip to content

Instantly share code, notes, and snippets.

@BoZhuM

BoZhuM/Hacker_News_Ranking_Algorithm.sql

Forked from ChiChou/Hacker_News_Ranking_Algorithm.sql
Created April 30, 2014 05:32
Show Gist options
  • Save BoZhuM/1a8f690af953a862f925 to your computer and use it in GitHub Desktop.
Save BoZhuM/1a8f690af953a862f925 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Hacker_News_Ranking_Algorithm.sql
-- (p - 1) / (t + 2)^1.5
CREATE FUNCTION SP_POINTS(P SMALLINT(5), CREATED TIMESTAMP)
RETURNS TINYINT(3)
RETURN (P - 1) / POW(TIMESTAMPDIFF(HOUR, CREATED, NOW()) + 2, 1.5);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment