As of June 2009, how have projects in each repository grown by year?

Description

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

Visualization

SQL Script

Sourceforge:

SELECT year(date_registered) , count(DISTINCT proj_unixname) FROM projects
WHERE datasource_id = <current>
GROUP BY year(date_registered)
ORDER BY year(date_registered);


Freshmeat:

SELECT year(date_added), count(DISTINCT project_id) FROM fm_projects
WHERE datasource_id= <current>
GROUP BY year(date_added)
ORDER BY year(date_added);


Rubyforge:

SELECT year(date_registered), count(DISTINCT proj_unixname) FROM rf_projects
WHERE datasource_id= <current>
GROUP BY year(date_registered)
ORDER BY year(date_registered);


Objectweb:

SELECT year(date_registered), count(DISTINCT proj_unixname) FROM ow_projects
WHERE datasource_id= <current>
GROUP BY year(date_registered)
ORDER BY year(date_registered);