|
数据来源地址:http://www.githubarchive.org/
十大年度语言(创建分支最多)
BigQuery语句:
- SELECT repository_language, count(repository_language) AS repos_by_lang
- FROM [githubarchive:github.timeline]
- WHERE repository_fork == "false"
- AND type == "CreateEvent"
- AND PARSE_UTC_USEC(repository_created_at) >= PARSE_UTC_USEC('2013-01-01 00:00:00')
- AND PARSE_UTC_USEC(repository_created_at) < PARSE_UTC_USEC('2014-01-01 00:00:00')
- GROUP BY repository_language
- ORDER BY repos_by_lang DESC
- LIMIT 10
复制代码 结果
Row | repository_language | repos_by_lang | 1 | JavaScript | 533305 | 2 | Ruby | 407542 | 3 | Java | 330398 | 4 | PHP | 257410 | 5 | Python | 212241 | 6 | C++ | 155147 | 7 | C | 138488 | 8 | CSS | 121684 | 9 | Objective-C | 72993 | 10 | C# | 70520 |
从上面可以看出:Web开发活跃度更高,Ruby的开发者比较勤奋.
我会告诉你懒得发其它排名的原因是Discuz!的排版实在是渣,排个表格的时间远比写代码的时间长十倍好吗???
|
|