Coming up 2 years but I lurked for at least a year. Probably would not have joined at all until one episode Scott said something along the lines of: Anyone else listening to this show is probably more like yourself that anyone else on the planet. It's SUCH a small niche audience.
Can't we just run a calculation over the database to get the Top 10, like SELECT uo.username, COUNT(upr.post)/( MAX(upr.posttimestamp) - MIN(upr.posttimestamp) ) AS epeen FROM userpostrelation AS upr, userobjects AS uo WHERE uo.id == upr.userid ORDER BY epeen DESC GROUP BY uo.username LIMIT 10;
I like my SQL queries to be unreadable.
The timestamp subtraction will probably need to be converted into some scalar unit of time (like seconds since epoch), but this varies by RDBMS implementation unfortunately. In PostgreSQL, you'd wrap the subtraction up as EXTRACT(EPOCH FROM [subtraction clause]).
EDIT: epeen is defined by the number of posts you've made total divided by the time from your first post to your last post, which provides some ratio of post count against the time over which you've been contributing. People who posted for a bit, stopped posting for 2 years, and posted again would be artificially penalized. I could probably come up with a fix if this was legitimate.
DBL EDIT: oh and spambots who posted like 50 posts in a few seconds would be artificially rewarded. I could probably come up with a fix for this also.
My random question, do you remember your best summer, back when you were a kid? I do, it was the summer when I learn to ride the bus in the city back in Peru. It was a summer full of glory, adventure, and many many many long walks :P
My whole childhood is just kind of meshed into one big memory, like everything happened at once. I've noticed that whenever I'm telling a story about something that happened to me as a kid, I always say it happened when I was 7.
Comments
Probably true.
Anyway, in October I'll have been here five years.
Winning!
SELECT uo.username, COUNT(upr.post)/( MAX(upr.posttimestamp) - MIN(upr.posttimestamp) ) AS epeen
FROM userpostrelation AS upr, userobjects AS uo
WHERE uo.id == upr.userid
ORDER BY epeen DESC
GROUP BY uo.username
LIMIT 10;
I like my SQL queries to be unreadable.
The timestamp subtraction will probably need to be converted into some scalar unit of time (like seconds since epoch), but this varies by RDBMS implementation unfortunately. In PostgreSQL, you'd wrap the subtraction up as EXTRACT(EPOCH FROM [subtraction clause]).
EDIT: epeen is defined by the number of posts you've made total divided by the time from your first post to your last post, which provides some ratio of post count against the time over which you've been contributing. People who posted for a bit, stopped posting for 2 years, and posted again would be artificially penalized. I could probably come up with a fix if this was legitimate.
DBL EDIT: oh and spambots who posted like 50 posts in a few seconds would be artificially rewarded. I could probably come up with a fix for this also.
How's that for a good post?
My random question, do you remember your best summer, back when you were a kid?
I do, it was the summer when I learn to ride the bus in the city back in Peru. It was a summer full of glory, adventure, and many many many long walks :P
http://www.newegg.com/Product/Product.aspx?Item=N82E16836113026