Skip to main content
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
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

Back to the top