PostgreSQL versus MySQL: an unbiased comparison

This question has always brought up heated debates in many forums .This article tries to compare these two db giants and help a begginer to opt among them.

 

                                                               VS    

 

  • Features

    Here PostgreSQL has the upper hand. The stable version of MySQL does not support subqueries, stored procedures, cursors or views, all of which PostgreSQL does.One of their more serious mistakes was for the MySQL developers to justify the exclusion of many of these features by claiming that they were not necessary.These features include fundamental features such as referential integrity and transaction processing which is still not fully integrtaed in MySQL.This made MySQL to be considered as a “TOY DATABASE” among the hardcore professional community.

     

  • Support

    MySQL is much more widely used, so many more applications support MySQL, and there is a larger community ready to assist you with problems, as well as more books and resources on MySQL.Of course, PostgreSQL has active mailing lists, and there are commercial companies offering support as well,it is not as extensive as MySQL

 

  • Ease-of-use

    It is a highly situation dependant.It depends on what you are trying to do and the complexity assosiated with it.If you regularly use sub-selects or triggers , PostgreSQL is what you need.Rewriting them in MySQL or a scripting language will seem unecessarily complex. On the other hand PostgreSQL’s extra functionality can translate into complexity if you do not require any of it.

    The tool we use also determine the ease to a great extend.phpMyAdmin for MySQL is a well-developed tool, while phpPgAdmin is not as fully-featured.

 

  • StabilityMySQL is used in extremely high volume environments without problems. PostgreSQL’s advanced features are more likely to be stable than the newer MySQL equivalents, having been implemented for longer.

 

  • SpeedMySQL aimed first to be a fast database, while PostgreSQL aimed to be a fully-featured database, and both are converging in the other’s direction.

    Postgres slower on low-end but has some options for improving.Postgres forks on every incoming connection – and the forking process and backend setup is a bit slow.

    MySQL handles connections very fast, thus making it suitable to use MySQL for Web.

 

  • SPECIAL server-side FEATURESSPECIAL server-side FEATURES Postgres has rules, triggers, server-side functions that can be written in C, pgsql, python, perl and tcl languages. INSTEAD OF rules can be used for updating data through views.

    MySQL has simple (and probably inconvenient) mechanism for server-side shared libraries with C functions. Rudimentary support for triggers was included beginning with MySQL 5.0.2.

 

  • LicensingPostgreSQL released under an MIT-style license and is thus free and open source software. As with many other open-source programs, PostgreSQL is not controlled by any single company — a global community of developers and companies develops the system.

    MySQL is licensed under the terms of the GNU General Public License,this ensures that MySQL will continue to be freely available in the sense of the open source idea.However for commercial applications of MySQL there is a second, commercial license available in addition to GPL.

 

Comments

site creator: Hello there, allow me to bring in a fresh product - Zebroid - a dual purpose blog generator. With its help, it is possible to create Adsense completely ready internet sites, for MFA or other purposes. It can quickly post content within a lot more than 40 Content management systems engines (Hubpages, Joomla !, Drupal, DataLife Engine, Maxsite, Zebrum Lite, Nano CMS, Netcat, Rumba XML), generate static web-sites of any composition in addition to submit information on different providers (Word press. com, Blogger.com, LiveJournal.com as well as others). Moreover,there exists a customizable tool for automatic posting and uploading of the content in any engine and via FTP server. CMS installer - in a few clicks it will install CMS engines you need and all the necessary plugins and templates on desired servers. Also, thereis a varietyoftoolsthatwill facilitate the work of the webmaster, such as: Commenting On Blogs for the click of the mouse button Picture parser Video parser Automatic insertion of relevant meta tags Automatic distribution of articles by categories (relevant or random) Cleaning of titles/articles by set parameters Built in thesaurus Translation using a base of “Google translate” Convenient to use relink kit (which will help you to create internal and external links) and many other useful tools to manage the content … Around one thousand buyers have got appreciated the particular operation and simplicity of Zebroid software. Furthermore, becoming a totally unique and top notch software Zebroid can and will be improved and adjusted to fit the customers’ needs. Every user can contribute their own idea to further improve the program, and everyone are going to be heard, since satisfaction of our own customers is our main top priority. Official site: [url=http://www.zebroid.us]Zebroid. us[/url] Video demonstration of this program: [url=http://youtu. be/QlIHbagfsVg] Web site creator [/url] ".

Leave a Reply

Your email address will not be published. Required fields are marked *

  1. Anonymous says:
    April 18, 2011 at 10:26 pm

    This is what i was looking for, awsome articel 

    Reply
  2. Shobinsun says:
    April 19, 2011 at 1:09 pm

    Hi Kiran,

    Appreciate your effort to explore the differences between two world famous , mostly used databases. But I want to ask one question. Did you check the features you pointed out in the blog? In the features comparison page, you wrote: " The stable version of MySQL does not support subqueries, stored procedures, cursors or views, all of which PostgreSQL does."
    MySQL version 5.0 onwards, it supports the subqueries, stored procedures, cursors and views. The latest stable version is MySQL 5.5. For reference, please look at the following links and check the features:
    http://dev.mysql.com/doc/refman/5.0/en/subqueries.html
    http://dev.mysql.com/tech-resources/articles/mysql-storedprocedures.html
    http://dev.mysql.com/doc/refman/5.0/en/views.html
    http://dev.mysql.com/doc/refman/5.0/en/cursors.html

    And also MySQL supports transaction processing with the database storage engine "InnoDB". There is a special feature in the mysql server that it supports multiple storage engine which does not appear in any of the databases. I am not going to explain the advantages of MySQL, but just to make you aware of the existing functionality.

    Please check comparison points before posting in the blog. Expect more blogs from you with wide variety of contents.

    Best Regards.

    Reply
  3. Rohith Ravindran says:
    May 12, 2011 at 11:24 pm

    Could have added more details. Replication is only available in MySQL. Havent mentioned anything about mysql engines as well.

    Reply
  4. site creator says:
    July 24, 2012 at 1:00 pm

    Hello there, allow me to bring in a fresh product – Zebroid – a dual purpose blog generator. With its help, it is possible to create Adsense completely ready internet sites, for MFA or other purposes. It can quickly post content within a lot more than 40 Content management systems engines (Hubpages, Joomla !, Drupal, DataLife Engine, Maxsite, Zebrum Lite, Nano CMS, Netcat, Rumba XML), generate static web-sites of any composition in addition to submit information on different providers (Word press. com, Blogger.com, LiveJournal.com as well as others). Moreover,there exists a customizable tool for automatic posting and uploading of the content in any engine and via FTP server. CMS installer – in a few clicks it will install CMS engines you need and all the necessary plugins and templates on desired servers. Also, thereis a varietyoftoolsthatwill facilitate the work of the webmaster, such as: Commenting On Blogs for the click of the mouse button Picture parser Video parser Automatic insertion of relevant meta tags Automatic distribution of articles by categories (relevant or random) Cleaning of titles/articles by set parameters Built in thesaurus Translation using a base of “Google translate” Convenient to use relink kit (which will help you to create internal and external links) and many other useful tools to manage the content … Around one thousand buyers have got appreciated the particular operation and simplicity of Zebroid software. Furthermore, becoming a totally unique and top notch software Zebroid can and will be improved and adjusted to fit the customers’ needs. Every user can contribute their own idea to further improve the program, and everyone are going to be heard, since satisfaction of our own customers is our main top priority. Official site: [url=http://www.zebroid.us]Zebroid. us[/url] Video demonstration of this program: [url=http://youtu. be/QlIHbagfsVg] Web site creator [/url]

    Reply
© 2020 Zesty Beanz Pvt Ltd All Rights Reserved.