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

[Antonio Teixeira]

>From my point of view this is a not a discussing that my db is bigger than
yours ( sorry better ...).



2012/11/5 Michael Jerris <mike at jerris.com>

> 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 :)
> >
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20121105/d1988fe3/attachment-0001.html