warning: Creating default object from empty value in /var/www/drupal/modules/taxonomy/taxonomy.pages.inc on line 33.

code licenses

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:

SELECT license, count( * )
FROM tig_projects
WHERE datasource_id = [current datasource_id]
GROUP BY 1
ORDER BY 2 DESC

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;

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;

Objectweb Project Licenses, July 2012

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 July 2012.

Here is the SQL code to generate the data set:

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

Rubyforge License Counts, July 2012

Each project on Rubyforge can list what license it uses. The following chart was generated in July 2012 (datasource_id=317) to show the most common licenses (all those with more than 10 projects using it) and how many projects.

What seems interesting about this chart is that Rubyforge is the only forge I've seen where GPL (or some variant thereof) is NOT the most common license.

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;

Tigris License Counts, July 2012

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:

SELECT license, count( * )
FROM tig_projects
WHERE datasource_id = [current datasource_id]
GROUP BY 1
ORDER BY 2 DESC

What are the most common code licenses used by projects listed in Google Code? (06-2011)

Description

This chart shows the top code licenses used by projects in Google Code. There were 23,810 projects that did not have a code license listed.

Visualization



SQL Script

SELECT gc.code_license AS License, COUNT(proj_name) AS Count
FROM gc_projects gc
WHERE gc.datasource_id = <current>
GROUP BY License
ORDER BY Count DESC;

Syndicate content