[Asterisk-Users] OT: Best DB

[Giudice, Salvatore]

Use whichever you want. Go get your own benchmarks. I'm sure you will
find benchmarks all over the web based on different conditions. The fact
remains that enterprises are deploying MySQL 4:1 over postergreSQL. I
believe the driving factors for this are the ability to commercially
license Mysql for product integration over PostgreSQL's BSD license, and
the availability of support from MySQL directly. With regard to Redhat,
Fujitsu, etc - MySQL database support is not their main line of
business. If you believe different, then let's hear it. 

As for your 'artist license with your data' comment, put it into some
context. I would blame a programmer for trying to insert a string of 255
characters into a field only 100 character wide. Maybe you could blame
the dba for not building a schema to support the application.
Regardless, I would not call the database deficient because it truncates
your data to 100 characters and doesn't warn you with an error. Get
real. It is not as if this behavior is unexpected or some sort of a
surprise. 

Run whichever DB you want. It's your choice, as always. You are
certainly free to sit in your office frothing all over yourself in your
own twisted PostgreSQL fantasy. 


-----Original Message-----
From: Andrew Kohlsmith [mailto:akohlsmith-asterisk at benshaw.com] 
Sent: Wednesday, March 16, 2005 6:44 AM
To: asterisk-users at lists.digium.com
Subject: Re: [Asterisk-Users] OT: Best DB

On March 15, 2005 06:04 pm, Giudice, Salvatore wrote:
> commercial licensing AND has a real enterprise class support structure
> behind it, or are you going to run with PostgreSQL (bow wow)
distributed
> under a BSD license with some mom and pop support shops and some
mailing

It's time to put up or shut up.

Can you please give supporting evidence that MySQL AG has no more
"oomph" in 
commercial support than companies like Command Prompt, Fujitsu, Red Hat,
or 
even PostgreSQL, Inc.?  Every single one of those organizations has 
commercial support available for PostgreSQL.  I'm genuinely curious if
you 
consider MySQL AG "more of a company" than Red Hat or Fujitsu.

Seriously.  You're frothing at the mouth and tripping over yourself
trying to 
make your point, and you're so far off base to begin with that you
couldn't 
possibly be more wrong.

As far as your benchmark points go, until you can show me properly
organized 
and open benchmarks, your point is totally invalid.  In my cursory check

(hint: try locating the open database bake-off from a couple years ago, 
phpbuilder's evaluation a few years back, http://benchw.sourceforge.net,
or 
locate anything done by independent testing groups) it appears that
under 
real-world load, Postgres trounces MySQL handily and can handle FAR more

concurrent connections than even a tuned-out MySQL server can handle.
Yes, 
Postgres needs some tuning out of the box, this has been hashed over 
repeatedly and nobody's denying it.  Yes, MySQL is fast for the simplest

queries and inserts.  And my personal favourite, Yes, MySQL will take 
artistic license with your data.  These are all facts that everyone
(MySQL AG 
included) but you seems to be able to agree upon.  The only benchmarks
you'll 
speak of are those found with mysql-bench, but those results are
generally 
held as a practical joke with zero relevance in real-world applications.

Your comment on licensing is also interesting.  I wonder, do you also
have 
problems with Apache because it too is released under a BSD license?
How 
about the BSD Unixes themselves?  How is BSD less good than GPL?
Honestly 
I'd love to know!

> Hey, it's your choice. Do you want to eat American Grade A American
beef
> or that strange meat flavored tofu? As long as it meets your needs,
> choose whatever you have the ability to handle.

Exactly my point.  This is *exactly* why I run PostgreSQL over MySQL.  

At any rate I've participated in this offtopic thread enough.  Unless
you post 
some practical examples to back up your points I will let you have the
last 
word.  The list archives will no doubt commemorate this particular 
thread.  :-)

-A.
_______________________________________________
Asterisk-Users mailing list
Asterisk-Users at lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users