You can also query for free at clickpy.clickhouse.com. If you click on any of th... | Hacker News

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

thesystemisbust 8 months ago | parent | context | favorite | on: Which NPM package has the largest version number?

You can also query for free at clickpy.clickhouse.com. If you click on any of the links on the visuals you can see the query used.

The underlying dataset is hosted at sql.clickhouse.com e.g. https://sql.clickhouse.com/?query=U0VMRUNUIGNvdW50KCkgICBGUk...

disclaimer: built this a a while ago but we maintain this at clickhouse

oh and rubygems data is also there.

darkamaul 8 months ago [–]

Here [0] is the partial query on the ClickHouse dataset, with different results due to a quota error [1].

[0] https://sql.clickhouse.com?query=U0VMRUNUIHByb2plY3QsIE1BWCh...

[1] Quota read limit exceeded. Results may be incomplete.

thesystemisbust 8 months ago | [–]

We have mvs you can use to avoid this

https://sql.clickhouse.com/?query=U0VMRUNUIHByb2plY3QsIE1BWC...

takes 0.1s

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