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

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

Description

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

Visualization

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

Launchpad Bug Cloud, June 2011

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;


Description

This chart shows the top licenses used by projects in Launchpad. There were 1,285 projects that did not have a license listed.

Visualization

SQL Script

SELECT lp.license AS License, COUNT(name) AS Count
FROM lpd_licenses lp
WHERE lp.datasource_id = <current>
GROUP BY License
ORDER BY Count DESC;


Description

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

Visualization

SQL Script

SELECT lp.programming_language AS Lang, COUNT(name) AS Count
FROM lpd_programming_languages lp
WHERE lp.datasource_id = <current>
GROUP BY Lang
ORDER BY Count DESC;


Summer is a beautiful thing. Moles, we've got a huge Google Code release for you (ds=271), and the re-vamped Launchpad (ds=272), and also Github (ds=273).

Get your FRESH June data on our Google Code Downloads Page or LIVE on the Teragrid.

Tigris is fixed and is running right now. We're also writing a new collector for Alioth! Lots of new stuff.

Got a bug in the Freshmeat collector, so I'm wrangling that. Thanks to a user for reporting that bug. Don't forget we do have a bug-tracking system on Google Code.

Finally, we've got a fresh UDD upload and Debian data coming soon also. We're just so productive right now!

Also don't forget to check out our collection of Everything You Ever Wanted to Know About Code Forges - data also available on our Google Code download site.

Description

This chart shows the number of projects that FLOSSmole most recently collected from each repository.

Visualization

SQL Script


SELECT COUNT( DISTINCT proj_name )
FROM gc_projects
WHERE datasource_id = <current>;



SELECT COUNT( DISTINCT project_id )
FROM fm_projects
WHERE datasource_id = <current>;



SELECT COUNT( DISTINCT project_name )
FROM lp_projects
WHERE datasource_id = <current>;



SELECT COUNT( DISTINCT proj_unixname )
FROM rf_projects
WHERE datasource_id= <current>;



SELECT COUNT( DISTINCT proj_num )
FROM fsf_projects
WHERE datasource_id= <current>;



SELECT COUNT( DISTINCT project_name )
FROM sv_projects
WHERE datasource_id= <current>;



SELECT COUNT( DISTINCT unixname )
FROM tg_projects
WHERE datasource_id = <current>;



SELECT COUNT( DISTINCT proj_unixname )
FROM ow_projects
WHERE datasource_id= <current>;


Introducing a new data source: Launchpad data. In this collection, Launchpad has about 19k projects in it and about 34k developers.

mysql> select count(*) from lp_projects where datasource_id=227;
18956

mysql> select count(distinct dev_loginname) from lp_developer_indexes where datasource_id=227;
34051

Available on our Google Code downloads page: Launchpad data