To me, the MySQL query optimizer (single index in a query) was the proverbial straw that broke the camel's back.
My group is developing all new applications in PostgreSQL and we would like to migrate our legacy apps away from MySQL.
Re:Amazon RDS for PostgreSQL
by unclebucknasty on Thursday November 14, 2013 @10:58PM
(#6737650)
The single index in a query issue seems to have been addressed as of 5.0:
http://dev.mysql.com/doc/refman/5.0/en/index-merge-optimizat...
Re:Amazon RDS for PostgreSQL
by will_work4tears on Thursday November 14, 2013 @09:24PM
(#6737295)
I'm on mobile and cant quickly and easily search this but is there a good GUI for postgre similar or superior to phpmyadmin?
Dbvisualizer (http://www.dbvis.com/) works with lots of databases and is really pretty cheap. Disclaimer: no connection other being a long term customer, I use it with Oracle, MySQL and Postgresql.
Try pgAdmin at http://www.pgadmin.org/
Edit: You can also check phppgadmin at http://phppgadmin.sourceforge.net/doku.php
TeamPostgreSQL is a very good web GUI for PostgreSQL: http://www.teampostgresql.com
Re:Amazon RDS for PostgreSQL
by billmalarky on Saturday November 16, 2013 @04:24AM
(#6744254)
Check out Navicat and you will never touch phpMyAdmin again.
- More robust, fewer crashes, less corruption of data
- More features (JSON data type, partial indexes, function/expression indexes, window functions, CTEs, hstore, ranges/sequences/sets, too many to list)
- More disciplined (doesn't do things like auto-truncate input to get it to fit into a column)
- Not owned by Oracle, it's actively developed, regular major release schedule, etc.
- Better Python driver (don't know about other languages)
- Choice of languages for database functions/procedures (Python, JS, etc.)
- Better partitioning support
- Better explain output, explain analyze, buffers
- Multiple indexes allowed per table in a query