Monday, May 2, 2011



Advantages of MySQL
  1. Large community of developers (PHP).
  2. Excellent documentation. In several formats (HTML, HTML Help ...), online comments.
  3. Numerous articles and tutorials for info about MySQL, and PHP.
  4. Replication and backup databases. Managing a single master-slave replication in the case of a backup for example.
  5. Management of certain integrity constraints: Foreign Key for InnoDB tables, for example.
  6. Local database: Possibility of taking MySQL software and distribute it without a server.A bit like I think Borland BDE or SQLite (Distributed with PHP5).
  7. Transactions Management  (BEGIN, COMMIT / ROLLBACK).
  8. phpBB: The forum used by Developpez.com, like hundreds of other web sites using MySQL (I will like to know the size of the database!).
  9. MySQL is supported by the majority of free hosts, which is not the case of PostgreSQL.
  10. Great tools to administer your databases: PhpMyAdmin for the web by example.
  11. Simple to install and configure, deploy and maintain Windows.
  12. Good support for professionals from the only experience I have had concerning the boarding of a MySQL database software in particular. Team very responsive.
  13. The youngest is not necessarily an advantage, but more a welcome feature, LAST_INSERT_ID () to retrieve the ID, the value of the primary key AUTO_INCREMENT, the last entry inserted into a table by an INSERT. Should be used with PostgreSQL sequences.

Disadvantages:

  1. No longer used by SourceForge because MySQL did not support the load increases, they opted for PostgreSQL. MySQL is perhaps easy to install and deploy, but it does not perhaps the degree of scability PostgreSQL.
  2. Not support the standard SQL2 (92) to 100%. Actually I have never encountered problems in the writing of my queries, just take a few hours to read the first chapters of the manual and see that MySQL does not away from it all that much, except for the purists .
PostgreSQL Advantages:

  1. Legacy table: PostgreSQL is not a simple RDBMS. This is the main argument that I can progress as the only feature that I miss in MySQL.
  2. Scability: See the problem with MySQL SourceForge.
  3. All these advanced features, some developers can not live without: Sub queries, triggers and stored procedures mainly.

Disadvantages:
  1. Not available natively for Windows, it uses an emulation layer (Cygwin). Upcoming version 8 will be available natively for Windows.
  2. Can not manage a local, but I could be wrong. An expert opinion? Then we can say that it was not designed for, but opt ​​for MySQL and you get the best of two worlds, local and online.
  3. See some benefit from MySQL: Less supported by the community of PHP developers (Still need to know which category you belong), there are more hosts PHP / MySQL but the big names often suggest PostgreSQL (Can be more expensive to deploy than MySQL because most resource hungry ...).

12 comments:

  1. Awesome post man! Keep up this great blogging work!

    ReplyDelete
  2. At my jobs I've never been able to use Postgre - it's always oracle this, DB2 that and, quite often, MSSQL server. Good to know there's other alternatives.

    ReplyDelete
  3. I hate having to use emulation layers. It seems so primitive.

    ReplyDelete
  4. Very true, the scalability is a giant plus

    ReplyDelete
  5. Very useful weigh up - Thank you.

    ReplyDelete
  6. This is actually really relevant to a course i'm taking at college, Cheers man!

    ReplyDelete
  7. I never tried postgre SQL, MySQL just seemed so ubiquitous that I always opted for it. But this info made me think about its disadvantages

    ReplyDelete
  8. I was using MySQL at my last job and I must say it did what we needed. Sure there might be better solutions for heavy duty. I am no DB expert, but doesn't even facebook use PHP and MySQL?

    ReplyDelete