[Asterisk-Users] OT: Best DB

[Giudice, Salvatore]

I vote for MySQL. PostgreSQL is fine, but MySQL handles much better
under extreme load. MySQL is also usually touted as being generally
faster for the average application. However on the flip side, PostgreSQL
supports more features than MySQL, such as subqueries, more
functionality in stored procedures, cursors, and views. In terms of
support, you can get support from MySQL directly, while PostgreSQL means
you have to turn to mailing lists. It's really your preference depending
on the size of your organization and how skilled your staff is in
supporting open source in house. Lastly, be aware that MySQL is
distributed under the GNU license with a commercial rider for derivative
works and PostgreSQl is a BSD license.

Also if you are looking at SER as part of your infrastructure, I would
recommend you stick with MySQL.

Cheers... SG

-----Original Message-----
From: Apollon Koutlides [mailto:apollon at planewalk.net] 
Sent: Thursday, March 10, 2005 2:41 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] OT: Best DB

Richard Cook wrote:

>We use PostgreSQL in house.  It performs wonderfully and cross-platform
>drivers (ODBC, .NET) are way further along than MySQL.  We switched
from
>MySQL a couple of months ago and have never been happier.
>
We use Postgres exclusively too (12 databses, several of them with 
several millions of records, both OLAP and OLTP roles). We switched from

informix 4 years ago and we also subscribe to the "never been happier" 
point of view.