使用Google BigQuery分析GitHub流行趋势

046569

数据来源地址:http://www.githubarchive.org/
十大年度语言(创建分支最多)
BigQuery语句:

1. SELECT repository_language, count(repository_language) AS repos_by_lang
   
2. FROM [githubarchive:github.timeline]
   
3. WHERE repository_fork == "false"
   
4. AND type == "CreateEvent"
   
5. AND PARSE_UTC_USEC(repository_created_at) >= PARSE_UTC_USEC('2013-01-01 00:00:00')
   
6. AND PARSE_UTC_USEC(repository_created_at) < PARSE_UTC_USEC('2014-01-01 00:00:00')
   
7. GROUP BY repository_language
   
8. ORDER BY repos_by_lang DESC
   
9. 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!的排版实在是渣,排个表格的时间远比写代码的时间长十倍好吗???