Submitted by Anonymous on June 2, 2014 - 5:33pm
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 );
Submitted by Anonymous on June 2, 2014 - 5:05pm
Description:
This chart shows the number of new projects in each repository that use the words "Free" and "Open" in project names through 2014.
Visualization:
SQL Script:
Freshmeat:
SELECT YEAR( date_added ) , COUNT( DISTINCT project_id ) AS Count
FROM fm_projects
WHERE projectname_full LIKE "%free%"
AND datasource_id = [current]
GROUP BY YEAR( date_added )
ORDER BY YEAR( date_added );
Submitted by Anonymous on June 2, 2014 - 4:24pm
Description:
This chart shows the number of projects of each team size listed in Savannah.
Visualization:
SQL Script:
SELECT DISTINCT project_dev_count, COUNT( DISTINCT project_name ) AS count
FROM sv_projects
WHERE datasource_id= [current]
GROUP BY project_dev_count
ORDER BY count DESC , project_dev_count
Submitted by Anonymous on June 2, 2014 - 12:22pm
Savannah is a free software code forge.
The SQL used to generate the data that made this chart is as follows:
SELECT CONCAT( MONTH( registration_date ) , '-', YEAR( registration_date ) ) , COUNT( DISTINCT project_name )
FROM sv_projects
WHERE datasource_id =8082
GROUP BY YEAR( registration_date ) , MONTH( registration_date )
ORDER BY YEAR( registration_date ) , MONTH( registration_date )
Submitted by megan on March 11, 2014 - 11:57am
Some new forge data has been released collected 04-Mar-2014.
Datasource_id's are as follows:
8079 - freecode
8080 - rubyforge
8081 - objectweb
8082 - savannah
8083 - tigris
8084 - alioth
IRC data:
8085 - 8134: Apache ServiceMix
8135 - 8185: Apache Camel
8186 - 8236: Apache ActiveMQ
8237 - 8287: Apache CXF
8288 - 8338: Apache-Aries
8339 - 8389: Apache Kalumet
8390 - 8440: Apache Karaf
Submitted by megan on December 16, 2013 - 1:29pm
December data has been released. We have a few old standbys (fc, rf, ow, sv, al) and some hot fresh data as well.
What is new, you ask? Well, we have some IRC chat log data for the Apache project Camel [1]. A nice new social data set, all parsed and organized into relational database format for you to query.
Savannah is a free software code forge.
Submitted by megan on May 23, 2012 - 11:43am
Data files have been released for May 2012. Go check it out on our Google Code downloads page.
Re-writes:
--Free Software Foundation has been re-written from scratch to match their new layout.
--Google Code collector has been re-written to fix a few bugs (still running)
--Launchpad has been finished and will be re-written for June to fix bugs
--Alioth is being re-written to fix bugs
Submitted by megan on January 18, 2012 - 1:34pm
We're cruising ahead with January 2012 releases. Grab the data from Google Code site or from the teragrid.
Freecode - done (formerly known as Freshmeat)
Savannah - done
Tigris - done
Rubyforge - done
Objectweb - done
Launchpad - done
Submitted by megan on November 2, 2011 - 12:49pm
Here is the status of the November 2011 collection:
done & ready to download on Google Code or query in Teragrid...
============
RUBYFORGE
OBJECTWEB
TIGRIS
LAUNCHPAD
SAVANNAH
ALIOTH
GITHUB
still collecting...
============
GOOGLE
Pages
