[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 ...).
No one can ever say that a database is more secure , more stable and X , Y
, Z technology is advancing far faster than we can support/understand it.

Postgresql as by far outperformed mysql , from my work experience i have
saw raid car failure with the db holding up , for me i will always prefer a
DB  that has one unique engine geared towards stability , etc mysql with
its internal engines appears to be a hammer that will also work as a brush.

So for me a DB that i haven't touched for always 3 years , inserting close
to 1M rows per day ( cdr's) with a plain and simple vaccumm ( reindex ).





2012/11/5 Antonio Teixeira <eagle.antonio at gmail.com>

> 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/9c8350f2/attachment.html