Freecode New Project Registrations by month, 1998-2012
Freecode (formerly known as Freshmeat) is a directory of free and open source software. FLOSSmole has been collecting Freecode/Freshmeat data since 2004. Periodically we provide snapshots as to the growth of the various forges and directories we collect data from. Here is a chart showing the rate of new project additions to Freecode/Freshmeat from January 1998 - June 2012. This data is based on the registration date recorded for each project and collected by FLOSSmole in mid-July 2012 (datasource_id 316).
The SQL code to gather this data from our FLOSSmole database is as follows:
SELECT MONTH( date_added ) , YEAR( date_added ) , COUNT( DISTINCT project_id )
WHERE datasource_id = [current datasource_id]
GROUP BY YEAR( date_added ) , MONTH( date_added )
ORDER BY YEAR( date_added ) , MONTH( date_added );