He indexed 45M Hacker News comments to chart 18 years of tech hype (hackernewstrends.com)
A solo dev fed the entire ~48GB Hacker News archive into a search index and built a date-histogram over 45 million posts and comments going back to 2007. Overlay any terms and the tech cycle plays out as a literal chart: lk-99's one-week spike, Stuxnet's lonely persistence, crypto handing the baton to chatgpt.
Then ClickHouse's lead developer dropped by to note he already hosts the same HN dataset as a public SQL database. And the sharpest voice warned it isn't Google Trends at all: it counts what people wrote, not what they searched.
Sign in to save