Better PyPI stats

You can use https://pypistats.org to see the downloads for a given PyPI package. However, the statistics and visualizations provided by the website are limited. The purpose of this project is to provide a better dynamic alternative with Ibis, ClickHouse, and Shiny for Python.

Dashboard

https://connect.posit.cloud/lostmygithubaccount/content/019180af-9e47-14bd-0955-38e6d98a5f98

Connecting to data

import ibis

ibis.options.interactive = True

host = "clickpy-clickhouse.clickhouse.com"
port = 443
user = "play"
database = "pypi"

con = ibis.clickhouse.connect(
  host=host,
  port=port,
  user=user,
  database=database,
)

con.list_tables()

Development

Install gh and just and uv, then:

gh repo clone ibis-project/better-pypi-stats
cd better-pypi-stats
just setup
. .venv/bin/activate
just app

Contributing

Contributions welcome. Please format your code:

just fmt