เมื่อ พ. 2006-02-15 เวลา 05:03 -0800, C.J. Adams-Collier เขียนว่า: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Ross Golder wrote: > > เมื่อ จ. 2006-02-13 เวลา 13:48 -0500, Joe Shaw เขียนว่า: > >> Hey, > >> > >> It's hardly scientific, but you might want to prioritize based on > >> activity statistics from CIA: > >> > >> http://cia.navi.cx/stats/project/gnome > >> > > ... > >> > >> I noticed that rather big modules like, oh, say, gtk+ were > >> missing. :) > > > > I thought of another way - using our bonsai checkins database. A > > few minutes playing around and I came up with this : > > > > select substr(repositories.repository from 12) as module, > > count(checkins.repositoryid) as tot from checkins, repositories > > where checkins.repositoryid = repositories.id and checkins.ci_when > > > date_sub(curdate(), interval 1 year) group by > > checkins.repositoryid order by tot desc; > > > > This turns up the resultset you can find here: > > > > http://www.gnome.org/~rossg/migrations.csv > > > > I see 'gtk+' and 'gimp' at the top, amongst the other main > > high-profile projects :) > > > > -- Ross > > > IMHO, we should also take into account projects that have stood > inactive for a long period of time and that are now seeing a lot of > traffic. > > Don't tell anybody, but my sql-foo is not as great as Ross' >
Sorry. Basically, it means 'select the total number of commits per module from the commits made in the last year and sort in descending order'. -- Ross _______________________________________________ Gnome-infrastructure mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnome-infrastructure
