warning: Creating default object from empty value in /var/www/drupal/modules/taxonomy/taxonomy.pages.inc on line 33.

launchpad

August 2015 Launchpad data

We have added Launchpad data under datasource_id 58458. Launchpad is a repository for projects affiliated with Ubuntu. Summer research assistant Gavan Roth wrote some scripts to collect this data.

--Download the flat files, or
--Access and query this data via the MySQL interface

Here is a query to show some of the data that is available:

SELECT programming_language, COUNT( * )
FROM `lpd_programming_languages`
WHERE datasource_id =58458
GROUP BY 1
ORDER BY 2 DESC ;

september Launchpad data is released

Huge thank you to our former student and flossmole alumnus Christian Funkhouser for working on re-writing the Launchpad collector to use the API.

Get the code!

The datasource_id for Launchpad in September is 342!

May 2012 data releases

Data files have been released for May 2012. Go check it out on our Google Code downloads page.

Re-writes:
--Free Software Foundation has been re-written from scratch to match their new layout.
--Google Code collector has been re-written to fix a few bugs (still running)
--Launchpad has been finished and will be re-written for June to fix bugs
--Alioth is being re-written to fix bugs

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 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 licenses used by projects listed in Launchpad? (06-2011)

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;

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

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;

June Data: Google Code, Launchpad, Github

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.

How many projects are listed in each repository? (05-2011)

Description

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

Visualization

Project Count Chart


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>;

Syndicate content