ClickPy – OSS project and service for Python analytics using ClickHouse
Thought i'd share some recent work i'd done after being generally frustrated as to the available analytics for Python modules. Most seem to be either limited in time or incur charges to query. Code is Apache 2 at https://github.com/clickHouse/clickpy The downloads for Python modules are actually available in BigQuery - a row for every package download in the world. Last time i checked it's the largest BigQuery public dataset at almost 700b rows. Wanting to do some serious analytics led to a few frustrations though: - speed for queries - BigQuery is great for complex SQL,…
In plain words
ClickPy is an open-source analytics tool for Python package downloads built on ClickHouse. It provides fast, free querying of Python module download data sourced from BigQuery's 700-billion-row dataset. Designed for developers and package maintainers who need detailed analytics without speed limitations or query costs, ClickPy addresses performance and affordability gaps in existing analytics solutions. The project is available under Apache 2 license.
written from the facts on this page · September 2026
From the sources
In the maker’s words, at launch
Thought i'd share some recent work i'd done after being generally frustrated as to the available analytics for Python modules. Most seem to be either limited in time or incur charges to query. Code is Apache 2 at https://github.com/clickHouse/clickpy The downloads for Python modules are actually available in BigQuery - a row for every package download in the world. Last time i checked it's the largest BigQuery public dataset at almost 700b rows. Wanting to do some serious analytics led to a few frustrations though: - speed for queries - BigQuery is great for complex SQL, less so for fast analytics. - cost :) especially as i wanted to offer this for free. Knowing that ClickHouse excels at this sort of problem (as a ClickHouse employee full disclosure), I set about exporting the data to GCS and importing to ClickHouse. A weekend learning NextJS+React and some help from a designer friend (thanks Daniel!) and ClickPy was born! For now the analytics are quite simple but I plan to enrich them over time. I've made the cluster also public and read-only so users can run the app themselves - and hopefully contribute back. Finally, i'm planning to keep the dataset up-to-date daily (maybe more in the future). It's proven a useful test case for the ClickHouse dev team and has already found a few issues in the core db. Contributions welcome and let me know if you find it useful for digging into the downloads of your own package. Cheers, GingerWizard
More dev tools this month
the category →
Open-source GTM skills for technical founders
Dev tools · 29d ago · gtmcofounder.com
OpenTrailPaper is open-source bike computer firmware for the LilyGO T5S3 4.7" E-Paper PRO. It supports offline maps, GPX routes, FIT recording and Bluetooth sensors.
Dev tools · 1d ago · opentrailpaper.com
Launched alongside, November 2023
the whole month →
Discover & book top creators to promote your product
Growth · 2023 · passionfroot.me
