Skip to content

Instantly share code, notes, and snippets.

@simi

simi/gems-required-ruby-stats.csv

Last active April 14, 2020 19:28
Show Gist options
  • Save simi/c280428ab90ca35d470e61a2191ed101 to your computer and use it in GitHub Desktop.
Save simi/c280428ab90ca35d470e61a2191ed101 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gems-required-ruby-stats.csv
count required_ruby_version
92222 >= 0
60103
2302 >= 1.9.3
2285 >= 2.0.0
1327 >= 2.3.0
900 >= 2.0
872 ~> 2.0
758 >= 1.9
744 >= 2.1.0
664 >= 2.3
663 >= 1.9.2
529 >= 2.2.0
486 >= 2.4.0
473 >= 2.2.2
456 >= 2.4
423 >= 2.1
345 >= 2.2
342 >= 1.8.7
306 >= 2.5.0
251 ~> 2.3
232 ~> 2.1
202 >= 2.5
144 >= 1.8.6
142 >= 1.9.1
132 >= 2.3.1
125 >= 1.9.0
124 ~> 2.2
117 >= 2.1.2
113 ~> 2.4
87 ~> 2
80 >= 2.3.3
76 ~> 2.5
73 >= 2
53 >= 2.5.1
53 >= 2.3.8
53 >= 2.2.3
51 >= 2.6.0
51 >= 1.8
47 >= 2.7.0
46 >= 2.6
41 >= 2.1.5
40 >= 2.6.3
36 >= 2.4.1
31 >= 2.2.6
29 >= 1.8.1
28 >= 2.2.1
28 ~> 2.6
28 >= 1.8.4
27 >= 2.2.5
27 >= 2.2.4
27 > 0.0.0
26 >= 2.6.5
23 >= 1.8.0
23 > 1.8
23 >= 2.5.3
22 >= 2.1.10
21 >= 1.8.2
21 >= 1.8.5
21 >= 2.1.9
19 >= 2.1.1
18 ~> 2.7
17 ~> 2.5.1
17 >= 2.4.2
16 >= 2.2.7
15 >= 2.1.3
14 >= 2.4.6
14 > 1.9
14 > 2.1
13 >= 2.3.7
13 >= 2.4.4
13 >= 2.3.4
12 >= 2.5.5
11 >= 2.1.6
11 >= 2.4.9
11 >= 2.1.8
10 ~> 2.3.0
9 >= 2.6.1
9 >= 2.4.5
9 ~> 1.9.3
9 >= 2.4, < 2.8
8 ~> 2.3.1
8 > 2.0.0
8 >= 2.3.6
8 ~> 1.8.7
7 >= 2.1.7
7 > 1.9.0
7 >= 2.4, < 2.7
7 >= 2.2.9
6 >= 2.4.3
6 >= 2.5.7
6 >= 2.2.10
6 > 2.0
6 >= 2.0.1
5 >= 1.0.1
5 > 1.9.3
5 ~> 1.9
5 > 2.1.0
5 >= 1.6
5 ~> 2.2.0
4 ~> 2.5.0
4 ~> 1.8.6
4 >= 2.6.4
4 < 2.5, >= 2.0
4 >= 2.7
4 < 2.5.0, >= 2.1.0
4 >= 2.2.8
4 > 2.3
4 < 3.0
4 > 2.6.0, < 2.7
4 ~> 2.6.0
3
3 ~> 1.9.1
3 ~> 2.0.0
3 = 2.1.0
3 ~> 2.1.0
3 >= 2.1.4
3 > 2.2.0
3 ~> 2.2.1
3 ~> 2.2.2
3 >= 2.2, < 2.7.dev
3 >= 2.2, < 2.8.dev
3 >= 2.2.3, ~> 2.2
3 >= 2.3.1, ~> 2.3
3 >= 2.3, ~> 2
3 >= 2.3.2
3 ~> 2.4.1
3 ~> 2.4.2
3 >= 2.4.7
3 > 2.5
3 >= 2.6.2
2 >= 1.8.7, < 3.0
2 = 2.4.2
2 ~> 2.2.4
2 < 2.5.0, >= 2.2.0
2 < 2.5.0, >= 2.3.0
2 < 2.3.0, >= 2.0.0
2 < 2.6, >= 2.1
2 > 2.2.2
2 >= 2.3.0, ~> 2.3
2 >= 1.9.2.330
2 ~> 2.1.1
2 >= 2.0.0.247
2 >= 2.3.3, < 2.7
2 > 2.3.0, != 2.4.0
2 ~> 2.1.3
2 ~> 2.4.0
2 >= 2.5, < 3
2 != 1.9.2
2 ~> 2.5.3
2 >= 2.3.5
2 > 2.3.0
2 >= 2.0.0p247
2 >= 1.0
2 >= 2.1.2, ~> 2.1
2 >= 2.4.0, < 2.6.0
2 < 3, >= 1.9.3
2 >= 2.2.2, < 2.7.0
2 < 2.5
2 > 2.0.99
2 < 1.9
2 < 3, >= 2.0
2 ~> 2.2.3
2 < 2.0
2 ~> 2.1.2
1 >= 2.3.3, < 2.5.0
1 = 2.3.4
1 ~> 2.3.5
1 < 2.3.6, >= 2.1.0
1 < 2.1, >= 1.9.3
1 >= 2.3.8, < 2.7.0
1 < 2.4
1 > 2.4
1 >= 2.1.0dev
1 > 2.4.0
1 < 2.1.0
1 >= 2.4.0.0
1 < 2.4.0, >= 2.0.0
1 < 2.4.0, >= 2.1.3
1 >= 2.4.0, < 2.7.0
1 >= 2.4.1p111
1 >= 2.0.0.451
1 < 3, >= 2.3
1 < 2.4, >= 2.0.0
1 <= 2.4, >= 2.1.0
1 < 2.4.2, > 2.2.6
1 >= 2.4, < 2.7.dev
1 >= 2.0.0, < 2.4
1 >= 2.4, < 2.8.dev
1 >= 2.4, < 3
1 >= 2.0.0p648
1 >= 2.0.0p481
1 >= 2.0.0.pre.p647
1 < 3, >= 2.3.3
1 >= 2.0.0.pre.p0
1 < 3, >= 2.4
1 = 2.0
1 >= 1.9.3, < 3.0
1 >= 1.9.3p125
1 ~> 1.9.3.pre.p551
1 <= 2.5.0, >= 2.3.0
1 < 2.5.0, >= 2.3.1
1 >= 1.9.3.pre.p550
1 > 1.9.2
1 < 2.5, >= 2.1.0
1 < 2.5, >= 2.3
1 >= 2.5, < 2.7.dev
1 >= 2.5, < 2.8
1 >= 2.5, < 2.8.dev
1 = 1.9.1
1 >= 2.5.6
1 < 1.9.1
1 ~> 2.5.7
1 > 2.5.9
1 = 2.6
1 <= 1.9.0
1 = 1.9
1 >= 1.8.7.376
1 < 2.6.0, >= 2.3.0
1 < 2.6.0, >= 2.4.0
1 = 1.8.7, >= 1.9.3
1 ~> 2.6.1
1 < 2.6, >= 1.9
1 >= 0.95
1 < 2.6, >= 2.0
1 < 2.6, ~> 2.2
1 < 2.6, >= 2.2.2
1 < 2.6, >= 2.3
1 < 2.6, >= 2.4
1 < 2.6, >= 2.5
1 > 1.8.7
1 ~> 2.6.3
1 > 1.8.5
1 ~> 1.8.0
1 ~> 2.6.5
1 > 2.6.99
1 >= 1.3.5
1 > 100.0
1 >= 1.0.0
1 ~> 2.7.0
1 >= 2.2.2, < 2.6.0
1 >= 2.2.2, < 2.7
1 ~> 2.2, >= 2.2.7
1 < 3.0.0, >= 1.9.3
1 < 3.0.0, >= 2.1.8
1 = 2.2.3
1 ~> 2.2, >= 2.2.5
1 < 3.0, >= 1.9
1 >= 2.2, ~> 2.2
1 < 2.2.3, >= 2.2.0
1 > 2.2.5
1 >= 2.2, ~> 2
1 >= 2.2.5, ~> 2.2
1 ~> 2.2.10
1 > 2.2.1
1 >= 2.2.0, < 3.0.0
1 >= 2.2.9, < 2.6
1 < 2.2.0, >= 2.0.0
1 = 2.2.0
1 < 2.2.0
1 = 2.3.0
1 > 2.2
1 ~> 2.1.8
1 >= 2.3.0dev
1 >= 2.3.0p0
1 <= 2.3.0, >= 2.1.0
1 >= 2.3.0, < 2.6.0
1 >= 2.3.0, < 2.8.0
1 ~> 2.1.7
1 ~> 2.1.5
1 >= 2.3.1, ~> 2
1 < 3.0, >= 1.9.3
1 <= 3.0, >= 2.3
1 ~> 2.3.2
1 < 2.3, >= 2.0
1 >= 2.3, <= 2.7
1 >= 2.3, < 2.7.dev
1 >= 2.3, < 2.8
1 >= 2.3, < 2.8.dev
1 >= 2.3, < 3
1 > 2.1.5
1 ~> 2.3.3
1 >= 2.3.3p222
Raw
query.sql
SELECT count(id), required_ruby_version FROM (
SELECT rubygems.id, latest_version.required_ruby_version FROM rubygems
LEFT JOIN LATERAL (SELECT * FROM versions WHERE rubygems.id = versions.rubygem_id ORDER BY id DESC LIMIT 1) latest_version ON TRUE
) s
GROUP BY s.required_ruby_version
ORDER BY 1 DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment