Queries and visualizations to help people use data
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 - 4:11pm
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;
Submitted by Anonymous on June 2, 2014 - 4:04pm
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;
Submitted by Anonymous on June 2, 2014 - 3:48pm
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;
Submitted by Anonymous on June 2, 2014 - 3:38pm
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;
Submitted by Anonymous on June 2, 2014 - 3:18pm
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;
Submitted by Anonymous on June 2, 2014 - 3:13pm
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;
Submitted by Anonymous on June 2, 2014 - 3:09pm
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;
Submitted by Anonymous on June 2, 2014 - 2:55pm
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;
Submitted by Anonymous on June 2, 2014 - 2:07pm
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).
Pages
