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.
Reddit was originally designed to share links. Then to steal images and memes from other sites. Then to steal short videos from mainly TikToc and Instagram creators (now we're here). It's still a content-first site at its finest. It's just that 'content' itself has changed.
There are a handful of people I recognize, most because they’re people I knew from outside HN (and one because he has the same last name as someone I went to high school with and lives local to me and I always wonder if they’re related but I’ve never asked). But yes, the de-emphasis on user names is, I think, a good thing since it ends up being interacting with content rather than personality.
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.
> It’s funny how I spend so much time on HN, yet couldn’t point out a single username besides dang.
That’s very true. These days, when I come across especially thoughtful comments, I’ll sometimes click through to the user’s profile afterward. I think it’s better to judge a comment on its own merits than to let implicit bias creep in based on things like “CEO,” fame, a high-karma account, and so on.
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.
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
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.
> 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])
Legend has it only a dragon writer could defeat tptacek on Hacker News.
Also I find it kind of weird that the search box is case-sensitive. HN itself preserves capitalization when rendering usernames to the page, but must not be case sensitive in the backend since the username shows up in URLs.
Yea If I remember correctly, its the backend which is case-sensitive.
Don't worry though. I am still thinking of fixing the case-sensitive issue.
I had gone to run some errands. Right now, how I am thinking of fixing it is via thinking of using algolia api or maybe by having a singular request to news.ycombinator.com itself while still being client side but I have to see if that's possible/what's easier.
Edit: Almost done. I just wanted to see what LLM's might think of it. So wanted to see them (go wild?) [ie. without my bias of algolia api because I was (thinking?) of other ways too also a better thing was that I was procastinating with the implementation a bit] so pasted it.
It* decided that a better response was to lowercase the username fields and then lowercase the input.
I think I had overarchitected a solution and in hindsight, I thought that the idea of lowercasing usernames would've been slow but clickhouse is a beast too.
I think I was almost thinking the same thing too. Going to update the website with case sensitivity pretty quick.
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
Karma per word would be a terrible metric though: the short, slightly divisive clever quip tends to still net a few points positive as long as it's not all too negative, despite clearly not being great hn content. Great content isn't short, but the vote button is or of sight once you're done reading. Good long texts will certainly still get some upvotes, but rarely enough to outcompete small & clever that just goes with the flow.
The irony is that karma posts are so easy. Take something most of your audience already agrees with, triple down on some reductionist caricature of it, and smother it in pithy glibness. The shorter the better. Particularly effective if you set up a false dichotomy vis-a-vis the person you're replying to. It's a reflexive style of engagement for many, and HN is not immune to it.
I aim to avoid it these days, with varying degrees of success. I don't need fictitious internet points, I want to hear other people's genuine thoughts on a subject of interest. Or sometimes just to share something I thought was neat.
But since all social media are Pavlovian conditioning for points, you rarely get any fruitful exchange. And it seems to be getting rarer and rarer, sadly.
I wonder how one would structure social media to avoid it. HN is good, but the karma system is a double edged sword. Would it increase the quality of the discussion to retain the use of points for ranking posts, but hide point counts completely? Perhaps they could be represented by words: "Positive response", "negative response", but only past -3 and +3, with no changes in wording beyond that score?
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.
#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.
I tried to do exactly this, but you need to hit the actual HTML news.ycombinator.com site, since karma is not visible through the API or in any of the public data dumps. And HN appears to have rather robust anti-scraping provisions. Even after trying a few different back-off strategies, my scraper was rate limited quickly, so I gave up.
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.
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.
A prominent example of a laconism involving Philip II of Macedon was reported by the historian Plutarch. After invading southern Greece and receiving the submission of other key city-states, Philip turned his attention to Sparta and asked menacingly whether he should come as friend or foe. The reply was "Neither."
Losing patience, he sent the message:
If I invade Laconia, I shall turn you out.[4]
The Spartan ephors again replied with a single word:
I’m at 19186/233259, about 0.082, and I’m pretty sure most of my higher upvoted comments are on the shorter side, and my wall of texts tend to not deviate much from 1 karma, sometimes even negative. Don’t put too much stock into fake internet points.
And I really need to waste less time here, didn’t expect to be top 1500…
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.
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.
Indeed, one of the names I typed into the box for old time's sake, too. She was fairly active on HN when I first joined years ago, and her comments always made for interesting reading that set this site apart.
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.
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.
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.
This is so cool. I genuinely hope you try it. I remembered the "website which runs on floppy" hn post from it. Maybe you can even have a website too which shows all your Hackernews comments while being on floppy.
I genuinely hope you do it!! Please let me know (mail me) if you ever do it!
Readit News
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.
I prefer it that way.
The only user name I can remember is dang, because of the occasional moderation or housekeeping posts.
That’s very true. These days, when I come across especially thoughtful comments, I’ll sometimes click through to the user’s profile afterward. I think it’s better to judge a comment on its own merits than to let implicit bias creep in based on things like “CEO,” fame, a high-karma account, and so on.
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/
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.
> 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: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...
> 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])
Also I find it kind of weird that the search box is case-sensitive. HN itself preserves capitalization when rendering usernames to the page, but must not be case sensitive in the backend since the username shows up in URLs.
Don't worry though. I am still thinking of fixing the case-sensitive issue.
I had gone to run some errands. Right now, how I am thinking of fixing it is via thinking of using algolia api or maybe by having a singular request to news.ycombinator.com itself while still being client side but I have to see if that's possible/what's easier.
It* decided that a better response was to lowercase the username fields and then lowercase the input.
I think I had overarchitected a solution and in hindsight, I thought that the idea of lowercasing usernames would've been slow but clickhouse is a beast too.
I think I was almost thinking the same thing too. Going to update the website with case sensitivity pretty quick.
Deleted Comment
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
I aim to avoid it these days, with varying degrees of success. I don't need fictitious internet points, I want to hear other people's genuine thoughts on a subject of interest. Or sometimes just to share something I thought was neat.
But since all social media are Pavlovian conditioning for points, you rarely get any fruitful exchange. And it seems to be getting rarer and rarer, sadly.
I wonder how one would structure social media to avoid it. HN is good, but the karma system is a double edged sword. Would it increase the quality of the discussion to retain the use of points for ranking posts, but hide point counts completely? Perhaps they could be represented by words: "Positive response", "negative response", but only past -3 and +3, with no changes in wording beyond that score?
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).
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.
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.
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.
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.
But at almost 90, I have to ask: do you have a blog I should follow?
A prominent example of a laconism involving Philip II of Macedon was reported by the historian Plutarch. After invading southern Greece and receiving the submission of other key city-states, Philip turned his attention to Sparta and asked menacingly whether he should come as friend or foe. The reply was "Neither."
Losing patience, he sent the message:
If I invade Laconia, I shall turn you out.[4] The Spartan ephors again replied with a single word:
If.
[1] https://en.wikipedia.org/wiki/Laconic_phrase?utm_source=chat...
And I really need to waste less time here, didn’t expect to be top 1500…
somehow almost close to the top 10k despite writing one-hundredth as much as the top guys.
[1] https://news.ycombinator.com/leaders
Most of mine is from comments. I’m too lazy to spend time, curating submissions.
4 minutes later ...
I don't know why you got ingve, their global rank is now 79469 / 774235https://news.ycombinator.com/leaders
Deleted Comment
Looks like she’s actively writing at https://califmichele.blogspot.com/ and https://doreenmichele.blogspot.com/ but has departed HN.
I hadn’t realised I was missing the account until you mentioned it.
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.
I genuinely hope you do it!! Please let me know (mail me) if you ever do it!