Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

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

hackernewstrends.com

Post reply on HN
Print view View original

161–169 of 169 posts

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

#161

Post by fragmede »

linmer wrote: post #94
fragmede wrote: post #35

Earlier quoted context omitted.

If more people spent time on /new looking for awesome stuff and vouching for dead items, HN would be a better place.

Has anyone tried to make some sort of algorithm to find cool stuff on HN or sort by upvotes etc? I know it's cool and intended that such things don't exist, but has anyone tried?

There's that one side that tracks were a post ranks overtime and you can see things drop off quickly when they get flagged for being flame bait and there's a lot of cool stuff on/new that other people kill cool stuff makes it to the front page but a lot of cool stuff doesn't. There's a second chance pool, but maybe there should be a third and fourth one as well.

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

#162

Post by jstrieb »

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.

This is awesome!

I do want to point out that the data in that ClickHouse playground only seems to go as far back as April 6, 2024 according to the query below:

  SELECT * FROM hackernews_history ORDER BY update_time ASC LIMIT 10
This is of course still extremely useful, and generous! It just wasn't obvious from the comment that this isn't querying against all Hacker News data.

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

#164

Post by wodenokoto »

Was surprised to see Anthropic mentioned all the way back in 2008, only that it is not the company (obviously)

So for the sake of online human conversation I’m gonna ask here and not Claude:

What did Anthropic mean before the AI company completely captured this word?

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

#167

Post by rvba »

jrflowers wrote: post #146
GeoAtreides wrote: post #101

Earlier quoted context omitted.

oh hey, per HN terms and conditions I license my HN data only to HN. Can you please remove my data from the set? Thank you!

Steve Carrell yelling “I DECLARE BANKRUPTCY!!” in The Office dot gif

Is this GDPR territory with fines up to EUR 10 million or 2% of a company’s global annual turnover? Not sure what are the fines for some random person though
Post reply on HN