The issue is not that simple , i consider PostgreSQL more "enterprise" is just my point of view.<br>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.<br>
<br>You can find many pages like this one <a href="http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL">http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL</a> , 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 :).<br>
<br>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).<br>
<br>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.<br><br>P.S one point positive for mysql OPENSIPS tend to use mysql way more :)<br>
<br>There is also a more "oracle" version of PostgreSQL ,<a href="http://www.enterprisedb.com/">http://www.enterprisedb.com/</a><br><br>Regards<br>Antonio<br><br><div class="gmail_extra"><br><br><div class="gmail_quote">
2012/11/5 Itamar Reis Peixoto <span dir="ltr"><<a href="mailto:itamar@ispbrasil.com.br" target="_blank">itamar@ispbrasil.com.br</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br><div class="gmail_extra"><br><br><div class="gmail_quote"><div class="im">On Mon, Nov 5, 2012 at 4:28 AM, Vbvbrj <span dir="ltr"><<a href="mailto:vbvbrj@gmail.com" target="_blank">vbvbrj@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
I was wondering why developers prefers PostgreSQL other the MySQL?<br>
Despite the "thread" issue are the PostgreSQL more preferable in<br>
everyday working? I want to integrate a DB for FS, web, and other<br>
projects. I already use MySQL, but more and more I see that PostgreSQL<br>
is more preferable.<br>
<br>
I've seen PostgreSQL is used by ArcGIS Server. I didn't like the DB<br>
Management interface. In MySQL it is more intuitive.<br>
<br>
Reading the internet I didn't find a comprehensive conclusion on this<br>
PostgreSQL vs MySQL. Also, does PostgreSQL work in fault-tolerance,<br>
replication?<br>
<br>
Thanks.<br>
<br>
--<br>
Mimiko desu.<br>
<br>
<br></blockquote></div><div><br>postgresql is the true free and opensource datase <br><br>mysql is owned by oracle, his future is not clear.<span class="HOEnZb"><font color="#888888"><br></font></span></div></div><span class="HOEnZb"><font color="#888888"><br clear="all">
<br>-- <br>------------<br><br>Itamar Reis Peixoto<br>
<a href="http://www.quebarato.com.br/perfil/itamarjp" target="_blank">http://www.quebarato.com.br/perfil/itamarjp</a><br><br><br>
</font></span></div>
<br>_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div><br></div>