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

What are the most common code licenses used by projects listed in Google Code? (06-2011)

Description

This chart shows the top code licenses used by projects in Google Code. There were 23,810 projects that did not have a code license listed.

Visualization



SQL Script

SELECT gc.code_license AS License, COUNT(proj_name) AS Count
FROM gc_projects gc
WHERE gc.datasource_id = <current>
GROUP BY License
ORDER BY Count DESC;

What are the most common licenses used by projects listed in Launchpad? (06-2011)

Description

This chart shows the top licenses used by projects in Launchpad. There were 1,285 projects that did not have a license listed.

Visualization



SQL Script

SELECT lp.license AS License, COUNT(name) AS Count
FROM lpd_licenses lp
WHERE lp.datasource_id = <current>
GROUP BY License
ORDER BY Count DESC;

What are the most common programming languages used by projects listed in Launchpad? (06-2011)

Description

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

Visualization



SQL Script

SELECT lp.programming_language AS Lang, COUNT(name) AS Count
FROM lpd_programming_languages lp
WHERE lp.datasource_id = <current>
GROUP BY Lang
ORDER BY Count DESC;

Project Metadata Matrix, June 2011

Part of a series on Everything you ever wanted to know about code forges as of June 2011

Description: The table shows which project metadata items are available for projects on each code forge as of June 2011

Project Metadata Matrix, June 2011

Forge Name ACTactivity (ACT): There is a designated spot for forge to indicate how active the project is (ranking). ADLadministratorlist (ADL): There is a designated spot to list administrators on this project. DEVdevstatus(DEV): There is a designated spot for project to list its development status . ENVenviornments(ENV): There is a designated spot for project to list the enviornments it is designed for. EXTexternalURL(EXT): There is a designated spot for one or more external URLs. GIVgivedonations (GIV): Project can take donations via the forge. INTintendedaudience (INT): There is a designated spot for project to list its intended audience. URLinternalURL (URL): Forge provides a persistant internal URL for each project. LARlastreleased (LAR): There is a designated spot for the date of last release. LIClicenses (LIC): There is a designated spot to list the license(s) the project is released under. MEMmemberlist (MEM): There is a designated spot to list the members on this project. OPSopsys (OPS): There is a designated spot to list what operating system it is designed for. PROproglang (PRO): There is a designated spot to list programming languages used to write it. PRDprojectdescription (PRD): Lists a textual description of the project. REGregistrationdate (REG): There is a designated spot for project to list when it was registered on this forge. STSstatistics (STS): Forge publishes statistics on the project activity. TAGtags (TAG): There is a designated spot for tags describing this project. TOPtopic (TOP): There is a designated spot for project to list its topic(s). TRAtranslations (TRA): There is a designated spot for project to list its translations.
Alioth*http://alioth.debian.org
Est: March 29, 2003
Users: 11053
Projects: 920
Powered By: FusionForge
- - -
Assembla*http://assembla.com
Est: 2006
Users: 300,000
Powered By: Assembla
- - - - - - - - - - - - - - -
BerliOShttp://berlios.de
Est: January, 2000
Projects: 3,600
Powered By: FusionForge
- -
Bitbucket*http://bitbucket.org
Est: 2008
Users: 138,000
- - - - - - - - - - - - - - - - -
Codehaus*http://
Est: February 26, 2003
Projects: 288
- - - - - - - - - - - - - - - - - -
Codeplexhttp://codeplex.com
Est: May, 2006
Projects: 22,559
- - - - - - - - -
Fedora Hosted*http://fedorahosted.org
Est: December, 2007
Powered By: trac
- - - - - - - - - - - - - - - - - -
Github*http://github.com
Est: April 10, 2008
Users: 758,300
Projects: 2,119,817
- - - - - - - - - - - - - - - -
Gitorious*http://gitorious.org
Est: January, 2008
Powered By: Gitorious
- - - - - - - - - - - - -
Gna*http://gna.org
Est: January, 2004
Users: 15,199
Projects: 1,353
Powered By: Savane
- - - - - - - - - - -
Google Code*http://code.google.com
Est: March 17, 2005
Projects: 208,664
- - - - - - - - - - -
Java.Net*http://java.net
Est: 2003
Users: 604,505
Projects: 2,057
Powered By: Kenai
- - - - - - - - - - -
Javaforge*http://javaforge.com
Est: September, 2005
Users: 23,000
Projects: 494
Powered By: Codebeamer
- - - - - - - - - - -
Launchpad*http://launchpad.net
Est: 2004
Projects: 22,912
- - - - - - - -
Objectweb*http://forge.ow2.org
Est: 1999
Users: 19,813
Projects: 191
Powered By: Gforge
- - - - -
Origo*http://www.origo.ethz.ch
Est: 2006
Projects: 6,535
Powered By: Origo
- - - - - - - - - - - -
OSOR.eu*http://forge.osor.eu
Est: September, 2008
Users: 4,696
Projects: 225
Powered By: Gforge
-
Rubyforgehttp://rubyforge.org
Est: 2003
Users: 88,985
Projects: 9,206
Powered By: Gforge
- -
Sarovar*http://sarovar.org
Est: 2003
Users: 69,381
Projects: 514
Powered By: Gforge
- -
Savannahhttp://savannah.gnu.org
Est: 2000
Users: 51,709
Projects: 3,334
Powered By: Savane
- - - - - - - - - - -
Sharesource*http://sharesource.org
Est: 2006
Projects: 600
Powered By: Sharesource
- - - - - - - - - - -
Sourceforge*http://sourceforge.net
Est: November, 1999
Users: 2,700,000
Projects: 291,600
- - -
Tigris*http://tigris.org
Est: January 1, 2000
Projects: 799
- - - - - - - - - - - -
TuxFamily*http://tuxfamily.org
Est: 1999
Powered By: VHFFS
- - - - - - - - - - - - -


Forge-Specific Notes*

1. Alioth: Alioth shows some text on page for the tags, but I can't find an example of project that has actually set them. Despite being a gforge-based project, does not list "natural language" or translations for projects.

2. Assembla: project's internal URL is problematic as sometimes it uses a url like assembla.com/spaces/projname, but this doesn't work for some like nooku (featured project)

3. Bitbucket: Only user list is available through commit history (no project "teams" per se).

4. Codehaus: Calculated number of projects on CodeHaus by using the project directory to list projects alphabetically, then summing the counts (total 288). Codehaus does not have a project directory so it was somewhat difficult to survey a variety of projects. Artifacts are more prevalent than metadata.

5. FedoraHosted: only provides trac, so very difficult to find project-level metadata in unstructured text.

6. Github: only provides a README section as 'description' so difficult to parse out metadata from that.

7. Gitorious: Latest file release date not specified in obvious manner.

8. Gna: French Free Software Foundation site. Shows list of files to download but there is no obvious way to parse out the latest release date so I coded this as 'no'.

9. Google Code: Does have a project search and directory, but too large to use to calculate manually the number of hosted projects. Their "labels" = my "tags"; note that theirs are only added by the administrator.

10. Java.Net: Merged with Project Kenai.

11. JavaForge: project internal URLs can (but do not always) use a project id instead of project name. Projects can choose which items to make available. Here I have coded "yes" for any features that I saw in a consistent location on a subset of project pages, but these widgets (for example tracker details) are located on different screens for different projects. Project topic is called "category". Some projects have member count but not member list.

12. Launchpad: I coded their notion of a 'contributor' as a 'member'. Tags are only available for bugs.

13. Objectweb: Has a middleware focus.Despite being a gforge-based project, does not list "natural language" or translations for projects.

14. Origo: does not have a directory, so I used the "recent projects" featured on home page to check out what projects were hosted there. Topic is called "category" on their site.

15. OSOR.eu: Forge includes federated sites hosted elsewhere, but I did not include these in my project counts. Lists 0 or more natural languages per project; I coded this as "translations".

16. Sarovar: Sarovar is based in India. Lists 0 or more natural languages per project; I coded this as "translations".

17. Sharesource: has a "view rating" but not an "activity rating".

18. Sourceforge: Development status is only available for projects in the 'alpha' or 'beta' status via a small icon near the project name on it's main project summary page. There seems to be no apparent link to the member list from the project page, but there is a URL you can use to get to this list (https://sourceforge.net/project/memberlist.php?group_id=119453). You must know the 'group_id' of the project to get this list. This is the only forge that had 'awards' or 'features' as metadata, so I removed the tag.

19. Tigris: Calculated number of projects from project directory (by categories). There may be duplicates if projects are listed in more than one category. Used 'category' to map to my code for 'topic'. Statistics are optional for each project ("project metrics").

20. Tuxfamily: Offers a large tag-set for describing projects, but not explicit categories.

When were the forges established?

Description

This timeline illustrates when the forges were officially established.


Part of a series on Everything you ever wanted to know about code forges as of June 2011

Visualization

Forge Timeline

How many projects of each team size are listed in Google Code? (05-2011)

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;

What are the most common programming languages used by projects listed in Rubyforge? (05-2011)

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;

What are the most common operating systems used by projects listed in Rubyforge? (05-2011)

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;

What are the most common programming languages used by projects listed in Objectweb? (05-2011)

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;

What are the most common operating systems used by projects listed in Objectweb? (05-2011)

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;

Syndicate content