Description

This chart shows the number of projects of each team size listed in Google Code.

Visualization

SQL Script

Use the results from the following query to create a temp table.

SELECT datasource_id, unixname, COUNT( dev_name ) AS dev_count
FROM gc_developer_projects
WHERE datasource_id = <current>
GROUP BY unixname;

Use the temp table for the following query.

SELECT dev_count, COUNT(unixname) AS Count
FROM gc_temp
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 Savannah.

Visualization

Projects listed as having 0 developers were disregarded (73 projects).

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


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 (57 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;


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

Projects listed as having 0 developers were disregarded (152 projects).

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 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;


Description

This chart shows the number of projects of each team size listed in Freshmeat.

Visualization

Projects listed as having 0 developers were disregarded (332 projects).

SQL Script

SELECT DISTINCT calc_dev_count, count(DISTINCT project_id) AS count
FROM fm_projects
WHERE datasource_id= <current>
GROUP BY calc_dev_count
ORDER BY count DESC, calc_dev_count;