9 ms·

If you're not stuck with a huge MySQL legacy installation, Postgresql 9.4's JSONB + json_path_ops index queries seem neater. Or am I missing something?

frik 11y ago
MySQL 5.6+ / MariaDB 10 with its InnoDB engine is very popular and suitable for web scale. PostgreSQL is a good open source alternative for GIS and enterprise needs (Oracle, DB2, MSSQL). Unnerving is a tiny fraction of the Postgres community that acts as trolls.
- sanderjd 11y ago
  Why exactly is "MariaDB 10 with its InnoDB engine" "suitable for web scale" while PostgreSQL is merely a good "alternative for GIS and enterprise needs"? I think you may have some interesting information to add, but your comment currently reads like aped talking points, with a dash of accusing someone asking a reasonable question of trolling.
  - frik 11y ago
    The question at the end wasn't there, when I wrote comment. The default postgresql config is rather conservative. It is more an open source Oracle with many of its (former) unique features. PL/pgSQL resembles Oracle's PL/SQL procedural language. [1] Most people simply don't understand MySQL. MySQL is unique in as it support many database engines [4], it's like a common SQL layer on top of dozens of database engines. MySQL had a bad reputation because of its old MyISAM engine [2], the former default engine (one of many). The current default database engine is InnoDB [3] which is very fast and is what Facebook and many other huge web sites use. Instead of repeating myself and others, MySQL+memcached is quite popular, check out the highscalability website [5]. [1] http://en.wikipedia.org/wiki/PostgreSQL http://en.wikipedia.org/wiki/PostgreSQL , http://stackoverflow.com/questions/12622524/postgresql-9-2-10x-slower-than-mysql-5-5 http://stackoverflow.com/questions/12622524/postgresql-9-2-1... , http://stackoverflow.com/questions/110927/would-you-recommend-postgresql-over-mysql http://stackoverflow.com/questions/110927/would-you-recommen... , etc. [2] http://en.wikipedia.org/wiki/MyISAM http://en.wikipedia.org/wiki/MyISAM [3] http://en.wikipedia.org/wiki/InnoDB http://en.wikipedia.org/wiki/InnoDB [4] http://en.wikipedia.org/wiki/Comparison_of_MySQL_database_engines http://en.wikipedia.org/wiki/Comparison_of_MySQL_database_en... [5] https://www.google.com/?gws_rd=ssl#q=site:highscalability.com+mysql https://www.google.com/?gws_rd=ssl#q=site:highscalability.co...
    - aristidb 11y ago
      The question at the end was always there.
istvan__ 11y ago
I guess Facebook hired a lot of MySQL people and that investment is bigger than the technological one. Also, you are right, Postgres is ahead of MySQL in terms of JSON support and many more.

frik 11y ago

MySQL 5.6+ / MariaDB 10 with its InnoDB engine is very popular and suitable for web scale. PostgreSQL is a good open source alternative for GIS and enterprise needs (Oracle, DB2, MSSQL). Unnerving is a tiny fraction of the Postgres community that acts as trolls.

sanderjd 11y ago
Why exactly is "MariaDB 10 with its InnoDB engine" "suitable for web scale" while PostgreSQL is merely a good "alternative for GIS and enterprise needs"? I think you may have some interesting information to add, but your comment currently reads like aped talking points, with a dash of accusing someone asking a reasonable question of trolling.
- frik 11y ago
  The question at the end wasn't there, when I wrote comment. The default postgresql config is rather conservative. It is more an open source Oracle with many of its (former) unique features. PL/pgSQL resembles Oracle's PL/SQL procedural language. [1] Most people simply don't understand MySQL. MySQL is unique in as it support many database engines [4], it's like a common SQL layer on top of dozens of database engines. MySQL had a bad reputation because of its old MyISAM engine [2], the former default engine (one of many). The current default database engine is InnoDB [3] which is very fast and is what Facebook and many other huge web sites use. Instead of repeating myself and others, MySQL+memcached is quite popular, check out the highscalability website [5]. [1] http://en.wikipedia.org/wiki/PostgreSQL http://en.wikipedia.org/wiki/PostgreSQL , http://stackoverflow.com/questions/12622524/postgresql-9-2-10x-slower-than-mysql-5-5 http://stackoverflow.com/questions/12622524/postgresql-9-2-1... , http://stackoverflow.com/questions/110927/would-you-recommend-postgresql-over-mysql http://stackoverflow.com/questions/110927/would-you-recommen... , etc. [2] http://en.wikipedia.org/wiki/MyISAM http://en.wikipedia.org/wiki/MyISAM [3] http://en.wikipedia.org/wiki/InnoDB http://en.wikipedia.org/wiki/InnoDB [4] http://en.wikipedia.org/wiki/Comparison_of_MySQL_database_engines http://en.wikipedia.org/wiki/Comparison_of_MySQL_database_en... [5] https://www.google.com/?gws_rd=ssl#q=site:highscalability.com+mysql https://www.google.com/?gws_rd=ssl#q=site:highscalability.co...
  - aristidb 11y ago
    The question at the end was always there.

istvan__ 11y ago

I guess Facebook hired a lot of MySQL people and that investment is bigger than the technological one. Also, you are right, Postgres is ahead of MySQL in terms of JSON support and many more.