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

[Anthony Minessale]

Like I mentioned... There is enough typing here to have fixed several wiki
pages.  So everyone should work on that or discuss something that actually
matters with the same conviction and we would make even more progress....



On Mon, Nov 5, 2012 at 10:52 AM, Antonio Teixeira
<eagle.antonio at gmail.com>wrote:

> >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
>>
>
>
> _________________________________________________________________________
> 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
>
>


-- 
Anthony Minessale II

FreeSWITCH http://www.freeswitch.org/
ClueCon http://www.cluecon.com/
Twitter: http://twitter.com/FreeSWITCH_wire

AIM: anthm
MSN:anthony_minessale at hotmail.com
GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888 at conference.freeswitch.org
googletalk:conf+888 at conference.freeswitch.org
pstn:+19193869900
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20121105/216e18f2/attachment.html