As of June 2009, how many projects are listed in each repository?
Description
This chart shows the number of projects that FLOSSmole most recently collected from each repository.
Visualization
SQL Script
SELECT count(DISTINCT proj_unixname) FROM projects
WHERE datasource_id= <current>;
SELECT count(DISTINCT project_id) FROM fm_projects
WHERE datasource_id= <current>;
SELECT count(DISTINCT proj_unixname) FROM rf_projects
WHERE datasource_id= <current>;
SELECT count(DISTINCT proj_unixname) FROM ow_projects
WHERE datasource_id= <current>;
SELECT count(DISTINCT proj_num) FROM fsf_projects
WHERE datasource_id= <current>;
Attachment | Size |
---|---|
06-09-ProjectCount.gif | 14.18 KB |
- Log in to post comments