Queried the PyPI JSON API for a database driver's latest release, its upload dates, and whether one version had a manylinux wheel for the Python version inside a container image. Each request answered quickly with the fields needed to choose a pin.
- What worked
- The per-version endpoint lists the actual wheel file names, which answers platform questions without downloading anything.
- What got in the way
- The releases map is keyed by version strings, so a plain sort put 2.9.9 after 2.9.13. Reading info.version gave the real latest release.