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

objectweb

ObjectWeb Collections updated

We updated our ObjectWeb collections. You can find out more about the data we have, or download flat data files in raw format or query the data directly from the FLOSSmole database. The most recent datasource_id is 70912.

Some sample queries:

What licenses are used most by ObjectWeb projects?


SELECT description, count(*)
FROM ow_project_licenses
WHERE datasource_id = 70912
GROUP BY 1
ORDER BY 2 DESC;

Growth of Projects in Each Repository (June 2014)

Description:

This chart shows the number of NEW projects added to each repository by month/year.

Visualization:

Notes: RF had ~750 projects without a project start date.

SQL Script:

SELECT MONTH( date_added ) , YEAR( date_added ) , COUNT( DISTINCT project_id )
FROM fm_projects
WHERE datasource_id = [current]
GROUP BY YEAR( date_added ) , MONTH( date_added )
ORDER BY YEAR( date_added ) , MONTH( date_added );

SELECT MONTH( date_registered ) , YEAR( date_registered ) , COUNT( DISTINCT proj_unixname )
FROM rf_projects
WHERE datasource_id = [current]
GROUP BY YEAR( date_registered ) , MONTH( date_registered )
ORDER BY YEAR( date_registered ) , MONTH( date_registered );

SELECT MONTH( registration_date ) , YEAR( registration_date ) , COUNT( DISTINCT project_name )
FROM sv_projects
WHERE datasource_id = [current]
GROUP BY YEAR( registration_date ) , MONTH( registration_date )
ORDER BY YEAR( registration_date ) , MONTH( registration_date );

Number of Projects per Team Size in Objectweb (June 2014)

Description:

This chart shows the number of projects of each team size listed in Objectweb.

Visualization:

SQL Script:

SELECT DISTINCT dev_count, COUNT( DISTINCT proj_unixname ) AS count
FROM ow_projects
WHERE datasource_id = [current]
GROUP BY dev_count
ORDER BY count DESC , dev_count

Most Commonly Used Operating Systems by Objectweb Projects (June 2014)

Description:

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

Visualization:

SQL Script:

SELECT owop.description AS System, COUNT( DISTINCT owop.proj_unixname ) AS Count
FROM ow_project_operating_system owop
WHERE owop.datasource_id = [current]
GROUP BY System
ORDER BY Count DESC;

Most Commonly Used Languages by Objectweb (June 2014)

Description:

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

Visualization:

SQL Script:

SELECT owpl.description AS Lang, COUNT( DISTINCT owpl.proj_unixname ) AS Count
FROM ow_project_programming_language owpl
WHERE owpl.datasource_id = [current]
GROUP BY Lang
ORDER BY Count DESC;

Objectweb Project Licenses, June 2014

Objectweb allows each project to state what license it uses. Here is a chart showing these licenses for all the projects on Objectweb, as of June 2014.

Here is the SQL code to generate the data set:

SELECT description, count( * )
FROM `ow_project_licenses`
WHERE datasource_id =8081
GROUP BY 1
ORDER BY 2 DESC;

New March 2014 data released

Some new forge data has been released collected 04-Mar-2014.

Datasource_id's are as follows:

8079 - freecode
8080 - rubyforge
8081 - objectweb
8082 - savannah
8083 - tigris
8084 - alioth

IRC data:
8085 - 8134: Apache ServiceMix
8135 - 8185: Apache Camel
8186 - 8236: Apache ActiveMQ
8237 - 8287: Apache CXF
8288 - 8338: Apache-Aries
8339 - 8389: Apache Kalumet
8390 - 8440: Apache Karaf

Data is available either in the flat files or by direct database access. Happy digging!

December 2013 data released

December data has been released. We have a few old standbys (fc, rf, ow, sv, al) and some hot fresh data as well.

What is new, you ask? Well, we have some IRC chat log data for the Apache project Camel [1]. A nice new social data set, all parsed and organized into relational database format for you to query.

Get direct database access
Or, download the files either as delimited flat files or as .sql files ("marts")

[1] Why Apache Camel? Well, that project was one of the only Apache projects where we were able to get logs for both email in mbox format and IRC chat logs. More projects forthcoming...(we're working on that now)

Objectweb Project Licenses, July 2012

Objectweb allows each project to state what license it uses. Here is a chart showing these licenses for all the projects on Objectweb, as of July 2012.

Here is the SQL code to generate the data set:

SELECT description, count( * )
FROM `ow_project_licenses`
WHERE datasource_id =318
GROUP BY 1
ORDER BY 2 DESC;

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

Syndicate content