rubyforge

Description:

This chart shows the number of NEW projects added to each repository by month/year.

Visualization:

Notes: RF had ~750 projects without a project start date.

SQL Script:

SELECT MONTH( date_added ) , YEAR( date_added ) , COUNT( DISTINCT project_id )
FROM fm_projects
WHERE datasource_id = [current]
GROUP BY YEAR( date_added ) , MONTH( date_added )
ORDER BY YEAR( date_added ) , MONTH( date_added );

Description:

This chart show the number of projects for each team size in Rubyforge.

Visualization:

Projects listed as having 0 developers were disregarded (159 projects).

SQL Script:

SELECT DISTINCT dev_count, COUNT( DISTINCT proj_unixname ) AS count
FROM rf_projects
WHERE datasource_id = [current]
GROUP BY dev_count
ORDER BY count DESC , dev_count

Description:

This chart shows the top programming languages used by projects in Rubyforge.

Visualization:

SQL Script:

SELECT rfpl.description AS Lang, COUNT( DISTINCT rfpl.proj_unixname ) AS Count
FROM rf_project_programming_language rfpl
WHERE rfpl.datasource_id = [current]
GROUP BY Lang
ORDER BY Count DESC;

Each project on Rubyforge can list what license it uses. The following chart was generated in June 2014 (datasource_id=12987) to show the most common licenses (all those with more than 10 projects using it) and how many projects.

Here is the SQL code used to generate the data for this chart:

SELECT description, count( * )
FROM rf_project_licenses
WHERE datasource_id =[current datasource_id]
GROUP BY 1
ORDER BY 2 DESC;