5 ms·
edited to add: - timestamp with time zone - More robust, fewer crashes, less corruption of data - More features (JSON data type, partial indexes, function/exp
by gdulli 13y ago
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
- elob36 13y agoTo 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.
- will_work4tears 13y agoI'm on mobile and cant quickly and easily search this but is there a good GUI for postgre similar or superior to phpmyadmin?
- aftabh 13y agoTry pgAdmin at http://www.pgadmin.org/ http://www.pgadmin.org/ Edit: You can also check phppgadmin at http://phppgadmin.sourceforge.net/doku.php http://phppgadmin.sourceforge.net/doku.php
- epo 13y agoDbvisualizer (http://www.dbvis.com/ 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.
- johnyzee 13y agoTeamPostgreSQL is a very good web GUI for PostgreSQL: http://www.teampostgresql.com http://www.teampostgresql.com
- billmalarky 13y agoCheck out Navicat and you will never touch phpMyAdmin again.
- unclebucknasty 13y agoThe 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-optimization.html http://dev.mysql.com/doc/refman/5.0/en/index-merge-optimizat...