As of June 2009, how many projects at each repository share URL's?

Description

This chart shows the number of projects at each repository that share URL's.

Visualization

Number of Projects at each Repository that List a Home Page at Another Repository

Matching projects by URL has two possiblities: projects listed on different forges might both display the same external URL, or projects on one forge might actually list the project site on a competing forge as the home page of record. The diagram shown in the figure above depicts each forge/directory in FLOSSmole and how many of its projects list another forge as the actual hosting home page. For example, in the diagram, the topmost arrow shows 11,229 projects on the Freshmeat that actually have Sourceforge listed as the home page. The arrow notation is used to show a direction of the relationship (e.g. 11,229 Freshmeat projects show a home page on Sourceforge, but only 10 Sourceforge projects list a Freshmeat home page). Pairs of forges with no URLs in common do not show an arrow. (No Rubyforge projects list ObjectWeb URLs, and vice versa.)

For more information on matching project names and URLs, see:

Squire, M. (2009). Integrating projects from multiple open source code forges. International Journal of Open Source Software & Processes, 1(1). January-March 2009. pp. 46-57.

SQL Script

RF-SF

SELECT count(r.proj_unixname) FROM rf_projects r
WHERE (r.real_url like "%sourceforge%"
OR r.real_url like "%sf.net%")
AND datasource_id= <current>;


RF-FM

SELECT count(r.proj_unixname) FROM rf_projects r
WHERE r.real_url like "%freshmeat%"
AND datasource_id= <current>;


RF-OW

SELECT count(r.proj_unixname) FROM rf_projects r
WHERE r.real_url like "%objectweb%"
AND datasource_id= <current>;


FM-RF

SELECT count(f.project_id) FROM fm_project_homepages f
WHERE f.real_url_homepage like "%rubyforge%"
AND datasource_id= <current>;


FM-SF

SELECT count(f.project_id) FROM fm_project_homepages f
WHERE (f.real_url_homepage like "%sourceforge%"
OR f.real_url_homepage like "%sf.net%")
AND datasource_id= <current>;


FM-OW

SELECT count(f.project_id) FROM fm_project_homepages f
WHERE f.real_url_homepage like "%objectweb%"
AND datasource_id= <current>;


SF-FM

SELECT count(p.proj_unixname) FROM projects p
WHERE p.real_url like "%freshmeat%"
AND datasource_id= <current>;


SF-OW

SELECT count(p.proj_unixname) FROM projects p
WHERE p.real_url like "%objectweb%"
AND datasource_id= <current>;


SF-RF

SELECT count(p.proj_unixname) FROM projects p
WHERE p.real_url like "%rubyforge%"
AND datasource_id= <current>;


OW-SF

SELECT count(o.proj_unixname) FROM ow_projects o
WHERE (o.real_url like "%sourceforge%" or o.real_url like "%sf.net%")
AND datasource_id= <current>;


OW-RF

SELECT count(o.proj_unixname) FROM ow_projects o
WHERE o.real_url like "%rubyforge%"
AND datasource_id= <current>;


OW-FM

SELECT count(o.proj_unixname) FROM ow_projects o
WHERE o.real_url like "%freshmeat%"
AND datasource_id= <current>;