Growth of use of "Free" and "Open" in Project Names (2014 data)
Description:
This chart shows the number of new projects in each repository that use the words "Free" and "Open" in project names through 2014.
Visualization:
SQL Script:
Freshmeat:
SELECT YEAR( date_added ) , COUNT( DISTINCT project_id ) AS Count
FROM fm_projects
WHERE projectname_full LIKE "%free%"
AND datasource_id = [current]
GROUP BY YEAR( date_added )
ORDER BY YEAR( date_added );
SELECT YEAR( date_added ) , COUNT( DISTINCT project_id ) AS Count
FROM fm_projects
WHERE projectname_full LIKE "%open%"
AND datasource_id = [current]
GROUP BY YEAR( date_added )
ORDER BY YEAR( date_added );
Rubyforge:
SELECT YEAR( date_registered ) , COUNT( DISTINCT proj_unixname ) AS Count
FROM rf_projects
WHERE proj_unixname LIKE "%free%"
AND datasource_id = [current]
GROUP BY YEAR( date_registered )
ORDER BY YEAR( date_registered );
SELECT YEAR( date_registered ) , COUNT( DISTINCT proj_unixname ) AS Count
FROM rf_projects
WHERE proj_unixname LIKE "%open%"
AND datasource_id = [current]
GROUP BY YEAR( date_registered )
ORDER BY YEAR( date_registered );
Savannah:
SELECT YEAR( registration_date ) , COUNT( DISTINCT project_name ) AS Count
FROM sv_projects
WHERE project_name LIKE "%free%"
AND datasource_id = [current]
GROUP BY YEAR( registration_date )
ORDER BY YEAR( registration_date );
SELECT YEAR( registration_date ) , COUNT( DISTINCT project_name ) AS Count
FROM sv_projects
WHERE project_name LIKE "%open%"
AND datasource_id = [current]
GROUP BY YEAR( registration_date )
ORDER BY YEAR( registration_date );
Attachment | Size |
---|---|
growthOfOpenFreeJune2014.png | 29.65 KB |
- Log in to post comments