FLOSSmole

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;


Description

This chart shows the number of projects that FLOSSmole most recently collected from each repository.

Visualization

SQL Script

SELECT count(DISTINCT proj_unixname) FROM projects
WHERE datasource_id= <current>;



SELECT count(DISTINCT project_id) FROM fm_projects
WHERE datasource_id= <current>;



SELECT count(DISTINCT proj_unixname) FROM rf_projects
WHERE datasource_id= <current>;



SELECT count(DISTINCT proj_unixname) FROM ow_projects
WHERE datasource_id= <current>;



SELECT count(DISTINCT proj_num) FROM fsf_projects
WHERE datasource_id= <current>;