3 ms·

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

by frik 12y 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 12y 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 12y 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 12y ago
    The question at the end was always there.

by frik 12y ago

sanderjd 12y 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 12y 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 12y ago
  The question at the end was always there.