Skip to content

Instantly share code, notes, and snippets.

@ianb ianb/package-count.md Secret
Last active Jun 5, 2019

Embed
What would you like to do?

Previously: https://gist.github.com/ianb/9124545

Current package list:

  • waitforit
  • minimock
  • wsgi-intercept
  • webob
  • sqlapi
  • wsgiproxy
  • htconsole
  • cmdutils
  • pastescript
  • webtestrecorder
  • sqlobject
  • sqlobject2
  • debugheaders
  • webtest
  • workingenv.py
  • tempita
  • ohm
  • wareweb
  • sqlobject
  • devauth
  • wsgioverlay
  • wsgiremote
  • dtopt
  • scripttest
  • formencode
  • wsgifilter
  • tracpaste
  • initools
  • deliverance
  • weberror
  • fassembler
  • cherrypaste
  • djangopaste
  • httpencode
  • paste
  • pylogo
  • ScriptTranscluder
  • VaingloriousEye
  • zptkit
  • pastedeploy
  • wphp
  • pip
  • virtualenv

BigQuery:

#standardSQL
SELECT COUNT(*) AS num_downloads, file.project
FROM `the-psf.pypi.downloads*`
WHERE lower(file.project) IN ('waitforit', 'minimock', 'wsgi-intercept',
'webob',
'sqlapi',
'wsgiproxy',
'htconsole',
'cmdutils',
'pastescript',
'webtestrecorder',
'sqlobject',
'sqlobject2',
'debugheaders',
'webtest',
'workingenv.py',
'tempita',
'ohm',
'wareweb',
'sqlobject',
'devauth',
'wsgioverlay',
'wsgiremote',
'dtopt',
'scripttest',
'formencode',
'wsgifilter',
'tracpaste',
'initools',
'deliverance',
'weberror',
'fassembler',
'cherrypaste',
'djangopaste',
'httpencode',
'paste',
'pylogo',
'scripttranscluder',
'vaingloriouseye',
'zptkit',
'pastedeploy',
'wphp',
'pip',
'virtualenv'
)
GROUP BY file.project

Results roughly:

pip = 979,167,771

virtualenv = 157,499,426

everything else = 69,736,505

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.