Examples

Queries and visualizations to help people use data

Freecode Project Registrations (1998-2014) with language tags

This chart shows the new project registrations for each year 1998-2014, and what programming language those projects were tagged with.

For example, 2003 was the highest year for new "C" projects to be registered with Freecode (then called Freshmeat).

Data Resources: 

Rubyforge Project Registrations, 2003-2014

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.

The SQL to generate the data used to populate this graph is as follows (fill in the datasource_id accordingly):

Tags: 
Data Resources: 

Savannah Project Registrations by month, 2000-2014

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 )

Tags: 
Data Resources: 

Alioth Project Registrations by month, 2003-2014

Alioth is a Debian-centric code forge. We collect the information about projects hosted on this forge. This chart shows the creation of new projects on this forge from 2003-2014. The datasource_id used is 8084.

The SQL code used to generate the data to build this chart from FLOSSmole database is as follows:

Tags: 
Data Resources: 

Updated Freecode Project Counts, 2005-2014

We have collected Freecode (formerly Freshmeat) data since 2005. This chart shows the number of projects listed in the Freecode directory between 2005 and 2014. Each line represents one collection. (Collections are referred to in our database by the term "datasource_id".)

Here is the code used in the FLOSSmole database to generate the data list to create this graph:

Data Resources: 

Freecode License Counts, June 2014

This chart shows the 20 most popular licenses chosen by the projects on Freecode.

The SQL to get the data from FLOSSmole to build this chart is as follows:

SELECT f.license, count( f.project_id )
FROM fm_projects f
WHERE datasource_id=[current datasource_id]
GROUP BY 1
ORDER BY 2 DESC
LIMIT 20;

Data Resources: 

Freecode Project Dependencies, June 2014

Freecode allows each project to declare which other projects it is dependent upon. Here is a chart showing the projects that were declared dependencies most frequently. PHP was the project selected most often by other projects as a dependency.

Here is the SQL code used to generate this data set from the FLOSSmole database:

Tags: 
Data Resources: 

Tigris License Counts, June 2014

Tigris lists the open source license that each project is using. The following chart shows the licenses used by projects on Tigris, and how many projects use each. Note that UNLIKE some other forges, variations of the GPL (and other licenses with multiple versions) are not differentiated by version, rather they are all lumped together.

Here is the SQL needed to generate the data set from the FLOSSmole database:

Data Resources: 

Objectweb Project Licenses, June 2014

Objectweb allows each project to state what license it uses. Here is a chart showing these licenses for all the projects on Objectweb, as of June 2014.

Here is the SQL code to generate the data set:

SELECT description, count( * )
FROM `ow_project_licenses`
WHERE datasource_id =8081
GROUP BY 1
ORDER BY 2 DESC;

Data Resources: 

Rubyforge License Counts, June 2014

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;

Data Resources: 

Pages