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@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
_________________________________________________________________________ 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
-- Evgeniy Movlyan, BestNet Ltd.