2014年06月21日
十大年度语言(创建分支最多)
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的开发者比较勤奋