Hacker News Reader

This will save your time:

Takeaways:

- .org is 50% better than .com; - .edu and .gov are really nice; - .io is cool, and much better than .uk;

PS. I don't remember any rate limits of the API. Here is how I downloaded the data: https://github.com/ClickHouse/ClickHouse/issues/29693

Thanks zX41zdbW - I find the query you shared easier to reason about than:

Also:

"Elapsed: 0.140 sec, read 33.95 million rows, 1.26 GB."

140 ms is quite impressive.

to be fair, that is large part because CH seems to have a topLevelDomain function