And then which version of libcloud was used, grouped by Python version
This is the query for the pypi bigtable
https://bigquery.cloud.google.com/table/the-psf:pypi.downloads
SELECT
file.version,
REGEXP_EXTRACT(details.python, r"^([^\.]+\.[^\.]+)") as python_version,
COUNT(*) as download_count,
FROM
TABLE_DATE_RANGE(
[the-psf:pypi.downloads],
DATE_ADD(CURRENT_TIMESTAMP(), -31, "day"),
DATE_ADD(CURRENT_TIMESTAMP(), -1, "day")
)
WHERE
file.project = 'apache-libcloud'
GROUP BY
file.version,
python_version
ORDER BY
download_count DESC
LIMIT 100
On Thu, Jan 18, 2018 at 2:06 PM, anthony shaw <anthony.p.s...@gmail.com>
wrote:
> Since this recently came up, here is the Python version used in
> downloading libcloud in the past month.
>
> We could almost safely deprecate 2.6 support
>
> Row python_version download_count
> 1 2.7 29200
> 2 null 8670
> 3 3.5 3836
> 4 3.6 1804
> 5 3.4 856
> 6 2.6 490
> 7 1.17 93
> 8 3.3 21
>
file_version,python_version,download_count
2.2.1,2.7,11649
1.1.0,2.7,6280
1.5.0,2.7,5817
1.1.0,3.5,3170
2.0.0,2.7,1391
2.2.0,2.7,817
0.12.4,2.7,764
2.2.1,3.6,690
1.3.0,2.7,658
2.2.1,2.6,487
2.2.1,3.5,433
1.1.0,,401
0.19.0,2.7,367
1.5.0,3.6,366
2.2.1,3.4,362
2.2.1,,301
0.14.1,,295
1.0.0-rc2,,292
0.19.0,,291
1.0.0-pre1,,290
0.17.0,,286
1.3.0,,283
0.20.1,,283
0.16.0,,281
1.2.1,,279
1.0.0,,277
0.15.0,,276
0.20.0,,276
0.14.0,,276
1.4.0,,270
2.1.0,2.7,268
0.15.1,,265
1.1.0,3.4,257
0.20.1,2.7,256
1.1.0,3.6,252
0.13.3,,220
0.13.1,,219
0.13.2,,218
0.13.0,,217
0.18.0,,216
0.14.0-beta3,,215
0.12.4,,214
0.15.1,2.7,190
2.1.0,3.4,186
0.18.0,2.7,180
0.17.0,2.7,171
2.0.0,3.6,160
2.2.0,,156
1.5.0,,154
2.0.0rc2,,152
0.14.0,2.7,149
0.4.0,,148
2.1.0,,148
1.5.0,3.5,138
2.0.0,,137
1.3.0,3.6,115
0.16.0,2.7,108
0.11.0,,89
0.6.1,,88
0.7.1,,88
0.11.3,,87
0.9.1,,87
0.5.0,,86
0.11.1,,85
2.2.0,3.6,84
0.12.1,,84
0.10.1,,83
0.11.4,,83
0.5.2,,83
0.8.0,,83
0.6.2,,81
0.12.3,,81
0.4.2,,80
2.1.0,3.6,75
2.0.0,3.5,73
0.3.1,,66
0.20.1,3.6,54
0.11.1,2.7,41
1.4.0,2.7,35
1.0.0,2.7,22
1.1.0,3.3,20
1.2.1,3.4,18
0.20.1,3.4,13
0.20.0,2.7,11
1.2.1,2.7,11
2.2.1,1.17,10
2.0.0,3.4,9
1.5.0,3.4,6
0.14.1,2.7,5
1.0.0,3.4,4
0.20.1,3.5,4
1.0.0,3.5,4
0.13.2,2.7,3
0.20.0,3.5,3
0.15.0,2.7,3
1.0.0-rc2,1.17,2
2.0.0rc2,1.17,2
0.18.0,1.17,2
1.1.0,1.17,2
0.14.0,1.17,2
