| [wtp-pmc] WTP PMC call agenda for Tuesday, May 30th |
|
Call info:
Call Time: 7am PDT Agenda:
|
From: cross-project-issues-dev-bounces@xxxxxxxxxxx on behalf of Ian Skerrett [ian.skerrett@xxxxxxxxxxx] Sent: Monday, May 29, 2006 11:19 AM To: 'Cross project issues' Subject: RE: [cross-project-issues-dev] Callisto stats Attachments: callisto stats.xls; ATT3020972.txt All right just to please Denis, here is what I have come-up with for the stats. Attached is the spreadsheet with the details. > Number of committers = 262 *** I got this from DASH. > Number of development team locations (if you are so inclined a list of > locations would be useful) **** I could not derive this, so it would be useful if people could suggest how I could or send me an estimate for their project. > Number of companies contributing resources to the project = 15 **** The companies were derived from DASH and include IBM,Actuate,Intel,Nokia,QNX,RedHat, TI, Wind River, Sybase, Borland, HP, Scapa, BEA, Oracle, SAS. The one thing this does not include are committers categorized as individuals. If anyone has a suggestion to include individuals that are associated with organizations, it would be appreciated. > Number of bugzilla entries addressed during release **** Thanks to Nick for this great SQL statement. I used #4 on his sample queries http://www.eclipse.org/emf/plan/bugzillas-ies.php > Number of LOC for the project > Number of plug-ins > Number of source files **** I was not able to find out how to collect the numbers for the above three stats. If anyone has a suggestion, please let me know. -----Original Message----- From: cross-project-issues-dev-bounces@xxxxxxxxxxx [mailto:cross-project-issues-dev-bounces@xxxxxxxxxxx] On Behalf Of Eclipse WebMaster (Denis Roy) Sent: May 26, 2006 4:55 PM To: Cross project issues Subject: Re: [cross-project-issues-dev] Callisto stats The thought of Ian issuing SQL queries against the Bugzilla database is disturbing on so many levels, none of which have anything to do with the fact he works in the office next to me. First he impressed me months ago by proving to be a good PHP hacker. Then he'll surprise me by demonstrating that he can craft SQL statements like the best of 'em. What's will be next... Ian submits a patch to improve a piece of Eclipse code?? I wouldn't put it past him. You show 'em, Ian. I'm rooting for you. Marketing folks aren't all technically-challenged. D. Mike Wilson wrote: > > I would be happy if you collected as much data as possible yourself. I > promise to either not complain or compute it myself, if you get it > wrong. ;-) > > McQ. > > > > *"Ian Skerrett" <ian.skerrett@xxxxxxxxxxx>* Sent by: > cross-project-issues-dev-bounces@xxxxxxxxxxx > > 05/26/06 04:10 PM > Please respond to > Cross project issues > > > > To > "'Cross project issues'" <cross-project-issues-dev@xxxxxxxxxxx> > cc > > Subject > RE: [cross-project-issues-dev] Callisto stats > > > > > > > > > Oh Doug, you have little faith. J I can definitely try to generate my > own numbers for some of the stats, however I thought it would be 'safer' > to get them directly from the source. This way there would be no > interpretation errors. > > Ian > > > > Ian Skerrett > Director of Marketing > Eclipse Foundation, Inc. > Tel: 613-224-9461 ext. 227 > Fax: 613-224-5172 > _ian.skerrett@eclipse.org_ <mailto:ian.skerrett@xxxxxxxxxxx> > _http://www.eclipse.org_ <http://www.eclipse.org/> > Blog: _http://ianskerrett.blogspot.com/_ > > <http://www.eclipse.org/callisto/images/callistosmall.gif> > > > > ---------------------------------------------------------------------- > -- > > *From:* cross-project-issues-dev-bounces@xxxxxxxxxxx > [mailto:cross-project-issues-dev-bounces@xxxxxxxxxxx] *On Behalf Of > *Doug Schaefer* > Sent:* May 26, 2006 4:03 PM* > To:* Cross project issues* > Subject:* RE: [cross-project-issues-dev] Callisto stats > > A-ha, but that will give you the real data, not the marketing data J. > One thing I've learned over the last little while is that marketing > resides on a different plane of the universe than what we're used to. > I'm very careful what numbers I give to marketing now because they can > be used for good but also evil. Not that Ian would do anything evil ;). > > Doug Schaefer, QNX Software Systems > Eclipse CDT Project Lead, Tools PMC member > _http://cdtdoug.blogspot.com_ <http://cdtdoug.blogspot.com/> > > > ---------------------------------------------------------------------- > -- > > *From:* cross-project-issues-dev-bounces@xxxxxxxxxxx > [mailto:cross-project-issues-dev-bounces@xxxxxxxxxxx] *On Behalf Of > *Mike Wilson* > Sent:* Friday, May 26, 2006 3:24 PM* > To:* Cross project issues* > Cc:* 'Cross project issues'; > cross-project-issues-dev-bounces@xxxxxxxxxxx* > Subject:* Re: [cross-project-issues-dev] Callisto stats > > > Ian, can't you compute some of these things yourself with automated > querries? For example, the > http://www.eclipse.org/emf/plan/query.php > page has this gem: > > #--------#--------#--------#-------- > # count of bugs entered between two dates # for a given product > > SELECT DISTINCT > count(BUG.bug_id) AS CNT > FROM > bugs as BUG, > products as PROD > WHERE > PROD.id = BUG.product_id AND > (PROD.name = 'EMF' OR PROD.name = 'XSD') AND BUG.creation_ts >= > '2004-07-01' > AND BUG.creation_ts <= '2005-07-07' > > Which looks like it's close to what you need to get the bugzilla info. > Similarly, the list of committers for the Eclipse Project, for example > is already found here: > http://www.eclipse.org/eclipse/commit.html > > McQ. > > *"Ian Skerrett" <ian.skerrett@xxxxxxxxxxx>* Sent by: > cross-project-issues-dev-bounces@xxxxxxxxxxx > > 05/26/06 02:48 PM > > > Please respond to > Cross project issues > > > > To > "'Cross project issues'" <cross-project-issues-dev@xxxxxxxxxxx> > cc > > Subject > [cross-project-issues-dev] Callisto stats > > > > > > > > > > > > > I am getting prepared for the press outreach around Callisto. An > important part of the message is the sheer size of the Callisto effort. > Therefore, I would like to collect some cross project stats that we can > use. It would be appreciated if each project leader could let me know > an estimate for each of the following stats. I will then collate and > make it publicly available. Let me stress, the numbers can just be > estimates, they don't need to be exact but please don't inflate them > either. J > > Callisto Stats per project > > Number of committers > Number of development team locations (if you are so inclined a list of > locations would be useful) > Number of companies contributing resources to the project Number of > bugzilla entries addressed during release Number of LOC for the > project Number of plug-ins Number of source files > > > Btw, if anyone else has a stat you think we should collect, please > feel free to add it. > > > Thanks again for the help. > > Ian > > > > > > Ian Skerrett > Director of Marketing > Eclipse Foundation, Inc. > Tel: 613-224-9461 ext. 227 > Fax: 613-224-5172 _ > __ian.skerrett@eclipse.org_ <mailto:ian.skerrett@xxxxxxxxxxx> _ > __http://www.eclipse.org_ <http://www.eclipse.org/> > Blog: _http://ianskerrett.blogspot.com/_ > _ > _ <http://www.eclipse.org/callisto/images/callistosmall.gif> > > > _______________________________________________ > cross-project-issues-dev mailing list > cross-project-issues-dev@xxxxxxxxxxx > https://dev.eclipse.org/mailman/listinfo/cross-project-issues-dev___________ ____________________________________ > cross-project-issues-dev mailing list > cross-project-issues-dev@xxxxxxxxxxx > https://dev.eclipse.org/mailman/listinfo/cross-project-issues-dev > > > ---------------------------------------------------------------------- > -- > > _______________________________________________ > cross-project-issues-dev mailing list > cross-project-issues-dev@xxxxxxxxxxx > https://dev.eclipse.org/mailman/listinfo/cross-project-issues-dev -- Eclipse WebMaster - webmaster@xxxxxxxxxxx Questions? Consult the WebMaster FAQ at http://wiki.eclipse.org/index.php/Webmaster_FAQ View my status at http://wiki.eclipse.org/index.php/WebMaster _______________________________________________ cross-project-issues-dev mailing list cross-project-issues-dev@xxxxxxxxxxx https://dev.eclipse.org/mailman/listinfo/cross-project-issues-dev
