[Freeswitch-users] [OffTopic] Why PostgreSQL better then MySQL?

[Michael Jerris]

Freeswitch creates all the tables and indexes for you.  There is no need for a GUI admin as there is not really anything to admin to set up freeswitch.  The only place this might not be true is if you are trying to setup replication, where mysql still has the edge in functionality.  I clearly am biased away from YourSQL, but in the end, I see no good reason to add it to FreeSWITCH. If someone feels strongly the other way, we would entertain patches to change this, under the guidelines set out earlier by Tony (and a few clarifications/additions).

1) We would need proof of some advantage over ODBC.  People often state that ODBC is slower, but I have yet to see evidence this is actually true to an extent that warrants the additional trouble.
2) A modular interface would need to be added if we add any more specific db interfaces.
3) Proper configure (and possibly runtime) check will need to be added to ensure we are using proper mysql libraries checking for transaction handling and thread safety

Postgres was added to the core in order to address specific limitations in the current interface with postgres ODBC related to how it makes blocking calls to the database, not for performance reasons, and was done so by our team due to our own needs.  If someone feels strongly this needs to be added, has the skillset required to make these patches, and is willing to put in the time to do so, please talk to me off list and I am happy to discuss requirements in more detail.

Mike

On Nov 5, 2012, at 7:35 AM, Bzzz <lazyvirus at gmx.com> wrote:

> On Mon, 5 Nov 2012 09:14:59 +0000
> Antonio Teixeira <eagle.antonio at gmail.com> wrote:
> 
>> The issue is not that simple , i consider PostgreSQL more "enterprise" is
>> just my point of view.
> 
> Hmm, I see the question from another point of view: how can people use
> mysql for _any_ enterprise work.
> 
>> One thing i love about postgres is the Transactions  + an extremely good
>> engine , PostgreSQL is not made as easy as mysql you don't get fancy
>> "phpmyadmin" but it does the work extremely well even in some corner cases.
> 
> That isn't true: as a web application you have phppgadmin
> (http://phppgadmin.sourceforge.net/doku.php?id=start), as a
> standalone program you have pgadmin3 (http://www.pgadmin.org/).
> 
>> 
>> There is also a more "oracle" version of PostgreSQL ,
>> http://www.enterprisedb.com/
> 
> In fact, Pg is seen as the open-source oracle; enterprisedb brings the
> advantage of long term bug fixing & support for its chosen Pg versions :)
>