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:[EMAIL PROTECTED] 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. _______________________________________________ Asterisk-Users mailing list [email protected] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
