All Hacker News posts dataset on Google BigQuery

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

this is great, thanks for sharing

This has appeared on HN a few times before - but it's so useful that it seems worth resharing periodically.

Is it free to use?

You can use it for free from kaggle: https://www.kaggle.com/code/felixdietze/hacker-news-score-an...

yes, although there is a paid tier they try to upgrade you to. worth noting that there are some limits on how much data you can export in one go - I found the easiest way was to dump out pieces you need to google drive.

what about their github api?

what about it?