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

SQL Script
SELECT rfpl.description, count(DISTINCT rfpl.proj_unixname) AS lang
FROM rf_project_programming_language rfpl
WHERE rfpl.datasource_id = <current>
GROUP BY rfpl.description
ORDER BY lang DESC;
Description
This chart shows the top operating systems used by projects in Rubyforge.
Visualization

SQL Script
SELECT rfop.description, count(DISTINCT rfop.proj_unixname) AS system
FROM rf_project_operating_system rfop
WHERE rfop.datasource_id = <current>
GROUP BY rfop.description
ORDER BY system DESC;
Description
This chart shows the top programming languages used by projects in Sourceforge.
Visualization

SQL Script
SELECT ppl.description, count(DISTINCT ppl.proj_unixname) AS lang
FROM project_programming_language ppl
WHERE ppl.datasource_id = <current>
GROUP BY ppl.description
ORDER BY lang DESC;
Description
This chart shows the top operating systems used by projects in Sourceforge.
Visualization

SQL Script
SELECT pop.description, count(DISTINCT pop.proj_unixname) AS system
FROM project_operating_system pop
WHERE pop.datasource_id = <current>
GROUP BY pop.description
ORDER BY system DESC;
Description
This chart shows the top programming languages used by projects in Objectweb.
Visualization:

SQL Script
SELECT owpl.description, count(DISTINCT owpl.proj_unixname) AS lang
FROM ow_project_programming_language owpl
WHERE owpl.datasource_id = <current>
GROUP BY owpl.description
ORDER BY lang DESC;
Description
This chart shows the top operating systems used by projects in Objectweb.
Visualization

SQL Script
SELECT owop.description, count(DISTINCT owop.proj_unixname) AS system
FROM ow_project_operating_system owop
WHERE owop.datasource_id = <current>
GROUP BY owop.description
ORDER BY system DESC;
Description
This chart shows the number of projects of each team size listed in Sourceforge.
Visualization
Projects listed as having NULL or 0 developers were disregarded (1432 and 1478 projects, respectively).

SQL Script
SELECT DISTINCT dev_count, count(DISTINCT proj_unixname) AS count
FROM projects
WHERE datasource_id = <current>
GROUP BY dev_count
ORDER BY count DESC , dev_count;
Description
This chart shows the number of projects of each team size listed in Objectweb.
Visualization

SQL Script
SELECT DISTINCT dev_count, count(DISTINCT proj_unixname) AS count
FROM ow_projects
WHERE datasource_id = <current>
GROUP BY dev_count
ORDER BY count DESC , dev_count;
Description
This chart shows the number of projects of each team size listed in Rubyforge.
Visualization

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;
Description
This chart shows the number of projects of each team size listed in Free Software Foundation.
Visualization
Projects listed as having 0 developers were disregarded (53 projects).

SQL Script
SELECT DISTINCT calc_dev_count, count(DISTINCT proj_num) AS count
FROM fsf_projects
WHERE datasource_id= <current>
GROUP BY calc_dev_count
ORDER BY count DESC, calc_dev_count;