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@ispbrasil.com.br>

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

On Mon, Nov 5, 2012 at 12:46 PM, Vallimamod ABDULLAH < vallimamod.abdullah@imtelecom.fr> wrote:

You may be interested by adminer (http://www.adminer.org): it's a very light, one php file "phpmyadmin" for mysql, postgres, etc.

+1 to adminer. It's integrated into FusionPBX and via PHP drivers, allows editing of mysql, postgres, sqlite, ms sql and oracle. It seems to do nearly everything phpmyadmin does and is a clean interface and quite fast. -Avi

Does Postgres support circular multi-master replication like mysql does? Are there some ways to run geographically distributed DB cluster? On Monday 05 November 2012 12:42:34 Antonio Teixeira wrote:

My second No No Besides Mysql ... PHP :) , but seems interesting !. Thanks

2012/11/5 Vallimamod ABDULLAH <vallimamod.abdullah@imtelecom.fr>

...

Hi,

On Nov 5, 2012, at 10:14 AM, Antonio Teixeira <eagle.antonio@gmail.com>

wrote:

...

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 may be interested by adminer (http://www.adminer.org): it's a very light, one php file "phpmyadmin" for mysql, postgres, etc.

Cheers, Vallimamod .

_________________________________________________________________________ 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

On Mon, 05 Nov 2012 08:32:54 -0500 Sergey Okhapkin <sos@sokhapkin.dyndns.org> wrote:

Does Postgres support circular multi-master replication like mysql does?

You have several solutions, depending whether you want sync (a bit of weakness her) or async: PGCluster, Bucardo, Postgres-R, RubyRep... (http://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pool...) EnterpriseDB is also presenting a solution (xDB), but it is in a beta state though. AFAIK, the most achieved sync project is Postgres-XC (See http://postgres-xc.sourceforge.net/ & http://en.wikipedia.org/wiki/Multi-master_replication#PostgreSQL) and Rubirep for async, (http://www.rubyrep.org/) - open-source speaking of course, 'cos there are other (proprietary) solutions.

Are there some ways to run geographically distributed DB cluster?

As far as you can partition and sync replicate, you can do that with Pg. -- If it takes a bloodbath, lets get it over with. No more appeasement. -- Ronald Reagan

Plus, when you say it outloud, PostgreSQL sounds way better than MySQL (which sounds a bit childish). On Mon, 2012-11-05 at 09:01 -0600, Anthony Minessale wrote:

Its simpler than that.

I have used both db in my time as a developer and I have been mad at both for one reason or another. It all boils down to Mysql is not as stable and has several thread safety and memory leak issues when its used in a multi-threaded app like FreeSWITCH. In fact that preference is irrelevant because technically the default database in FS is sqlite because the design goal of the project is for the software to run anywhere in a minimal capacity and be able to grow and scale with the user's needs. So anyone can use any database they want. However, when we get a bug report that shows Mysql crashing, that is not something we can do anything about. Since we do have better luck with postgres, we allowed the inclusion of native api but that was a 3rd party contribution.

So bottom line is we don't care what other people do, we just do what we like doing and share it.

On Mon, Nov 5, 2012 at 6:42 AM, Antonio Teixeira <eagle.antonio@gmail.com> wrote: My second No No Besides Mysql ... PHP :) , but seems interesting !. Thanks

2012/11/5 Vallimamod ABDULLAH <vallimamod.abdullah@imtelecom.fr> Hi,

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

> 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 may be interested by adminer (http://www.adminer.org): it's a very light, one php file "phpmyadmin" for mysql, postgres, etc.

Cheers, Vallimamod .

_________________________________________________________________________ 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

_________________________________________________________________________ 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

-- Anthony Minessale II

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

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

FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900

_________________________________________________________________________ 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

On Mon, 5 Nov 2012 09:14:59 +0000 Antonio Teixeira <eagle.antonio@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 :) Jiff -- <cell> apt sex <apt> sex is probably updatedb; locate; talk; date; cd; unzip; strip; look; touch; finger; head; mount; fsck; more; yes; yes; umount; make clean; sleep <RST2003> is there a female equivalent of that command line? <lazarus> RST2003: sleep :) -- in #debian

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@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@gmx.com> wrote:

...

On Mon, 5 Nov 2012 09:14:59 +0000 Antonio Teixeira <eagle.antonio@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@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

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@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@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@gmx.com> wrote:

...

On Mon, 5 Nov 2012 09:14:59 +0000 Antonio Teixeira <eagle.antonio@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@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

_________________________________________________________________________ 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

-- Anthony Minessale II FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire AIM: anthm MSN:anthony_minessale@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900

On Mon, 05 Nov 2012 15:43:39 +0200 Vbvbrj <vbvbrj@gmail.com> wrote:

I don't use phpmyadmin, I use the MySQL GUI Tools distributed by the developers. PostreSQL also has its GUI, but its not intuitive. Ok. This is a like only. Eventually anyone can get used with administering the DB with some tools.

I don't understand this obsession with GUI tools for working on databases. If we are talking about enterprise level databases I assume we mean enterprise level deployment as well. That means sitting down and designing a database from requirements. The database should be created in a text file that can be dropped into a versioning system. Don't say that binary project files can be saved because you can't diff binary files in any useful way. And don't get me started on the dog's breakfast that is PHP. I won't even install it on my central database server.

I am about the work progress, replication, fault-tolerance building, transactions is, foreign keys. Innodb in MySQL also is transactional and has foreign key with updates and deletes handling.

Of course PostgreSQL has all that. Who do you think MySQL is trying to catch up to.

Does PostgreSQL has some stability improvements, db speed access, sequrity issues better then MySQL?

Absolutely. I wouldn't trust my critical data to any other open source database and very few commercial ones. Run a busy database application in both PostgreSQL and MySQL and pull the plug on the server once in a while. Want to take bets on which one corrupts your data and requires a restore from backup? -- D'Arcy J.M. Cain System Administrator, Vex.Net http://www.Vex.Net/ IM:darcy@Vex.Net