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

Examples

Queries and visualizations to help people use data

Number of Projects per Team Size in Savannah (June 2014)

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

Most Commonly Used Operating Systems by Objectweb Projects (June 2014)

Description:

This chart shows the top operating systems used by projects in Objectweb.

Visualization:

SQL Script:

SELECT owop.description AS System, COUNT( DISTINCT owop.proj_unixname ) AS Count
FROM ow_project_operating_system owop
WHERE owop.datasource_id = [current]
GROUP BY System
ORDER BY Count DESC;

Most Commonly Used Languages by Objectweb (June 2014)

Description:

This chart shows the top programming languages used by projects in Objectweb.

Visualization:

SQL Script:

SELECT owpl.description AS Lang, COUNT( DISTINCT owpl.proj_unixname ) AS Count
FROM ow_project_programming_language owpl
WHERE owpl.datasource_id = [current]
GROUP BY Lang
ORDER BY Count DESC;

Most Commonly Used Operating Systems by Rubyforge Projects (June 2014)

Description:

This chart shows the top operating systems used by projects in Rubyforge.

Visualization:

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;

Most Commonly Used Languages by Rubyforge Projects (June 2014)

Description:

This chart shows the top programming languages used by projects in Rubyforge.

Visualization:

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;

Most Commonly Used Licenses by Alioth Projects (June 2014)

Description:

This chart shows the top licenses used by projects in Alioth.

Visualization:

SQL Script:

SELECT license AS License, COUNT(unixname) AS Count
FROM al_projects_license
WHERE datasource_id = [current]
GROUP BY License
ORDER BY Count DESC;

Most Commonly Used Operating Systems by Alioth Projects

Description:

This chart shows the top operating systems used by projects in Alioth.

Visualization

SQL Script:

SELECT os AS System, COUNT( unixname ) AS Count
FROM al_projects_os
WHERE datasource_id =
GROUP BY System
ORDER BY Count DESC;

Most Commonly Used Programming Languages in Alioth Projects (June 2014)

Description:

This chart shows the top programming languages used by projects in Alioth.

Visualization:

SQL Script:

SELECT language AS Lang, COUNT( unixname ) AS Count
FROM al_projects_language
WHERE datasource_id =
GROUP BY Lang
ORDER BY Count DESC;

Current Status of Alioth Projects (June 2014)

Description:

This chart shows the status breakdown of Alioth projects.

Visualization:

SQL Script:

SELECT status AS Status, COUNT( unixname ) AS Count
FROM al_projects_status
WHERE datasource_id =
GROUP BY Status
ORDER BY Count DESC;

Freecode New Project Registrations by Month, 1998-2014

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 - March 2014. This data is based on the registration date recorded for each project and collected by FLOSSmole in June 2014(datasource_id 8079).

The SQL code to gather this data from our FLOSSmole database is as follows:

SELECT CONCAT(MONTH( date_added ) , '-', YEAR( date_added )) , COUNT( DISTINCT project_id )
FROM fm_projects
WHERE datasource_id = [current datasource_id]
GROUP BY YEAR( date_added ) , MONTH( date_added )
ORDER BY YEAR( date_added ) , MONTH( date_added );

Syndicate content