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 packages are required most by Free Software Foundation projects? (07-2011)

Description

This chart shows the packages that are required most frequently in FSF projects. There is a total of 8,024 requirements.

Visualization



SQL Script

SELECT requirement AS Requirement, COUNT(proj_num) AS Count
FROM fsf_project_requirements
WHERE datasource_id = <current>
GROUP BY Requirement
ORDER BY Count DESC;

What time of the day is email communication highest in Alioth projects? (07-2011)

Description

This chart shows the hourly breakdown of email communication in select Alioth projects. The projects shown had the highest total number of emails in their mailing lists.

Visualization:



SQL Script

SELECT COUNT(m.message_id), hour(m.date_sent)
FROM al_messages m
INNER JOIN al_mailing_lists l
ON l.mailing_list = m.mailing_list
WHERE l.project = 'project_name'
AND l.datasource_id = <current>
GROUP BY HOUR(m.date_sent)

What programming languages are paired together in Lanchpad projects (Network Diagram)? (07-2011)

Description

This graph shows a network diagram of the programming languages paired together by projects in Launchpad. The top 100 combinations are represented in the visual.

Visualization

LP Network Diagram


For an interactive visual, click the image below and then click the "Recompute layout" button (connected dots).


What programming languages are paired together in Launchpad projects? (07-2011)

Description

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

Visualization

LP Lang Pairs


What is the status of current Alioth projects? (07-2011)

Description

This chart shows the status breakdown of Alioth projects.

Visualization:



SQL Script

SELECT status AS Status, COUNT( unixname ) AS Count
FROM al_projects_status
WHERE datasource_id = <current>
GROUP BY Status
ORDER BY Count DESC;

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

Description

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

Visualization:



SQL Script

SELECT language AS Lang, COUNT( unixname ) AS Count
FROM al_projects_language
WHERE datasource_id = <current>
GROUP BY Lang
ORDER BY Count DESC;

What are the most common operating systems used by projects in Alioth? (07-2011)

Description

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

Visualization



SQL Script

SELECT os AS System, COUNT( unixname ) AS Count
FROM al_projects_os
WHERE datasource_id = <current>
GROUP BY System
ORDER BY Count DESC;

What are the most common licenses used by projects in Alioth? (07-2011)

Description

This chart shows the top licenses used by projects in Alioth.

Visualization



SQL Script

SELECT license AS License, COUNT(unixname) AS Count
FROM al_projects_license
WHERE datasource_id = <current>
GROUP BY License
ORDER BY Count DESC;

What are the most common bugs in Launchpad projects? (07-2011)

Description: This shows the top 30 bugs tagged in Launchpad projects as of June 2011.

Launchpad Bug Cloud, June 2011
LPbugcloud



SQL Script

SELECT lp.official_bug_tag AS Bug, COUNT(name) AS Count
FROM lpd_official_bug_tags lp
WHERE lp.datasource_id = <current>
GROUP BY Bug
ORDER BY Count DESC;

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

Description

This chart shows the top content licenses used by projects in Google Code. There were 197,465 projects that did not list a content license.

Visualization



SQL Script

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

Syndicate content