News for hackers. Stuff that matters.
Re:Amazon RDS for PostgreSQL by elob36 on Thursday November 14, 2013 @02:53PM (#6735041)
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?
Re:Amazon RDS for PostgreSQL by epo on Friday November 15, 2013 @05:18AM (#6738648)
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.
Re:Amazon RDS for PostgreSQL by aftabh on Thursday November 14, 2013 @09:45PM (#6737373)
Try pgAdmin at http://www.pgadmin.org/

Edit: You can also check phppgadmin at http://phppgadmin.sourceforge.net/doku.php

Re:Amazon RDS for PostgreSQL by johnyzee on Friday November 15, 2013 @08:50AM (#6739358)
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.