Starting Survey results - Survery Countries

Well, I have started formatting the results from the survey. This will take a little while as the survey software doesn't make it easy to download and clean it up (without paying for a subscription). As soon as the data is cleaned up I will post the entire data set and a link for everyone to download.

However, while I work on the data, I will provide some summary results. Here is a list of countries who had respondents. If a country is not listed, it had 0 responses/

Country	Percentage	# Respondents
Argentina	0.31%	1
Australia	3.44%	11
Belgium	1.25%	4
Bosnia and Herzegovina	0.31%	1
Brazil	5.63%	18
Bulgaria	1.25%	4
Canada	4.69%	15
Colombia	0.63%	2
Croatia	0.31%	1
Czech Republic	0.94%	3
Dominican Republic	0.31%	1
Ecuador	0.31%	1
Estonia	0.31%	1
Finland	0.31%	1
France	4.38%	14
Germany	2.50%	8
Greece	0.63%	2
Guatemala	0.31%	1
Hong Kong	0.31%	1
Hungary	0.31%	1
India	3.13%	10
Indonesia	0.31%	1
Israel	0.31%	1
Italy	1.88%	6
Latvia	0.63%	2
Malaysia	0.31%	1
Mali	0.31%	1
Mexico	3.75%	12
Netherlands	1.88%	6
Norway	0.31%	1
Paraguay	0.31%	1
Peru	0.63%	2
Philippines	0.63%	2
Poland	1.88%	6
Portugal	0.31%	1
Russian Federation	1.56%	5
Serbia	0.63%	2
Singapore	0.31%	1
Slovenia	0.94%	3
South Africa	0.94%	3
Spain	2.81%	9
Sweden	0.94%	3
Switzerland	1.25%	4
Thailand	0.31%	1
Turkey	1.25%	4
Ukraine	0.31%	1
United Kingdom	6.88%	22
United States	35.00%	112
Uruguay	0.31%	1
Other	1.56%	5

Check out a summary of Primary Databases and a few questions on open source software usage.

LewisC

Technorati : database, open source, osdb, survey

Last Week For Database Survey

This is the last week to participate in a database usage survey. If you haven't already done so, please take a few minutes to answer 25 questions.

LewisC

Technorati : database, mysql, survey

Over 200 Responses in Less than 2 Weeks

Less than two weeks ago, I posted my Database Survey. As of just a few minutes ago, I have had 215 responses. That's pretty awesome. I'd like to get at least twice that though.

I haven't looked deeply at it yet to see if there are any trends. I think it will be best to wait until the survey is closed. I did look at some of the responses, kind of as a quality check. Looks like MySQL is fairly well represented. I didn't see any DB2 responses (for primary database). I did see plenty of Oracle and a few Postgres.

I will leave it up for another 2 1/2 weeks (for a total of 4 weeks). If you haven't taken it yet, please do so if you get a few minutes. It only takes 5-10 minutes as there is only 25 questions.

Also, if you have a blog, post on forums (without spamming), or have any other ways to spread the word, I would appreciate it.

Thanks,

LewisC

Technorati : commercial, database, open source, survey

Please take a 25 question survey

I recently posted about the results of the EDB Open Source Survey. It doesn't look like the raw data is going to be released. I was also reading about an O'reilly survey that costs $350 to see. Not that I am opposed to them making money, but I wanted to see the results and I think there are a lot people who feel the same. I have no idea if my survey is anything like O'reilly's.

Anyway, I have created a new survey. It has about 10 demographics questions asking who you are, where you are, what kind of role you have, etc. The rest are related to databases and open source. ALL data, and I mean all of the raw results, will be made available to anyone who wants to see it. I will also do some analysis and I will make that data available to any who want to see that.

All questions on the survey are optional. Feel free to skip anything you are uncomfortable answering. On the survey I ask for an email address. That address is strictly to allow me to email you the results. When you complete the survey, you will be taken to a web page. After the survey is over, the results (as a link to a data file) will be posted on that page. If you would rather not share your email ID, leave that field blank and just bookmark the final page. You can check back occasionally and I will post when the data is available here. It's actually less work for me if you don't give me your email addess. ;-)

Also, I ask for a company name. I know some people aren't comfortable sharing that so the data will be masked before it is released. That will allow anyone analyzing the data to get an idea of how many people from the same company answered the survey but they will not know which company it is.

Privacy is important to me.

Please share this and let as many people as possible know about the survey. The more people who answer, the more valuable the results.

Click here to take the survey now. The survey was created with eSurveysPro.com, a free online survey software.

Thank you in advance.

LewisC

Technorati : database, open source, survey

OSCON 2008 Popularity Contest

I didn't get a chance to go to OSCON 2008. Bummer. But I can live vicariously through google. So, along with all of the announcements you've heard from OSCON, I know present the OSCON 2008 - Google popularity contest. This is a completely unscientific survey of google hits. I was searching blogs and news. I started with just news but the blogs hits really upped the numbers.

To run these searches, I use "oscon 2008" and the search term, for example:

"oscon 2008" mysql

In the case of open source, I also quoted "open source".

I'm using google's about number. I didn't sit and count each hit. ;-)

Category	Term	Hits
General	open source	28600
	cloud	4220
Database	database	9680
	mysql	10300
	postgres	2560
	drizzle	521
	hadoop	277
	firebird	809
	derby	1680
	ingres	3190
	luciddb	37
	couchdb	298
Vendor	sun	9390
	oracle	6480
	microsoft	15100
	apple	10500
	intel	45800
Language	ruby	5730
	php	12400
	java	43200
	perl	8280
	python	5230
	mono	842
Linux	ubuntu	10700
	fedora	5120
	debian	5040
	bsd	4870
	centos	2520
	gentoo	16900
	red hat	5860
	suse	3220

Interesting results. MySQL took the database by a good margin. I thought Ubuntu would take the Linux flavor but Gentoo got it. I also didn't expect Java to be #1 much less by such a huge margin.

LewisC

Technorati : comparison, google, open source, socon

Results of EnterpriseDB Open Source Database Survey

EnterpriseDB announced the results of the survey they did a few months ago at OSCON. Now, take the results with a grain of salt as it was done by EnterpriseDB. EnterpriseDB is based on Postgres so there is a vested interest in making Postgres sound good. Results can be skewed depending on how the survey is worded, what options are available as answers and who the respondents are.

The results summary is available for free.

Some key facts:

500 respondents. The download page says "500 corporate IT leaders". Or maybe, 500 open source developers. ;-)

Only 9% of respondents indicated that they preferred commercial solutions over open source solutions. I would guess that a majority of those responding were open source database people anyway. This is also one place where I think the wording of survey questions makes a difference. I'd like to see the survey again and compare the results to the survey itself.

The survey shows that respondents are using open source to migrate away from Oracle and SQL Server. It says that less than 1% is using open source to migrate away from DB2. Since DB2 is a major investor in EnterpriseDB, that doesn't surprise me. Again, the target users of the survey make a difference as well as the questions themselves.

Of course, Postgres was chosen more than any other open source database for transactional applications and high reliability. Again, not surprising based on who wrote the survey and what they sell.

Before I put very much value on this survey, I would want to see more than just a hand-crafted summary of the results. A spreadsheet of all the questions and the answers chosen would be, at least somewhat, valuable. Without that though, it's just marketing. I can't find anything on the site indicating the full results will be made available.

Del.icio.us : database, enterprisedb, mysql, open source, oscon, postgres, survey