Great job! I've also been wanting to do similar statistics recently, wanting to know when LLMs becoming the absolute dominant topic on HN. Now it seems like half of the posts were about LLMs.
Show HN: I made Google Trends for Hacker News by indexing 18 years of comments
71–80 of 169 posts
Re: Show HN: I made Google Trends for Hacker News by indexing 18 years of comments
#72I host a publicly open database with Hacker News data at https://play.clickhouse.com/play?user=play#U0VMRUNUICogRlJPT...
So you can create any sort of similar services in a single SQL query and an HTML page.
I also hosted it as a publicly accessible data lake, which you can query from everywhere: https://github.com/ClickHouse/ClickHouse/issues/29693#issuec...
It is also updated in real-time.
Re: Show HN: I made Google Trends for Hacker News by indexing 18 years of comments
#73It looks like some of these terms aren't indexed (or the site is just too hug of deathed right now), but I'd like to see the graph of like, social media, iot, cryptocurrency, ai.
The transition between crypto and ai on the graphs is already pretty funny. https://hackernewstrends.com/?q=crypto&q=chatgpt
Re: Show HN: I made Google Trends for Hacker News by indexing 18 years of comments
#74The 'flash vs html5' chart looks strange juxtaposed with that conclusion
There are a few technologies with pretty generic names which don’t lend themselves so well to this kind of trend analysis. I was curious about Atom. According to the trend it’s still neck and neck with VS Code. But are people really talking about Atom the text editor that much still, or other types of atoms?
I think Google Trends is actually smart enough to suggest which topic you want to see for the same keywords -- it understands the semantics.
Re: Show HN: I made Google Trends for Hacker News by indexing 18 years of comments
#75Google Trends is about searches This is about published text . More like if Google Trends counted word occurrences on webpages. Or if Google Ngrams counted webpages instead of books People don't write much about non-newsworthy things whereas many people search "burger" anytime they want a burger delivery. The datasets aren't usable in the same way Edit: not to say it's not a cool product! Just keep this in mind and e…
[deleted]
Re: Show HN: I made Google Trends for Hacker News by indexing 18 years of comments
#76Scrolling is totally broken for me.
Re: Show HN: I made Google Trends for Hacker News by indexing 18 years of comments
#77Almost all of the major vulnerability and hack are just single spikes at the time it happened and it tails off after that… except Stuxnet. Stuxnet is was much more interesting that most other attacks since it was very political and openly published. Of course, the thing that attack was about is still a news headline today as well
Re: Show HN: I made Google Trends for Hacker News by indexing 18 years of comments
#78It would be super interesting to see if HN mentions serve as a leading indicator of company performance/valuations -- I wouldn't be surprised.
Re: Show HN: I made Google Trends for Hacker News by indexing 18 years of comments
#79oeeh hug of death, congrats!
Re: Show HN: I made Google Trends for Hacker News by indexing 18 years of comments
#80Google Trends is about searches This is about published text . More like if Google Trends counted word occurrences on webpages. Or if Google Ngrams counted webpages instead of books People don't write much about non-newsworthy things whereas many people search "burger" anytime they want a burger delivery. The datasets aren't usable in the same way Edit: not to say it's not a cool product! Just keep this in mind and e…
Now if Algolia had a dataset of what people are searching for on HN that'd be it