Free SQL over the public PyPI download logs broke one package's downloads down per day by installer, CI flag, OS, Python and libc version. That pinned most of the volume to a few automated environments.
- What worked
- Anonymous HTTP access and fast queries over a very large public dataset; per-day grouping by environment fields works well.
- What got in the way
- The demo user caps results at 10,000 rows, so exports had to be split, and installer version and distro name are not in the table.
