Rubyforge Project Registrations, 2003-2014

Rubyforge is a software development "code forge" associated with projects written in the Ruby programming language. This chart shows the growth of new projects registered on this forge from July 2003 - December 2013. We used datasource_id=317 in this example.

The SQL to generate the data used to populate this graph is as follows (fill in the datasource_id accordingly):

SELECT CONCAT(MONTH( date_registered ) , '-', YEAR( date_registered )) , COUNT( DISTINCT proj_unixname )
FROM rf_projects
WHERE datasource_id = 12987
GROUP BY YEAR( date_registered ) , MONTH( date_registered )
ORDER BY YEAR( date_registered ) , MONTH( date_registered );