Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Ask HN: Total karmic wealth of all HN?

news.ycombinator.com

Post reply on HN
Print view View original

1–10 of 19 posts

Re: Ask HN: Total karmic wealth of all HN?

#2

Post by joshmn »

Not an admin, so I can't speak to what they have available. But as a hacker...

Since the usernames are not queryable via an integer (e.g. user?id=1235654321) it's not exactly the most trivial of things. You'd have to go through an endless amount of posts, get every possible username from the comments, go through all stories submitted, grab their usernames, and then loop through the HN API and grab karma info.

Re: Ask HN: Total karmic wealth of all HN?

#4

Post by S4M »

joshmn wrote: post #2

Not an admin, so I can't speak to what they have available. But as a hacker... Since the usernames are not queryable via an integer (e.g. user?id=1235654321) it's not exactly the most trivial of things. You'd have to go through an endless amount of posts, get every possible username from the comments, go through all stories submitted, grab their usernames, and then loop through the HN API and grab karma info.

    select sum(karma) from user_data;
If the HN server uses an SQL database and has a table users containing the user names and their karma - and they must have something like that since the karmas are displayed on the profiles.

Re: Ask HN: Total karmic wealth of all HN?

#9

Post by networked »

dang wrote: post #3

32553783 and counting.

This means that the top 100 contributors (https://news.ycombinator.com/leaders) plus PG (https://news.ycombinator.com/user?id=pg) account for only about 10% of the total karma (3222034 points as of the moment). I expected their part to be greater. I should say "sorry" to the average HN user for underestimating his impact. :-)
Post reply on HN