Original blog post | Hacker News discussion
Spoiler alert: many of the good projects didn't survive
The HN Database
I maintain an up to date database of all public HN items (links, comments, users, etc.).
Data Source
- Public dataset. The Google Cloud BigQuery public datasets include one for Hacker News data. However, this dataset has not been updated since November 2020.
- Official api. I use this to update my database constantly.
Numbers
For this analyze, I considered submissions made before May 31, 2023, 23:59 UTC. The dataset consists of 4,714,023 stories and 30,363,533 comments from 867,097 users.
Show HN Stories
Overview
There are 120,396 valid Show HN stories. The first one was submitted on March 10, 2009, and the last one was submitted on May 31, 2023, at 23:38 UTC.