What types of mailing lists are most commonly used in Alioth projects? (07-2011)

Submitted by Anonymous on July 27, 2011 - 2:17pm

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;