search

crflynn / pypistats.org

PyPI downloads analytics dashboard
https://pypistats.org/
138 stars 10 forks source link

Add Mirror Software Graphs / Data Analysis #12

Open cooperlees opened 5 years ago

cooperlees commented 5 years ago

Hi,

Many thanks for this project! It's cool.

I'm a bandersnatch contributor and I'd love to see a page added for Mirroring software and the versions of each respective system used. Namely, bandersnatch, as I am bias.

Do you have an idea of how you'd like this done if I (or you) were to implement it? Today I query Google and a nice graph on your page would be amazing and simplify my life! :D

crflynn commented 5 years ago

Do you mean aggregating the downloads across all pypi specifically for mirroring applications? That could be interesting sure. Do you have some sample queries to share so I can get an idea of what specifically you would want to see?

cooperlees commented 5 years ago

Exactly. Getting stats like my example for each mirroring software is nice to show what version people are using around the world. Here is an example query for only bandersnatch:

SELECT
  details.installer.version,
  count(*)
FROM
  `the-psf.pypi.downloads20181125`
WHERE
  details.installer.name = 'bandersnatch'
GROUP BY
  1
ORDER BY
  2

This will show the trends of how often people update bandersnatch and other mirroring software. Should also let us roughly guess how many bandersnatch installations are running around the world each day.