Live data from Hacker News

Tell HN: Hacker News BigQuery dataset is updated daily again

news.ycombinator.com

Post reply on HN

Print view View original

11–12 of 12 posts

Re: Tell HN: Hacker News BigQuery dataset is updated daily again

#11

Post by zX41ZdbW » Tue, Jun 25, 2024, 12:22 AM UTC

Daily is too infrequently.

I have this dataset being updated in ClickHouse in real time: https://play.clickhouse.com/play?user=play#U0VMRUNUIG1heCh0a...

I also provide a way to export it or attach it to clickhouse-local and analyze it locally: https://github.com/ClickHouse/ClickHouse/issues/29693#issuec...

Re: Tell HN: Hacker News BigQuery dataset is updated daily again

#12

Post by tarasglek » Tue, Jun 25, 2024, 5:46 AM UTC

zX41ZdbW wrote: post #11

Daily is too infrequently. I have this dataset being updated in ClickHouse in real time: https://play.clickhouse.com/play?user=play#U0VMRUNUIG1heCh0a... I also provide a way to export it or attach it to clickhouse-local and analyze it locally: https://github.com/ClickHouse/ClickHouse/issues/29693#issuec...

I love that this dataset is accessible via cors from web frontends. Got me into experiments with clickhouse

Same with github, much better than than throttled apis

Post reply on HN