4 ms·
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 Goog
by montebicyclelo 1y ago
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#U0VMRUNUICogRlJPTSBoYWNrZXJuZXdzX2hpc3RvcnkgV0hFUkUgbG93ZXIodGV4dCkgTElLRSAnJXB5dGhvbiUnIE9SREVSIEJZIHRpbWUgREVTQyBMSU1JVCAxMA== https://play.clickhouse.com/play?user=play#U0VMRUNUICogRlJPT...
- xnx 1y agoThe 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.
- kordlessagain 1y agoIt even finds your comment 'clickhouse': https://play.clickhouse.com/play?user=play#U0VMRUNUICogRlJPTSBoYWNrZXJuZXdzX2hpc3RvcnkgV0hFUkUgbG93ZXIodGV4dCkgTElLRSAnJWNsaWNraG91c2UlJyBPUkRFUiBCWSB0aW1lIERFU0MgTElNSVQgMTA= https://play.clickhouse.com/play?user=play#U0VMRUNUICogRlJPT...
- ZeWaka 1y agoand now yours :)
- k0ns0l 1y ago+1