What Do We Measure?

The INSTALL events of Community Extensions (as well as regular extensions), which trigger downloads from the http[s]://community-extensions.duckdb.org site, are tracked by Cloudflare.

We re-publish data about the total number of downloads, aggregated across DuckDB versions and platforms at the https://community-extensions.duckdb.org/downloads-last-week.json endpoint.

An example query to return the list of community extensions sorted by descending number of downloads would be:

UNPIVOT (
    SELECT 'community' AS repository, *
        FROM 'https://community-extensions.duckdb.org/downloads-last-week.json'
    ) ON COLUMNS(* EXCLUDE (_last_update, repository))
INTO NAME extension VALUE downloads_last_week
ORDER BY downloads_last_week DESC;