FSF Network of Related Projects, July 2012

The Free Software Foundation directory (FSF) allows each project to list other FSF projects that are related to it.

We could construct a social network showing what projects are related. Here is the SQL code needed to make the list of what projects are related to what other projects:

SELECT pr.proj_num, p.proj_unixname, pr.related_project_name
FROM fsf_project_related pr
INNER JOIN fsf_projects p ON p.proj_num = pr.proj_num
WHERE p.datasource_id=[current datasource_id]
AND pr.datasource_id=[current datasource_id];

You can also just see the most commonly related projects by counting as follows:

SELECT related_project_name, count( * )
FROM `fsf_project_related`
WHERE datasource_id = [current datasource_id]
GROUP BY 1
ORDER BY 2 DESC