Show HN: I made Google Trends for Hacker News by indexing 18 years of comments

Post by omoikane » Thu, Jun 25, 2026, 4:56 PM UTC

ytkimirti wrote: post #2

Hello HN, This was a small project of mine after I've found out that I can simply the whole hackernews archive (~48GB) and play around with it. You can compare terms just like in google trends and you can also see the exact posts & comments from that time. I like that you can discover what went crazy in the timeline, they just come up as small burst of activity, it's quite fun to play around with it. https://hackerne…

Post by linmer » Thu, Jun 25, 2026, 4:58 PM UTC

some_furry wrote: post #12

https://hackernewstrends.com/?q=furries&q=furry Hmm, did I break something?

Post by tgv » Thu, Jun 25, 2026, 5:01 PM UTC

zX41ZdbW wrote: post #72

I 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.

Post by linmer » Thu, Jun 25, 2026, 5:02 PM UTC

zX41ZdbW wrote: post #72

I 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.

Post by aberrahmane_b » Thu, Jun 25, 2026, 5:04 PM UTC