How about highest karma per comment? Personally, I consider comments that people post here a lot more useful than original articles. I also tend to mod comments a lot more frequently than stories themselves.
If you look at median comment score, there are three leaders with 3-- garbowza, greendestiny, and pg-- followed by a large number with 2. If you go by average the leaders are:
Though it's kind of lame that I lead, the good news is that it looks like the extra upvotes I get for being the creator of the site probably don't amount to more than 1 per comment.
I don't think it's lame that you lead. More people upvote your comments because more people read your comments, and that's to be expected. It would only be blind fandom if all your comments were upvoted.
Isn't "karma / #stories" a bogus measurement, considering that karma is obtained both from stories and from comments? I (as I write this) have 89 karma, but only 8 points of that is from submissions...
How about computing [karma obtained from submissions] / [# of submissions] and [karma obtained from comments] / [# of comments] separately?
I've also wondered if "karma" as defined here is anything like real world karma (if there is such a thing).
What I mean is: Does upvoting a comment or submission effect your own karma points? Have the folks on the leader board also upvoted a lot? Is there any correlation at all?
Yeah but realistically that'd just return: ERROR: Unknown column 'submissions' or whatever because you'd probably have a separate submission table. Still, you're right that this simple stuff is what SQL is good at.
But having all that data in an in-memory hash is way more flexible and convenient. He can do any arbitrary operations on it, not just the stuff SQL and stored procedures are good at.