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

[Evgeniy Movlyan]

I'm using phppgamin 
(http://phppgadmin.sourceforge.net/doku.php?id=start). Description from 
official site:

-Administer multiple servers
-Support for PostgreSQL 7.4.x, 8.0.x, 8.1.x, 8.2.x, 8.3.x, 8.4.x, 9.0.x
-Manage all aspects of:
-Users & groups
-Databases
-Schemas
-Tables, indexes, constraints, triggers, rules & privileges
-Views, sequences & functions
-Advanced objects
-Reports
-Easy data manipulation:
-Browse tables, views & reports
-Execute arbitrary SQL
-Select, insert, update and delete
-Dump table data in a variety of formats: SQL, COPY, XML, XHTML, CSV, 
-Tabbed, pg_dump
-Import SQL scripts, COPY data, XML, CSV and Tabbed
-Supports the Slony master-slave replication engine
-Excellent language support:
   Available in 27 languages
-No encoding conflicts. Edit Russian data using a Japanese interface!
-Easy to install and configure

05.11.2012 11:14, Antonio Teixeira пишет:
> The issue is not that simple , i consider PostgreSQL more "enterprise" is
> just my point of view.
> 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.
>
> You can find many pages like this one
> http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL , anyway you can always test
> but from my experience , running FS clusters for three years PostgreSQL
> never let me down even when the RAID card failed , the internal triggers
> "locked down" the database , no rows were lost , the transaction engine
> rolled back current transactions and it saved my day :).
>
> The lesson is , test first deploy later , PostegreSQL is for me , more
> feature reach and more stable but it requires more skills , mysql is more
> easy ofc less features and less stable ( this isn't true for all the cases).
>
> Its up to you use something that you feel comfortable so when problems rise
> you can actually solve problems this means you understand the database and
> how it works.
>
> P.S one point positive for mysql OPENSIPS tend to use mysql way more :)
>
> There is also a more "oracle" version of PostgreSQL ,
> http://www.enterprisedb.com/
>
> Regards
> Antonio
>
>
>
> 2012/11/5 Itamar Reis Peixoto<itamar at ispbrasil.com.br>
>
>>
>>
>>
>> On Mon, Nov 5, 2012 at 4:28 AM, Vbvbrj<vbvbrj at gmail.com>  wrote:
>>
>>> I was wondering why developers prefers PostgreSQL other the MySQL?
>>> Despite the "thread" issue are the PostgreSQL more preferable in
>>> everyday working? I want to integrate a DB for FS, web, and other
>>> projects. I already use MySQL, but more and more I see that PostgreSQL
>>> is more preferable.
>>>
>>> I've seen PostgreSQL is used by ArcGIS Server. I didn't like the DB
>>> Management interface. In MySQL it is more intuitive.
>>>
>>> Reading the internet I didn't find a comprehensive conclusion on this
>>> PostgreSQL vs MySQL. Also, does PostgreSQL work in fault-tolerance,
>>> replication?
>>>
>>> Thanks.
>>>
>>> --
>>> Mimiko desu.
>>>
>>>
>>>
>> postgresql is the true free and opensource datase
>>
>> mysql is owned by oracle, his future is not clear.
>>
>>
>> --
>> ------------
>>
>> Itamar Reis Peixoto
>> http://www.quebarato.com.br/perfil/itamarjp
>>
>>
>>
>> _________________________________________________________________________
>> 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

-- 
Evgeniy Movlyan,
BestNet Ltd.