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

101–110 of 169 posts

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

#101

Post by GeoAtreides »

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.

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!

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

#102

Post by pelagicAustral »

GeoAtreides wrote: post #101
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.

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!

You must be fun at parties

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

#103

Post by moralestapia »

GeoAtreides wrote: post #101
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.

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!

By uploading any User Content you hereby grant and will grant Y Combinator and its affiliated companies a nonexclusive, worldwide, royalty free, fully paid up, transferable, sublicensable, perpetual, irrevocable license to copy, display, upload, perform, distribute, store, modify and otherwise use your User Content for any Y Combinator-related purpose in any form, medium or technology now known or later developed.

@zX41ZdbW, you can safely ignore this guy.

@GeoAtreides, next time read the actual terms of service before hallucinating.

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

#105

Post by smalltorch »

all2 wrote: post #68
smalltorch wrote: post #33

Reminds me of this side project I'm working on. https://gitlab/here_forawhile/torum It's a HN clone, that syncs with HN that allows you to basically establish smaller private communities who can discuss anything that's on HN without actually being on HN. It also indexes and let's you search through the DB which I find is really useful to find things that peak my interest.

*pique 'peak' refers to the top of a thing, commonly mountains

*find things that align with my intrest peaks

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

#106

Post by linmer »

tgv wrote: post #95
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.

It probably also got swamped in real-time...

Do you mean it's not updated? You gotta sort by update_time column. Looks sorted, but you gotta sort it with a query like:

SELECT * FROM hackernews_history

ORDER BY update_time DESC

LIMIT 100;

And yeah, I got that from deepseek because I don't have a brain.

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

#108

Post by GeoAtreides »

moralestapia wrote: post #103
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!

By uploading any User Content you hereby grant and will grant Y Combinator and its affiliated companies a nonexclusive, worldwide, royalty free, fully paid up, transferable, sublicensable, perpetual, irrevocable license to copy, display, upload, perform, distribute, store, modify and otherwise use your User Content for any Y Combinator-related purpose in any form, medium or technology now known or later developed. @z…

>Y Combinator and its affiliated companies

is zX41ZdbW either?

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

#110

Post by moralestapia »

GeoAtreides wrote: post #108
moralestapia wrote: post #103

Earlier quoted context omitted.

By uploading any User Content you hereby grant and will grant Y Combinator and its affiliated companies a nonexclusive, worldwide, royalty free, fully paid up, transferable, sublicensable, perpetual, irrevocable license to copy, display, upload, perform, distribute, store, modify and otherwise use your User Content for any Y Combinator-related purpose in any form, medium or technology now known or later developed. @z…

>Y Combinator and its affiliated companies is zX41ZdbW either?

Oh, now I see my comment might be a bit harsh.

I didn't consider you might now know about:

https://github.com/hackernews/api

Post reply on HN