Our demo applications
Open-source demos showcasing the speed and scalability of ClickHouse
adsb.exposed
With over 50 billion air traffic control records (or Automatic Dependent Surveillance-Broadcast Data), we visualize the flight paths of current aircraft. With this demo, you can see helicopter rides over the world's great cities, F16 training exercises, detours around volcanoes, balloons over the Alps, UFOs in Area 51, your favorite airport, and Elon Musk's globe-trotting. All through the most beautiful visuals.
The data is hosted in a ClickHouse database and queried on the fly, rendering directly in the browser with a single HTML file without web frameworks. You can tune the visualizations with custom SQL queries and, if nothing else, enjoy a new art form.
ClickPy
Explore free Python package analytics powered by ClickHouse. Almost 1 trillion rows of data and counting, which includes every download of a Python package via PyPI. Ever. See how your favorite Python package (ours is chDB) is performing, or just find out what's currently hot in the Python ecosystem.
This dataset is updated daily and includes GitHub events data to provide further statistics for those Python projects with a GitHub repository. Users are free to query the underlying tables and derive their own insights.
CryptoHouse
CryptoHouse is a free blockchain analytics service powered by ClickHouse with the aim of democratizing blockchain analytics. Users can use SQL to query blockchain data, such as Solana and Ethereum, which is updated in real-time, thanks to Goldsky. Save and share queries or chart metrics, with examples provided, to get users started. We welcome external contributions to the example queries and materialized views.
Pastila
What better way to share a ClickHouse SQL query than a service powered by ClickHouse? Pastila is a free Pastebin service powered by ClickHouse. Paste it into your code snippet and share the URL. Links never expire thanks to ClickHouse's ability to store billions of messages efficiently. Read more about how this service was built here.
GitHub Archive
Everything you always wanted to know about GitHub (but were afraid to ask).
We prepared a dataset from the GH Archive that contains all the events in all GitHub repositories since 2011 in a structured format. The 7.5B row dataset was uploaded into ClickHouse, where it is updated hourly. We redistribute it for research purposes and provide some sample queries. Alternatively, users can download and process the data themselves.
This dataset can help answer almost any question about GitHub that you can imagine. Top repositories by stars? How has the list of top repositories changed over the years? Repositories with the highest growth YoY? Repositories with the maximum amount of pull requests?
Or maybe just find a friend through commonly-starred repos!