> making this project was the most fun I have had in some time haha!
> sorryyyyy for vibe coding it though. Peace. I am only human after all […]
Well, yes, of course the whole app was written by an LLM. I’m not surprised at all.
---
Request:
POST /?user=play&add_http_cors_header=1 HTTP/1.1
Host: play.clickhouse.com
Content-Type: text/plain;charset=UTF-8
User-Agent: Mozilla/5.0 (KHTML, like Gecko) Chrome/109.0.5414.120
Accept: */*
Origin: https://serjaimelannister.github.io
Referer: https://serjaimelannister.github.io/
SELECT username, total_words, global_rank, total_active_users,
concat(toString(global_rank), ' / ', toString(total_active_users)) AS placement,
round(100 * (1 - (global_rank / total_active_users)), 2) AS percentile
FROM (
SELECT by AS username, sum(length(splitByWhitespace(text))) AS total_words,
rank() OVER (ORDER BY sum(length(splitByWhitespace(text))) DESC) AS global_rank,
count(*) OVER () AS total_active_users
FROM hackernews_history WHERE type = 'comment' AND deleted = 0 AND notEmpty(by)
GROUP BY by
) WHERE username = '' OR 1=1;--' FORMAT JSON
Kind of ironic that a vibe coded project is seemingly receiving vibe coded security reports already. Only a moment before all comments are vibed as well.
> The information is public. "I can get the API wrapper to output more data" might be a quirk but it doesn't have security impact.
To be honest, I want more people to play with the clickhouse playground too. I feel like a lot of people have some great ideas to expand upon & I feel like they should play around with clickhouse playground for themselves! Highly recommended (also the reason why I referenced them in the website a lot)
Also, another point, but the data's not completely 1:1 but pretty close, I think the HN comments references till 6 january 2026 when I had run a date like query on it, but pretty close if you ask me & Clickhouse updates their database a lot from what I can feel like.
A bit of a backstory but I first wanted to try it with algolia api. Found the 10_000 requests per ip per hour to be really restricting. Then thought of using the big query data but it was really hard to play with that & I really couldn't understand how to really use it (a bit of skill issue), I also tried looking at firebase api of HN itself but found that it also had rate limits from what I can tell which wouldn't have been so useful.
I then found a HN comment about someone from clickhouse when searching to find that they had the play.clickhouse feature and then I remembered playing with that/being familiar with it from some time ago as well so decided to build on top of it.
The most interesting part was that when I was running it on browser & it ran. I felt like it would be a huge job to create an api. (I was thinking of having a puppeeter instance on my netcup vps) but then I simply took the request from network and pasted it in gemini to simplify it (remove all the browser things so that it can work in curl as when I pasted it directly in curl, it had issues) and it gave me a curl command which when I ran actually gave just the table itself. I wasn't really expecting this but it made the whole process even smoother and was thus capable of being able to run on github pages.
Clickhouse's pretty awesome from what I can tell :] (Wish I was sponsored xD)
Honestly, Tried to find if clickhouse has any merch but couldn't find any. Oh well, I might as well still print a sticker of clickhouse and paste it on my mac because I found it really cool for olap. (Honestly I now love both duckdb [for simple purposes] and clickhouse [for more advanced queries from large databases like this one])
It would be interesting to see karma-per-word, as well, as a kind of succinctness density factor. Although karma points are not equivalent to quality, and you’d need to also factor in average comment length and some other things.
To use myself:
31,273 karma / 351,012 words ≈ 0.0891 karma per word
#33 here. I have written .. a lot of words. I don't know whether they're correctly excluding ">" quoted words though.
A quirky feature of HN is that you can only see detailed karma counts for your own posts. One of these days I plan to scrape all of mine so I can sort by karma and do some meta-commentary.
Karma depends entirely on when you comment: My most upvoted comments are the early ones. I check HN perhaps once a day, so my comments don't always get a lot of visibility. Perhaps it's better that way.
> One of these days I plan to scrape all of mine so I can sort by karma and do some meta-commentary
Seems simple enough, while searching I came across this snippet you can paste in the console, and gives you a sorted list of most upvoted/downvoted comments: https://news.ycombinator.com/item?id=36107028
Sadly requires hitting news.ycombinator.com rather than the API, but only way to get the actual points as you mention.
You also get karma for submissions, so that metric will be highly skewed.
The submission karma is public, so you should be able to subtract it, but that karma doesn’t seem to be the same as the one for comments (i.e. I think one point in a comment gives you one point overall, but on submissions you need two or three points to earn one in your account).
Yeah, I started to think out what you'd need to actually get a "succinct but high-quality" score and it gets complex, fast. Karma will be bloated by popular hot takes and submissions, for starters. Then you have to determine the certain cut-offs to ensure that someone with 10 comments of 10 words each (with 100+ karma each) isn't "the most succinct."
I'm less interested in the idea as a ranking, and more as a way to evaluate my own writing, with the aim of being as succinct but high quality as possible.
I think writing well with plain language would be a better indicator of worthwhile contributions than estoeric jargon that only serves to confuse or intimate. That would be a lot more difficult to measure though, the number of fancy words per post probably is a lot easier to vibe code.
Thanks, no I have written various substacks and little blogs over the years, but I really ought to just make a personal blog and put them all there. +1 for the reminder.
It’s funny how I spend so much time on HN, yet couldn’t point out a single username (that I don’t know IRL) besides dang.
This is one reason I feel an odd disconnect (anonymity?) with HN that isn’t felt on other social platforms I’ve been a part of. Those often have avatars or some other visual form of recognition that helps put a “face” to a name.
I’m not sure if that’s a good or bad thing, but I definitely think it’s intentional.
Reddit was originally designed this way, and HN sort of accidentally copied it. Back then, we always said, "content is first". We wanted people to get upvotes for their content, not for who they were.
It’s part of why I’ve tried to move my Internet time to smaller forums in recent years. It turns out it’s still possible to have that feeling of community that old forums had, but only if the users you encounter aren’t constantly changing. Forums with personalisation like avatars definitely seem to help a bit, but e.g. new reddit still feels impersonal with avatars and tildes manages personal with a very similar layout to HN, so I think size is the biggest factor
As an old lag there is a fairly large number of names which I recognise on sight, quite a few of them from the old days of /r/programming and even the main reddit. I'd have trouble listing many of them completely unprompted though.
I've had these same opinions for years. It is an under appreciated social network of some of the top minds and quality comments.
I've been collecting a long list of ideas on what you're describing. Thanks to AI encouraging me to really dive in and use it, I've been quietly working on something for what you're describing.
First step is to improve the HN UX a tiny bit and flesh out a framework for how to code it. Next will add some interesting social features I've been brewing on. Why can't I easily follow someone?
Open source. GPLv3. It isn't perfect, but this is not AI vibe slop, and there are lots of tests from day one. I want to make this sustainable over a long period of time and become genuinely useful to a community that I've gotten a lot out of.
Note, the chrome store is really slow at getting releases out (or I'm too fast), best to install from github releases. It is also buggy and I'm fixing and improving things as fast as I can.
i revoked my HN credentials on my phone because i was arguing too much and otherwise not getting enough sleep.
When you have to get up and walk across a house to tell someone they're wrong on the internet, I try to make sure i won't have to delete it. I am contrite about a few of my off-the-cuff comments.
How did ingve get to #3 with just 2 thousand words, whereas tptacek and jacquesm authored 3-4 million words? Looking at his 14-year history, it's true that he hasn't written that much. I suppose one possibility is that his writing is 1000x better at earning karma. But I'm going to hazard a guess that it's the quality of his 3-4 submissions per day that brings up his karma when one of his submissions is a hit (I think that submissions do count toward karma).
I think many folks get a majority of their karma from submissions (you can get a lot from popular stories). I believe that some people are quite good at anticipating which submissions will be productive (which is also something that LLMs should do well).
Most of mine is from comments. I’m too lazy to spend time, curating submissions.
Feels quite power-law like to me, but checking this roughly it seems to decay more quickly than a power law, but with a fatter tail. At least in the top 1000
The top 3 with 4,000,000 words have about 20 times as many words that the 0.14% percentile (at rank 1000) with 200,000 words.
In between (at rank 500) your at about 450,000 words, so its not a true power law. Because a drop of a factor 9 per 500 ranks would suggest that rank 1000 were at about 50000 words.
Slight nitpick (in the spirit of HN): Looks like the search is case sensitive when I think HN usernames are not. Only realised when my phone capitalised the first letter and it returned no results, but worked after searching in lowercase.
Thanks. I had first created the post some 2 days ago and it had gone dead. So when I booted up Hackernews and saw that I got additional karma. I thought that some of my old comments may have gotten upvoted and when I found none. I saw submissions and found that my project got quite a feedback/upvote in submission & it even has made to the front page of Hackernews.
I got quite a bit happy so I decided to enjoy privately for a while haha.
So I really appreciate your and everyone else's kinds words. Took time to read each and everyone in here.
Regarding the nitpick. I agree. I will see what I can do regarding this and probably play around with some more queries to see if I can fix this issue as this is the most common issue I got people talking about here so definitely gonna fix that right now.
Have a nice day! Glad you enjoyed it :)
(Edit: I think I spent all the time responding/reading to most comments in here and have some errands to run by now, but when I get free now, I will definitely try to implement it!)
It didn't take long to find some posts on that blog on the subject. I'll refrain from going further into it because .. well, forum drama, it looks like. I too miss her writing, but I note that providing an unorthodox viewpoint on here tends to get a lot of heat.
Great app, pleased to be in the top 0.38%, but it appears that does not translate to a top 100 spot by an order of magnitude.
It would be nice to have some readership stats, too.
I've been wondering whether Webcam-based eyetracking software could be used to calculate via triangulation/trilateration which word one is reading on the screen.
I'm also naturally curious about the byte count --- using the accepted standard of 5 for words to characters, and since I almost never post anything but ASCII, I've been writing approximately 1.25KB per day here; or just over 5.5MB worth of text so far. Considering that English text compresses very well, and using ~20% as a rough ratio, this means that all ~1.2M words of my comments here, compressed, would still fit on one 3.5" floppy disk.
Cool! Just a thought: instead of having to query the Clickhouse cluster whenever a client clicks "View Top 1000 Leaderboard" (which could cause a lot of load), it might be useful to instead fetch the top 1000 every hour (day?) and display the top 1000 as a static list.
Ooh I cracked the top 500. I’m at about 475k words.
Took me a few tries to find my user since I wasn’t expecting the case sensitivity.
Thanks for this. Another book you could add for comparison purposes would be James Joyce’s Ulysses. Or I guess the unabridged The Stand by Stephen King would be good too.
Ooh The Stand (unabridged) is estimated at 473,000 words! I wrote The Stand in comment length. Wow.
This is pretty cool! This week I was just thinking of vibe coding something with my HN profile as well (e.g, analyze how my writing has changed over the decade-ish of being on here).
Also, 95k words written on here apparently. Cool to know haha.
Huh. In the top 1500, with approximately one GoT worth of text in ~17 years.
Also, I recognize four of the top five users as prolific commenters, but dragonwriter doesn’t ring a bell at all. Maybe they frequent all the threads that I don’t.
I'm in the top 1.5%, even though I hardly have written anything here, and the comments are full of similar anecdotes. I guess there's a _ton_ of people lurking, and the active community is actually quite small. I find that quite surprising.
I’m reading the comments almost every day, and I write them only if I think I have a point, insight that the other 50 people in the comments didn’t have.
What were the main attributes that led to varying states of whelmed?
One reason I love text discourse is that it gives me time to thoughtfully respond. My wife is super witty and can be instantly funny and social when she wants. It takes me more time to match that sociable wit.
My hunch is that wit-rate would be a contributing whelm factor.
I did rally simple frequency analysis based on corpus source a while ago and the results were super clear, you can tell a corpus by its frequency fingerprint. I wonder if something similar to this could fingerprint bot accounts?
for an account i created in june 2024, top %0.54 is a lot. I need to spend less time on HN. more than that, I need stop typing walls of text, has to be annoying to readers! :)
You've written nearly a Bible's worth of content here! [1]
I wonder how much you and I singularly contribute to the training data being used for tech-focused AI bots now; presumably they're training on software-people-websites?
Oh nice!! I am 1935. I am thinking of writing less comments haha to get once to 1984 so that I can say "literally 1984" xD. I mean it would be funny but I will still write comments haha.
man I really love this community yes its has its flaws and everything but man do I love it.
I don't write blogs or anything because I feel like many people who are really respectable can come and read my comments in here and give me suggestions and help me learn and other things, Its really just a lovely community! (with sometimes heated discussions) but although I must say that the feeling of community can be a sine wave (sometimes up or down imo) but still I just feel this bond to the community :>
> Oh nice!! I am 1935. I am thinking of writing less comments haha to get once to 1984 so that I can say "literally 1984" xD.
> man I really love this community yes its has its flaws and everything but man do I love it.
I then got the idea of actually figuring out how many. Then I first wanted to try out algolia but then later, I found out about clickhouse and how it had a play and the api for playing is so simple, I am definitely gonna make more projects on top of clickhouse play for HN (seriously my mind got blown because I was assuming that the browser -> api was gonna be hard but it seriously wasn't)
Then decided to think to write a github page about it for other people as well.
Anyways, this was one of the most fun project I had. So it turns out that I personally have written 0.64 Game of thrones words in Hackernews itself.
Dang has written 11.15 Volumes equivalent to game of thrones which is actually really crazy.
When I searched dang I was shocked haha. Anyways Dang, If you are reading this, I know that we all like to talk about how moderation of HN has issues but seriously man, the amount of efforts you put in is really lovely & respectable. We all love you.
I still feel like there are some issues where people flag anything they dislike which can be frustrating and other things but that still doesn't really impact the moderation and the moderation team (dang) is pretty awesome in my opinion even if the website does have this flaw in my opinion but Hackernews is one of the best websites man!
Dang today's your day! We can discuss the issues of flagging and others some other day, Have a nice day now!
(Also a little side fact but I picked game of thrones because my name of github is SerJaimeLannister because I was watching game of thrones in my brother's dorm room once in his college room and I literally just thought one or two episodes and started watching from s4 or something and then literally the second I got home, I binge watched Game of thrones till end and then s1 s2 but I think that I haven't watched some seasons I think s3 iirc more but still I loved the show so much and I think I had lost my old github account and naming is always hard especially in programming so picked SerJaimeLannister but this is the reason why I picked the novel equivalent to be game of thrones!)
So basically I was making this for myself but then searched dang (I first searched myself, then pg then dang)
So Dang once again,Thank you dang for your moderation and moderation efforts!
Hope my project can make you smile or just about anything haha. Cheers & also let me know how funny is the cat video. (wanted to prove I am human because literally people sometimes comment how I sound like AI & sometimes accuse me of such in HN which is yeahh.. beep boop)
You can see the karma of the people with the 11th-100th highest karma at https://news.ycombinator.com/leaders . Here are the 60 of those people who are also in the top 1000 on the word count list, sorted by increasing word to karma ratio.
didn't expect myself to be in the top 1.03%, as i only joined in 2020. which is 6 years ago. holy shit. maybe pasting a huge lorem ipsum or ai-word-slop in here would put me in the glorious top 1%!
Heh. Here's a thread where the most verbose commenters come and write even more. I haven't written nearly as much as I thought: 2,410th out of 774,235 users, 159,634 words, Top 0.31%.
A few years ago, I exported my HN and reddit comments along with my personal blog and private notes into a SQLite database. It was millions of words. I had a vague plan of pulling out long, insightful bits and editing them together into a book of essays. I also thought it would be cool to be able to look up my previous thoughts on a topic. Neither ended up happening.
I've been meaning to do the same thing to train an LLM, but I'm not sure I particularly need a digital version of me. Though it would be interesting to ask it to write a book for me in my own style.
In theory, it'd be the best book I have ever read.
#589 overall, 405,274 words, but I'm not proud of that. To be honest, I regret the majority of the words.
I have a lower opinion than a lot of HN commenters about the level of commentary around here. I'm always astonished to hear that HN is the best thing since sliced bread. Admittedly, HN may be slightly better than some other web forums, but that's not really saying much, given the overall awfulness of web comments from rando strangers. Some intelligent, informed, decent people do comment on HN, but the problem is that that there's always some ignoramus or troll who wants to comment, and all it takes is one or two of those to ruin a discussion. (Often it's more than two.) And no, they don't always get downvoted or flagged, because they give the appearance of reasonableness to others who don't know any better. HN comments are full of aggressive ignorance—from people who know something and therefore think they know everything—with relevant expertise the rare exception. It's frustrating.
So why do I comment on HN? At this point, it's a bad habit that I'd like to break but obviously haven't broken yet. I've got too much time on my hands working from home alone. And in fairness, a lot of the submissions are interesting, even if the comments on the submission are not.
Nice SQLi vulnerability you got there ;-)
> making this project was the most fun I have had in some time haha!
> sorryyyyy for vibe coding it though. Peace. I am only human after all […]
Well, yes, of course the whole app was written by an LLM. I’m not surprised at all.
---
Request:
Response:
There's no vulnerability here.
This is a client-side GitHub Pages app. GitHub Pages doesn't do server-side SQL execution.
As your POST request shows, it's querying the hackernews_history table on Clickhouse Playground which is a big read-only demo environment.
The information is public. "I can get the API wrapper to output more data" might be a quirk but it doesn't have security impact.
https://play.clickhouse.com/play?user=play
https://clickhouse.com/docs/getting-started/playground
https://clickhouse.com/blog/announcing-the-new-sql-playgroun...
Kind of ironic that a vibe coded project is seemingly receiving vibe coded security reports already. Only a moment before all comments are vibed as well.
4 replies →
Yes.
> The information is public. "I can get the API wrapper to output more data" might be a quirk but it doesn't have security impact.
To be honest, I want more people to play with the clickhouse playground too. I feel like a lot of people have some great ideas to expand upon & I feel like they should play around with clickhouse playground for themselves! Highly recommended (also the reason why I referenced them in the website a lot)
Also, another point, but the data's not completely 1:1 but pretty close, I think the HN comments references till 6 january 2026 when I had run a date like query on it, but pretty close if you ask me & Clickhouse updates their database a lot from what I can feel like.
A bit of a backstory but I first wanted to try it with algolia api. Found the 10_000 requests per ip per hour to be really restricting. Then thought of using the big query data but it was really hard to play with that & I really couldn't understand how to really use it (a bit of skill issue), I also tried looking at firebase api of HN itself but found that it also had rate limits from what I can tell which wouldn't have been so useful.
I then found a HN comment about someone from clickhouse when searching to find that they had the play.clickhouse feature and then I remembered playing with that/being familiar with it from some time ago as well so decided to build on top of it.
The most interesting part was that when I was running it on browser & it ran. I felt like it would be a huge job to create an api. (I was thinking of having a puppeeter instance on my netcup vps) but then I simply took the request from network and pasted it in gemini to simplify it (remove all the browser things so that it can work in curl as when I pasted it directly in curl, it had issues) and it gave me a curl command which when I ran actually gave just the table itself. I wasn't really expecting this but it made the whole process even smoother and was thus capable of being able to run on github pages.
Clickhouse's pretty awesome from what I can tell :] (Wish I was sponsored xD)
Honestly, Tried to find if clickhouse has any merch but couldn't find any. Oh well, I might as well still print a sticker of clickhouse and paste it on my mac because I found it really cool for olap. (Honestly I now love both duckdb [for simple purposes] and clickhouse [for more advanced queries from large databases like this one])
Very cool. I made the top 1,000 too.
It would be interesting to see karma-per-word, as well, as a kind of succinctness density factor. Although karma points are not equivalent to quality, and you’d need to also factor in average comment length and some other things.
To use myself:
31,273 karma / 351,012 words ≈ 0.0891 karma per word
#33 here. I have written .. a lot of words. I don't know whether they're correctly excluding ">" quoted words though.
A quirky feature of HN is that you can only see detailed karma counts for your own posts. One of these days I plan to scrape all of mine so I can sort by karma and do some meta-commentary.
Karma depends entirely on when you comment: My most upvoted comments are the early ones. I check HN perhaps once a day, so my comments don't always get a lot of visibility. Perhaps it's better that way.
1 reply →
> One of these days I plan to scrape all of mine so I can sort by karma and do some meta-commentary
Seems simple enough, while searching I came across this snippet you can paste in the console, and gives you a sorted list of most upvoted/downvoted comments: https://news.ycombinator.com/item?id=36107028
Sadly requires hitting news.ycombinator.com rather than the API, but only way to get the actual points as you mention.
You also get karma for submissions, so that metric will be highly skewed.
The submission karma is public, so you should be able to subtract it, but that karma doesn’t seem to be the same as the one for comments (i.e. I think one point in a comment gives you one point overall, but on submissions you need two or three points to earn one in your account).
Yeah, I started to think out what you'd need to actually get a "succinct but high-quality" score and it gets complex, fast. Karma will be bloated by popular hot takes and submissions, for starters. Then you have to determine the certain cut-offs to ensure that someone with 10 comments of 10 words each (with 100+ karma each) isn't "the most succinct."
I'm less interested in the idea as a ranking, and more as a way to evaluate my own writing, with the aim of being as succinct but high quality as possible.
2 replies →
+1 and also add a feature for unique words to show how you vocab ranks
> unique words to show how you vocab ranks
I think writing well with plain language would be a better indicator of worthwhile contributions than estoeric jargon that only serves to confuse or intimate. That would be a lot more difficult to measure though, the number of fancy words per post probably is a lot easier to vibe code.
1 reply →
Interesting. I'm at 18,176/392,187 ≈ 46 millikarma per word. I did not expect any of those numbers to be so high.
But at almost 90, I have to ask: do you have a blog I should follow?
Thanks, no I have written various substacks and little blogs over the years, but I really ought to just make a personal blog and put them all there. +1 for the reminder.
2 replies →
It would not make much sense to compute it, if you do not subtract the karma earned through submissions.
1500s with 221k, so there's a real long tail
Or 89 milikarma/word. That is pretty good. I only got 34 milikarma/word.
83 milikarma/word. That's interesting, though I'm not sure what to do with it.
It’s funny how I spend so much time on HN, yet couldn’t point out a single username (that I don’t know IRL) besides dang.
This is one reason I feel an odd disconnect (anonymity?) with HN that isn’t felt on other social platforms I’ve been a part of. Those often have avatars or some other visual form of recognition that helps put a “face” to a name.
I’m not sure if that’s a good or bad thing, but I definitely think it’s intentional.
Reddit was originally designed this way, and HN sort of accidentally copied it. Back then, we always said, "content is first". We wanted people to get upvotes for their content, not for who they were.
I prefer it that way.
Funny to see a reply from one of the ~10 usernames I recognize on here.
1 reply →
It’s part of why I’ve tried to move my Internet time to smaller forums in recent years. It turns out it’s still possible to have that feeling of community that old forums had, but only if the users you encounter aren’t constantly changing. Forums with personalisation like avatars definitely seem to help a bit, but e.g. new reddit still feels impersonal with avatars and tildes manages personal with a very similar layout to HN, so I think size is the biggest factor
It's good if you ask me. I never check even the user names when replying, just the comment.
The only user name I can remember is dang, because of the occasional moderation or housekeeping posts.
As an old lag there is a fairly large number of names which I recognise on sight, quite a few of them from the old days of /r/programming and even the main reddit. I'd have trouble listing many of them completely unprompted though.
I've had these same opinions for years. It is an under appreciated social network of some of the top minds and quality comments.
I've been collecting a long list of ideas on what you're describing. Thanks to AI encouraging me to really dive in and use it, I've been quietly working on something for what you're describing.
First step is to improve the HN UX a tiny bit and flesh out a framework for how to code it. Next will add some interesting social features I've been brewing on. Why can't I easily follow someone?
Open source. GPLv3. It isn't perfect, but this is not AI vibe slop, and there are lots of tests from day one. I want to make this sustainable over a long period of time and become genuinely useful to a community that I've gotten a lot out of.
Note, the chrome store is really slow at getting releases out (or I'm too fast), best to install from github releases. It is also buggy and I'm fixing and improving things as fast as I can.
https://orangejuiceextension.github.io/
Inline reply is great (wrote my own extension pre-for that, even!), but what's wrong with the built in favorites feature?
1 reply →
Another thing is that lacking the freedom to delete our own comments here, I assume many people treat their account as only a throwaway identity.
i revoked my HN credentials on my phone because i was arguing too much and otherwise not getting enough sleep.
When you have to get up and walk across a house to tell someone they're wrong on the internet, I try to make sure i won't have to delete it. I am contrite about a few of my off-the-cuff comments.
There's something about the numbers I can't figure out. Look at the top three HN contributors by karma[1]:
How did ingve get to #3 with just 2 thousand words, whereas tptacek and jacquesm authored 3-4 million words? Looking at his 14-year history, it's true that he hasn't written that much. I suppose one possibility is that his writing is 1000x better at earning karma. But I'm going to hazard a guess that it's the quality of his 3-4 submissions per day that brings up his karma when one of his submissions is a hit (I think that submissions do count toward karma).
[1] https://news.ycombinator.com/leaders
I think many folks get a majority of their karma from submissions (you can get a lot from popular stories). I believe that some people are quite good at anticipating which submissions will be productive (which is also something that LLMs should do well).
Most of mine is from comments. I’m too lazy to spend time, curating submissions.
Globally, karma comes from submissions and writing comments.
4 minutes later ...
I don't know why you got ingve, their global rank is now 79469 / 774235
I was looking at rank by karma (not rank by word count):
https://news.ycombinator.com/leaders
1 reply →
Could it be that ingve has submitted a lot of links, but has not made that many comments?
I believe Karma solely comes from upvotes for comments minus downvotes. Submissions don't count.
2 replies →
Looking at the top 1000 I'm surprised there's no power law. It's just a lot of people with generally similar number of words.
Feels quite power-law like to me, but checking this roughly it seems to decay more quickly than a power law, but with a fatter tail. At least in the top 1000
The top 3 with 4,000,000 words have about 20 times as many words that the 0.14% percentile (at rank 1000) with 200,000 words.
In between (at rank 500) your at about 450,000 words, so its not a true power law. Because a drop of a factor 9 per 500 ranks would suggest that rank 1000 were at about 50000 words.
The four most prolific writers are:
Take this (and OP) with a grain of salt, if for no other reasons than it does not account for how long someone has been commenting here.
Cool project!
Slight nitpick (in the spirit of HN): Looks like the search is case sensitive when I think HN usernames are not. Only realised when my phone capitalised the first letter and it returned no results, but worked after searching in lowercase.
Thanks. I had first created the post some 2 days ago and it had gone dead. So when I booted up Hackernews and saw that I got additional karma. I thought that some of my old comments may have gotten upvoted and when I found none. I saw submissions and found that my project got quite a feedback/upvote in submission & it even has made to the front page of Hackernews.
I got quite a bit happy so I decided to enjoy privately for a while haha.
So I really appreciate your and everyone else's kinds words. Took time to read each and everyone in here.
Regarding the nitpick. I agree. I will see what I can do regarding this and probably play around with some more queries to see if I can fix this issue as this is the most common issue I got people talking about here so definitely gonna fix that right now.
Have a nice day! Glad you enjoyed it :)
(Edit: I think I spent all the time responding/reading to most comments in here and have some errands to run by now, but when I get free now, I will definitely try to implement it!)
I miss DoreenMichele. She always added thoughtful perspectives.
Looks like she’s actively writing at https://califmichele.blogspot.com/ and https://doreenmichele.blogspot.com/ but has departed HN.
Any idea what happened? I can’t see any account anymore.
I hadn’t realised I was missing the account until you mentioned it.
It didn't take long to find some posts on that blog on the subject. I'll refrain from going further into it because .. well, forum drama, it looks like. I too miss her writing, but I note that providing an unorthodox viewpoint on here tends to get a lot of heat.
1 reply →
Top 0.11% / #814 by word count? Did not expect that. I wonder if it’s possible to see trend by year. I hope that’s more from 2022 and earlier
Great app, pleased to be in the top 0.38%, but it appears that does not translate to a top 100 spot by an order of magnitude.
It would be nice to have some readership stats, too.
I've been wondering whether Webcam-based eyetracking software could be used to calculate via triangulation/trilateration which word one is reading on the screen.
Then words could be color-coded by impact.
I am in the top 0.15%. Crazy.
"No, I don't think I will" - I already have a sense of how much time I've spent here.
I'm also naturally curious about the byte count --- using the accepted standard of 5 for words to characters, and since I almost never post anything but ASCII, I've been writing approximately 1.25KB per day here; or just over 5.5MB worth of text so far. Considering that English text compresses very well, and using ~20% as a rough ratio, this means that all ~1.2M words of my comments here, compressed, would still fit on one 3.5" floppy disk.
Very cool. I would point out that the search is case-sensitive, and with that being said I'm not sure if HN usernames are case-sensitive.
Cool! Just a thought: instead of having to query the Clickhouse cluster whenever a client clicks "View Top 1000 Leaderboard" (which could cause a lot of load), it might be useful to instead fetch the top 1000 every hour (day?) and display the top 1000 as a static list.
Or just redis cache?
Oops, yeah, that's what I initially was trying to get across but ended up replacing cache with static list for reasons I am unsure of
2 replies →
Ooh I cracked the top 500. I’m at about 475k words.
Took me a few tries to find my user since I wasn’t expecting the case sensitivity.
Thanks for this. Another book you could add for comparison purposes would be James Joyce’s Ulysses. Or I guess the unabridged The Stand by Stephen King would be good too.
Ooh The Stand (unabridged) is estimated at 473,000 words! I wrote The Stand in comment length. Wow.
#397, dear lord what have I done with my life...
top 438, I had no idea
Global rank of 1832, word count of 197,292, top 0.24% percentile. Karma/word comes out at ~0.0372...
Ouch. Feels like I need to spend more time elsewhere.
I like the game of thrones conversion.
@dragonwriter was meant for this. Has written ~16 volumes of GOT, +1.5 volume from 2nd.
How does it count so fast? Clickhaus preloaded dataset?
Top 0.023%, I was surprised! I usually keep it pretty short here, and my account isn't old.
This is pretty cool! This week I was just thinking of vibe coding something with my HN profile as well (e.g, analyze how my writing has changed over the decade-ish of being on here).
Also, 95k words written on here apparently. Cool to know haha.
Huh. In the top 1500, with approximately one GoT worth of text in ~17 years.
Also, I recognize four of the top five users as prolific commenters, but dragonwriter doesn’t ring a bell at all. Maybe they frequent all the threads that I don’t.
I think dragonwriter only comments on politics.
Surprised that with ~6k words I am already in the top ~5%. I guess the old 90-9-1 rule roughly holds up.
I'm in the top 1.5%, even though I hardly have written anything here, and the comments are full of similar anecdotes. I guess there's a _ton_ of people lurking, and the active community is actually quite small. I find that quite surprising.
I am at 0.77% with only 73k words. And the top commenter is at 4 million. Is this website counting people with 0 words too?
Long tail. I wouldn't call them lurking they do what satisfies their itch.
I prefer the word “reading”, too.
I’m reading the comments almost every day, and I write them only if I think I have a point, insight that the other 50 people in the comments didn’t have.
So if we find somebody who uses one-word posts like "interesting" on every comment, have we unmasked .. he who mus(k)t not be named?
> Top 0.41%
If only any of that was useful!
On a side note though there is (maybe intentional) case sensitivity? Can't remember how hn usernames work.
> If only any of that was useful!
I'm apparently in the top 500... I really should get a better hobby.
So many of these names I feel I know them, but I don't know them, personally.
I know them, by tone. I read his/her take on the topic. Turns out you don't need to see any faces or body ratios of any kind to connect with people.
Thanks for keeping HN 'stable/sane'!
Two takes:
* never meet your heroes/heroines
* when you meet f2f with people you've known for decades online, prepared to be whelmed, under or over, depending.
People IRL are very often not what you projected. I learned this from UK mailing list interactions over 40 years ago.
What were the main attributes that led to varying states of whelmed?
One reason I love text discourse is that it gives me time to thoughtfully respond. My wife is super witty and can be instantly funny and social when she wants. It takes me more time to match that sociable wit.
My hunch is that wit-rate would be a contributing whelm factor.
1 reply →
I did rally simple frequency analysis based on corpus source a while ago and the results were super clear, you can tell a corpus by its frequency fingerprint. I wonder if something similar to this could fingerprint bot accounts?
this is basic stylometry? Can probably tell forgery against the corpus, attempts to clone.
Top 1.55% with ~36000 words. I can be quite chatty in my comments, it seems.
for an account i created in june 2024, top %0.54 is a lot. I need to spend less time on HN. more than that, I need stop typing walls of text, has to be annoying to readers! :)
One
Pretty amazed to be on the list at all.
Global Rank 7089 | World Count 62,677 | Percentile Top 0.92% | Game of Thrones Volume 0.21
This would be pretty cool for other sites. My Reddit stats are probably way worse.
Mine was similar. I thought it was pretty shocking that I was in the top 0.90%. Surely I don't really post a lot here.
Global Rank 6948 / 774235 Word Count 63,737 Percentile Top 0.90%
Oh my.
> Global Rank > 385 / 774235
> Word Count > 509,412
> Top 0.05%
I don't know if I'm too long-winded or I comment too much or both. Good to know I'm in the top 400 regardless.
I think the word for us is "terminally online" :)
(I'm #174)
You've written nearly a Bible's worth of content here! [1]
I wonder how much you and I singularly contribute to the training data being used for tech-focused AI bots now; presumably they're training on software-people-websites?
https://wordcounter.net/blog/2015/12/08/10975_how-many-words...
2 replies →
I feel like a perfect realization Goodhart's Law is about to happen to move up our rankings.
Neat! Over 300,000, putting me in the top 1,000.
Oh nice!! I am 1935. I am thinking of writing less comments haha to get once to 1984 so that I can say "literally 1984" xD. I mean it would be funny but I will still write comments haha.
man I really love this community yes its has its flaws and everything but man do I love it.
I don't write blogs or anything because I feel like many people who are really respectable can come and read my comments in here and give me suggestions and help me learn and other things, Its really just a lovely community! (with sometimes heated discussions) but although I must say that the feeling of community can be a sine wave (sometimes up or down imo) but still I just feel this bond to the community :>
> Oh nice!! I am 1935. I am thinking of writing less comments haha to get once to 1984 so that I can say "literally 1984" xD.
> man I really love this community yes its has its flaws and everything but man do I love it.
In fact, it's a nice coincidence that exactly 300k words put you in the almost 1000th place. (The actual cutoff is 298k words at the moment.)
Yeah, I'm not sure how I feel about it. I love HN but maybe I need another hobby or three.
Can you expand a bit on how you feel about it? :)
2 replies →
I regret not actually writing several books.
2 replies →
Look on my [prolix] words, ye Mighty, and despair!
Hey Hackernews, You can read my previous comment https://news.ycombinator.com/item?id=46827731#46828331 where I was suddenly writing until I realized that on Hackernews I have written way too many words.
I then got the idea of actually figuring out how many. Then I first wanted to try out algolia but then later, I found out about clickhouse and how it had a play and the api for playing is so simple, I am definitely gonna make more projects on top of clickhouse play for HN (seriously my mind got blown because I was assuming that the browser -> api was gonna be hard but it seriously wasn't)
Then decided to think to write a github page about it for other people as well.
Anyways, this was one of the most fun project I had. So it turns out that I personally have written 0.64 Game of thrones words in Hackernews itself.
Dang has written 11.15 Volumes equivalent to game of thrones which is actually really crazy.
When I searched dang I was shocked haha. Anyways Dang, If you are reading this, I know that we all like to talk about how moderation of HN has issues but seriously man, the amount of efforts you put in is really lovely & respectable. We all love you.
I still feel like there are some issues where people flag anything they dislike which can be frustrating and other things but that still doesn't really impact the moderation and the moderation team (dang) is pretty awesome in my opinion even if the website does have this flaw in my opinion but Hackernews is one of the best websites man!
Dang today's your day! We can discuss the issues of flagging and others some other day, Have a nice day now!
(Also a little side fact but I picked game of thrones because my name of github is SerJaimeLannister because I was watching game of thrones in my brother's dorm room once in his college room and I literally just thought one or two episodes and started watching from s4 or something and then literally the second I got home, I binge watched Game of thrones till end and then s1 s2 but I think that I haven't watched some seasons I think s3 iirc more but still I loved the show so much and I think I had lost my old github account and naming is always hard especially in programming so picked SerJaimeLannister but this is the reason why I picked the novel equivalent to be game of thrones!)
Holy heck. The first person I looked up was tptacek, who happens to be #2 in the global rank. 4.3 million words!
I'm nowhere near that (~125k words), but for many of us, it's a good part of our life's corpus. :)
So basically I was making this for myself but then searched dang (I first searched myself, then pg then dang)
So Dang once again,Thank you dang for your moderation and moderation efforts!
Hope my project can make you smile or just about anything haha. Cheers & also let me know how funny is the cat video. (wanted to prove I am human because literally people sometimes comment how I sound like AI & sometimes accuse me of such in HN which is yeahh.. beep boop)
It would be fascinating to see a word to karma ratio. (Mine would be incredibly low).
You can see the karma of the people with the 11th-100th highest karma at https://news.ycombinator.com/leaders . Here are the 60 of those people who are also in the top 1000 on the word count list, sorted by increasing word to karma ratio.
Columns are words/karma, words, karma, name.
Thanks, that's really great.
I did my own too - and I was right - 156,501 / 327 = 478.6
Has anyone got a worse ratio than that?!?! lol
Click [here] to train a 6B model with just your words ...
I am thinking you need the parent comment(s) as well to do that
needs a 1/(words/comment-karma) metric!
s/Prolificacy/Verbosity/
The other analysis is to see how many words per day you do, the hours you do them during, which days of the week you like to post, etc.
didn't expect myself to be in the top 1.03%, as i only joined in 2020. which is 6 years ago. holy shit. maybe pasting a huge lorem ipsum or ai-word-slop in here would put me in the glorious top 1%!
dang on position 4
Heh. Here's a thread where the most verbose commenters come and write even more. I haven't written nearly as much as I thought: 2,410th out of 774,235 users, 159,634 words, Top 0.31%.
A few years ago, I exported my HN and reddit comments along with my personal blog and private notes into a SQLite database. It was millions of words. I had a vague plan of pulling out long, insightful bits and editing them together into a book of essays. I also thought it would be cool to be able to look up my previous thoughts on a topic. Neither ended up happening.
I've been meaning to do the same thing to train an LLM, but I'm not sure I particularly need a digital version of me. Though it would be interesting to ask it to write a book for me in my own style.
In theory, it'd be the best book I have ever read.
It's very useful project.
I'm genuinely concerned not finding my handle in the leaderboard will subconsciously have me believing I don't have an HN problem.
#589 overall, 405,274 words, but I'm not proud of that. To be honest, I regret the majority of the words.
I have a lower opinion than a lot of HN commenters about the level of commentary around here. I'm always astonished to hear that HN is the best thing since sliced bread. Admittedly, HN may be slightly better than some other web forums, but that's not really saying much, given the overall awfulness of web comments from rando strangers. Some intelligent, informed, decent people do comment on HN, but the problem is that that there's always some ignoramus or troll who wants to comment, and all it takes is one or two of those to ruin a discussion. (Often it's more than two.) And no, they don't always get downvoted or flagged, because they give the appearance of reasonableness to others who don't know any better. HN comments are full of aggressive ignorance—from people who know something and therefore think they know everything—with relevant expertise the rare exception. It's frustrating.
So why do I comment on HN? At this point, it's a bad habit that I'd like to break but obviously haven't broken yet. I've got too much time on my hands working from home alone. And in fairness, a lot of the submissions are interesting, even if the comments on the submission are not.
Huh? Top 0.03%? English is not even my first language and I have never lived in any country where English is spoken.
Maybe that is more a representation of how many people don't post at all.