MySQL vs PostgreSQL - Differences and What to Choose

This mysql vs postgresql database management system comparison video will provide you with a comparison between two database management systems - MySQL and PostgreSQL.
While MySQL Server is a relational database management system (RDBMS), PostgreSQL is an object-relational database management system, or ORDBMS.

According to database management system ranking provided by DB-Engines, MySQL is the second most widely used database management system in the world, and PostgreSQL occupies the fourth place.

Both of these database management systems - MySQL and PostgreSQL - have unique advantages and disadvantages, and are chosen to complete different goals.

To begin with, MySQL is a relational database management system, or an RDBMS while PostgreSQL is an object-relational database management system, also referred to as ORDBMS.

Both of these database management systems run on storage engines - PostgreSQL supports only one, but is developing another one, while MySQL offers support for 4, or if we consider the PERFORMANCE_SCHEMA an engine too, 5 storage engines. Each of those storage engines come with their own quirks and features.

Both of these database management systems are known to support the ACID model, which is a database acronym that stands for atomicity, consistency, isolation, and durability. These database properties ensure that a database management system is left in a valid state despite unexpected errors.

In MySQL Server, ACID is supported primarily by the InnoDB storage engine, while PostgreSQL supports ACID in full.

This SQL tutorial will tell you that MySQL Server supports foreign keys in certain storage engines (InnoDB, etc.) excluding MyISAM, while PostgreSQL supports them in full.

While watching this postgresql vs mysql comparison you will also learn that when it comes to plugins, PostgreSQL takes the lead as it's famous for its extensibility features including extensions like PostGIS that adds support for storing, indexing, and querying geospatial data.
With that being said, MySQL does offer more than a couple of plugins to choose from as well and these plugins include authentication plugins, connection-control plugins, security plugins, and others.

Almost every PostgreSQL tutorial will tell you that PostgreSQL is also exceptionally strong in the data type space offering numeric data types, monetary, character, and binary data types, date/time data types, boolean, enumerated, and geometric data types, network address, bit string and text search types as well as others.
MySQL Server, on the other hand, does have more than a couple of data types that you can choose from and these include numeric, date and time, string data types, the spatial data type, and more.

When it comes to indexing, both MySQL and PostgreSQL offer support for various indexes, but PostgreSQL offers support for advanced index types, such as GIN and GiST.

With these things in mind, we can conclude that both of these database management systems are a fit to achieve specific goals. MySQL Server may be chosen for its wider popularity, and the PostgreSQL project may be a choice for those looking for advanced data type or extension support.

What database management system do you use in your line of work? Is it MySQL, PostgreSQL, or perhaps something completely different? Did you like this postgresql vs mysql comparison? Comment down below, make sure to subscribe to see more database management system comparison videos, and until next time.

Music:
Bali by MBB:   / mbbofficial  
Creative Commons — Attribution-ShareAlike 3.0 Unported — CC BY-SA 3.0
Free Download / Stream: http://tinyurl.com/27ctw9ru
Music promoted by Audio Library http://tinyurl.com/4yrbrbms

#database #mysql #postgresql #sql #web #developer #webdevelopment