Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

There's also two DBs I know of that have an updated Hacker News table for running analytics on without needing to download it first.

- BigQuery, (requires Google Cloud account, querying will be free tier I'd guess) — `bigquery-public-data.hacker_news.full`

- ClickHouse, no signup needed, can run queries in browser directly, [1]

[1] https://play.clickhouse.com/play?user=play#U0VMRUNUICogRlJPT...



It even finds your comment 'clickhouse': https://play.clickhouse.com/play?user=play#U0VMRUNUICogRlJPT...


and now yours :)


The ClickHouse resource is amazing. It even has history! I had already done my own exercise of downloading all the JSON before discovering the Clickhouse HN DBs.


+1




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: