The Top Twenty Programming Languages in GitHub for 2014

I’m writing an overview of Code for a project and thought I’d see if you can query GitHub at a meta-data level. Turns out you sure can 🙂 Check out the GitHub Archive over here

Row repository_language repos_by_lang
1 JavaScript 267193
2 Java 200889
3 Ruby 188521
4 PHP 126322
5 CSS 124412
6 C 111537
7 Python 103123
8 C++ 56977
9 Objective-C 44526
10 C# 42716
11 Shell 33517
12 R 19724

(Generated used Adam Bard’s query and Google Big Query via his blog

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(‘2014-01-01 00:00:00’)
AND PARSE_UTC_USEC(repository_created_at) < PARSE_UTC_USEC(‘2014-06-10 00:00:00’)
GROUP BY repository_language
ORDER BY repos_by_lang DESC

Web Development Problems with Apache following MacOSX upgrade to Yosemite

Yosemite OSX


If you’ve just installed the Yosemite beta on your development machine and your web environment has stopped working – as it usually does following a major OSX update – it’s likely this.

Apache has been upgraded to 2.4 from 2.2 and you’ll need to adjust your Directory directives as follows:

2.2 configuration:

Order allow,deny
Allow from all

2.4 configuration:

Require all granted


Here’s the full upgrade page from

PHP is also upgraded to version  5.5.9 (cli) (built: May 10 2014 21:37:28). I’ve not encountered any major issue there yet but it’s worth reading upgrade pages on that too. Here’s the PHP page on the changes and compatibility issues.