5 ms·
The Hacker News BigQuery data makes this quite easy: select * from `bigquery-public-data.hacker_news.full` where `by` = 'ilaksh' and type = 'comment' order by
by opjjf 2y ago
The Hacker News BigQuery data makes this quite easy:
select *
from `bigquery-public-data.hacker_news.full`
where `by` = 'ilaksh' and type = 'comment'
order by timestamp desc
EDIT: seems this is out of date
- hipadev23 2y agoClickhouse has an updated dataset: https://play.clickhouse.com/play?user=play#U0VMRUNUICogRlJPTSBoYWNrZXJuZXdzX2hpc3RvcnkgT1JERVIgQlkgdGltZSBERVNDIExJTUlUIDEwMA== https://play.clickhouse.com/play?user=play#U0VMRUNUICogRlJPT...
- SushiHippie 2y agoOr using the algolia API like so: https://news.ycombinator.com/item?id=40634899 https://news.ycombinator.com/item?id=40634899