Hacker News new | past | comments | ask | show | jobs | submit login

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




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.


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...


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


Check out Navicat and you will never touch phpMyAdmin again.




Join us for AI Startup School this June 16-17 in San Francisco!

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: