News for hackers. Stuff that matters.
Re:Amazon RDS for PostgreSQL by gdulli on Thursday November 14, 2013 @12:51PM (#6733892)
edited to add: - timestamp with time zone

- 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

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.