We're cruising ahead with January 2012 releases. Grab the data from Google Code site or from the teragrid.

Freecode - done (formerly known as Freshmeat)
Savannah - done
Tigris - done
Rubyforge - done
Objectweb - done
Launchpad - done

Google Code - still running
Alioth - bug submitted #54
Gihub - will start as soon as Google is done

Free Software Foundation - bug still not fixed (this is my fault) #51

Interesting things: most popular data from November ..... drumroll please.... Google Code, Github.

Here is the status of the November 2011 collection:

done & ready to download on Google Code or query in Teragrid...
============
RUBYFORGE
OBJECTWEB
TIGRIS
LAUNCHPAD
SAVANNAH
ALIOTH
GITHUB

still collecting...
============
GOOGLE

collectors broken and waiting to be fixed...
============
FRESHMEAT (BUG # 43)
UDD (BUG # 50)
DEBIAN (BUG # 48)
FREE SOFTWARE FOUNDATION (BUG # 51)

Description

This chart shows the top mailing list types used by projects in Alioth. Any mailing lists with an abbreviated type name were grouped accordingly (example: -pkg = packaging). There are 873 total mailing lists currently used in Alioth.

Visualization

SQL Script

This query grabs the text after the last "-" in the mailing list name.

SELECT substr(mailing_list, 2+char_length(mailing_list) -locate('-', reverse(mailing_list) ) ) as 'type', count(mailing_list)
FROM al_mailing_lists
WHERE datasource_id = <current>
GROUP BY 1
ORDER BY 2 DESC;

Description

This graph shows the ratio of senders to email messages in Alioth project mailing lists.

Visualization:

The first number shown when hovering over a dot is the number of senders. The second number is the number of messages for each sender count.


SQL Script

SELECT mailing_list, COUNT(DISTINCT sender), COUNT(DISTINCT message_id)
FROM al_messages
GROUP BY mailing_list;

Description

This graph shows the number of mailing lists with each count of email senders in Alioth.

Visualization:

The first number shown when hovering over a dot is the number of senders. The second number is the number of mailing lists with that sender count.

SQL Script

Use the results from the following query to create a temp table.

SELECT mailing_list AS List, COUNT(DISTINCT sender) AS Senders
FROM al_messages
GROUP BY List
ORDER BY Senders DESC;

Use the temp table for the following query.

SELECT sender_count AS Sender Count, COUNT(mailing_list) AS Frequency
FROM al_temp_table
GROUP BY Sender Count
ORDER BY Frequency DESC;

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)


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;


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;


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;


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;