-----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' - -- <cjcollier colliertech org> http://cjcollier.livejournal.com/tag/ +1 206 226 5809 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFD8yaabS8rWWzCfqgRAuhPAJ4xVz5h+EvQGYtrQLbGPzVyL4Ya+QCgsXb7 FIcv1W+ryK8AYLA0zdtaH6M= =Wxvr -----END PGP SIGNATURE-----
Attachment:
smime.p7s
Description: S/MIME Cryptographic Signature