Thursday, January 25, 2007
database schema
You can browse the sql version of the FLOSSmole database schema in CVS on Sourceforge, OR you can check the schemaspy-generated view of the schema. The CVS version is updated less often than the schemaspy version. I'll try to run a schemaspy view every few months and overwrite the old one. The query tool also lists all the tables, so if you see a table in there and you want to know what it does, do "describe <tablename>" or just check out the schema!
Monday, January 15, 2007
FLOSSmole now includes FSF data
FLOSSmole now includes data from the FSF (Free Software Foundation) directory (original directory link).
The flat files including the data can be found on our FSF sourceforge file release page.
Some facts of note:
--the FSF directory contains 5226 projects
--the FSF directory allows projects with case-sensitive but otherwise identical names, i.e.
--our datasource_id for this initial run is "45" if anyone is checking the query tool
--FSF is forge #6 in our FLOSSmole system
--our FSF tables are all preceded with the "fsf" extension (i.e. "fsf_projects").
The flat files including the data can be found on our FSF sourceforge file release page.
Some facts of note:
--the FSF directory contains 5226 projects
--the FSF directory allows projects with case-sensitive but otherwise identical names, i.e.
ANT and ant are considered different projects--our datasource_id for this initial run is "45" if anyone is checking the query tool
--FSF is forge #6 in our FLOSSmole system
--our FSF tables are all preceded with the "fsf" extension (i.e. "fsf_projects").
Friday, January 05, 2007
January FM, RF, OW files released
We've released the January 2007 files for Freshmeat, Objectweb, and Rubyforge.
In February, look forward to the next Sourceforge release, as well as a new feature: "All Time Stats" for Sourceforge!
Get the latest files here
One more newish thing... if you're on the mailing list, this is old news... but for you data junkies, you can now play around with the content generated about our data model from schema spy. If we like this format, I'll generate these bi-monthly along with the SF data and post them on the sidebar permanently.
As always, if you feel like helping out the team with coding or documentation, send me an email and we'll chat. (mconklin at elon dot edu)
In February, look forward to the next Sourceforge release, as well as a new feature: "All Time Stats" for Sourceforge!
Get the latest files here
One more newish thing... if you're on the mailing list, this is old news... but for you data junkies, you can now play around with the content generated about our data model from schema spy. If we like this format, I'll generate these bi-monthly along with the SF data and post them on the sidebar permanently.
As always, if you feel like helping out the team with coding or documentation, send me an email and we'll chat. (mconklin at elon dot edu)
