Submitted by megan on May 12, 2016 - 3:10pm
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.
![](http://flossmole.org/system/files/ProjectRepositoryGrowth2014.png)
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:
![](http://flossmole.org/system/files/growthOfOpenFreeJune2014.png)
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:48pm
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).
![](http://flossmole.org/system/files/RubyforgeTeamSizeCount.png)
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
Submitted by Anonymous on June 2, 2014 - 3:48pm
Description:
This chart shows the top operating systems used by projects in Rubyforge.
Visualization:
![](http://flossmole.org/system/files/RubyOperatingSystems2014.png)
SQL Script:
SELECT rfop.description AS System, COUNT( DISTINCT rfop.proj_unixname ) AS Count
FROM rf_project_operating_system rfop
WHERE rfop.datasource_id = [current]
GROUP BY System
ORDER BY Count DESC;
Submitted by Anonymous on June 2, 2014 - 3:38pm
Description:
This chart shows the top programming languages used by projects in Rubyforge.
Visualization:
![](http://flossmole.org/system/files/RubyProgrammingLanguages2014.png)
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;
Submitted by Anonymous on June 2, 2014 - 12:35pm
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.
![](http://flossmole.org/system/files/rubyforgeregistrations2014.png)
The SQL to generate the data used to populate this graph is as follows (fill in the datasource_id accordingly):
Submitted by Anonymous on June 2, 2014 - 10:19am
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.
![](http://flossmole.org/system/files/rubyforgelicenses2014.png)
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;
Submitted by megan on May 15, 2014 - 1:19pm
The last Rubyforge collection happened yesterday. The datasource_id = 12987. All the data is located on our file downloads site, or in the database (ossmole_merged schema, tables prefixed 'rf', use datasource_id=12987 in your SQL queries).
RIP Rubyforge! We have been collecting from there for 10 years. Charts and graphs coming soon.
![rubyforge shuts down](http://flossmole.org/system/files/rf.png)
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
Pages