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

As of June 2009, what are the top operating systems used by projects listed in Rubyforge?

Description

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

Visualization

Rubyforge Operating System Chart

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;

As of June 2009, what are the top programming languages used by projects listed in Sourceforge?

Description

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

Visualization

Sourceforge Programming Language Chart

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;

As of June 2009, what are the top operating systems used by projects listed in Sourceforge?

Description

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

Visualization

Sourceforge Operating System Chart

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;

As of June 2009, what are the top programming languages used by projects listed in Objectweb?

Description

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

Visualization:

Objectweb Programming Language Chart

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;

As of June 2009, what are the top operating systems used by projects listed in Objectweb?

Description

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

Visualization

Objectweb Operating System Chart

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;

As of June 2009, how many projects of each team size are listed in Sourceforge?

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).

Sourceforge Developer Count Chart

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;

As of June 2009, how many projects of each team size are listed in Objectweb?

Description

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

Visualization

Objectweb Developer Count Chart

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;

As of June 2009, how many projects of each team size are listed in Rubyforge?

Description

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

Visualization

Rubyforge Developer Count Chart

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;

As of June 2009, how many projects of each team size are listed in Free Software Foundation?

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).

Free Software Foundation Developer Count Chart

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;

As of June 2009, how has the use "Free" and "Open" in project names grown by year?

Description

This chart shows the number of new projects in each repository that use the words "Free" and "Open" in project names. (We ran the queries to make this chart in June. This means 2009 was not yet completed, so this explains the apparent drop-off for the 2009 numbers.)

Visualization

Freshmeat Free & Open Count Chart

SQL Script

Sourceforge:

SELECT year(date_registered) , count(DISTINCT proj_unixname) FROM projects
WHERE proj_unixname LIKE "%free%"
AND datasource_id = <current>
GROUP BY year(date_registered)
ORDER BY year(date_registered) ;


SELECT year(date_registered) , count(DISTINCT proj_unixname) FROM projects
WHERE proj_unixname LIKE "%open%"
AND datasource_id = <current>
GROUP BY year(date_registered)
ORDER BY year(date_registered) ;

Freshmeat:

SELECT year(date_added), count(DISTINCT project_id) FROM fm_projects
WHERE projectname_full LIKE "%free%"
AND datasource_id = <current>
GROUP BY year(date_added)
ORDER BY year(date_added);


SELECT year(date_added), count(DISTINCT project_id) FROM fm_projects
WHERE projectname_full LIKE "%open%"
AND datasource_id = <current>
GROUP BY year(date_added)
ORDER BY year(date_added);

Rubyforge:

SELECT year(date_registered), count(DISTINCT proj_unixname) FROM rf_projects
WHERE proj_unixname LIKE "%free%"
AND datasource_id = <current>
GROUP BY year(date_registered)
ORDER BY year(date_registered);


SELECT year(date_registered), count(DISTINCT proj_unixname) FROM rf_projects
WHERE proj_unixname LIKE "%open%"
AND datasource_id = <current>
GROUP BY year(date_registered)
ORDER BY year(date_registered);

Syndicate content