3 ms·
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 ho
by thesystemisbust 1y ago
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=U0VMRUNUIGNvdW50KCkgICBGUk9NIHB5cGkucHlwaSBMSU1JVCAxMDAw 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 1y agoHere [0] is the partial query on the ClickHouse dataset, with different results due to a quota error [1]. [0] https://sql.clickhouse.com?query=U0VMRUNUIHByb2plY3QsIE1BWChMRU5HVEgodmVyc2lvbikpIEFTIG1heF92ZXJzaW9uX2xlbmd0aApGUk9NIHB5cGkucHlwaQpHUk9VUCBCWSBwcm9qZWN0Ck9SREVSIEJZIG1heF92ZXJzaW9uX2xlbmd0aCBERVNDCkxJTUlUIDEwOwo https://sql.clickhouse.com?query=U0VMRUNUIHByb2plY3QsIE1BWCh... [1] Quota read limit exceeded. Results may be incomplete.
- thesystemisbust 1y agoWe have mvs you can use to avoid this https://sql.clickhouse.com/?query=U0VMRUNUIHByb2plY3QsIE1BWChMRU5HVEgodmVyc2lvbikpIEFTIG1heF92ZXJzaW9uX2xlbmd0aApGUk9NIHB5cGkucHlwaV9kb3dubG9hZHNfYnlfdmVyc2lvbgpHUk9VUCBCWSBwcm9qZWN0Ck9SREVSIEJZIG1heF92ZXJzaW9uX2xlbmd0aCBERVNDCkxJTUlUIDEwOwo https://sql.clickhouse.com/?query=U0VMRUNUIHByb2plY3QsIE1BWC... takes 0.1s