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
On Mon, Nov 5, 2012 at 4:28 AM, Vbvbrj <vbvbrj@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@freeswitch.org
http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com
Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com
FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org