The Series of MySQL -1- Basic of MySQL - EP 01_03
HI Hi, Greetings! 
Happy December 
Hi Everyone,
Today, I would like to share with you an article about the first episode of Series of MySQL (Basic of MySQL), and the content is given below.
a. Version of MySQL
b. Differences
i. PostgreSQL vs MySQL
ii. MySQL vs Oracle
a. Version of MySQL:
Versioning is the process of assigning distinct version names or numbers to a group of software programs when they are created and distributed. The term "version 1.0" is widely used to refer to a software or program's initial release. There is no industry standard guideline that governs how version numbers are formatted. As a result, each corporation has its own system for naming software versions. When new features in software and programs are added, bugs are fixed, and security vulnerabilities are plugged in, the version number is changed to reflect these advancements.
The most recent version of MySQL support is version v5.8. Many important modifications have been made, including the addition and removal of new features, the correction of bugs and security issues, and so on. This version provides the MySQL 8.0 to MySQL 8.0.21 release history. It will be available starting in April 2018 and will be supported through April 2026.
When installing MySQL on your PC, you must select the version and distribution format you want to use. MySQL is available in two versions, the first of which is a development release and the second of which is a General Availability (GA) release. The development release contains the most recent feature and should not be used in production. The GA release, often known as the production or stable release, is primarily used for production. As a result, the most recent General Availability release must be chosen.
Version Name | Released Date | End of Support | Description |
MySQL 5.1 | November 2008 | December 2013 | Releases of MySQL between 5.0 to 5.1.73 |
MySQL 5.5 | December 2010 | December 2018 | Releases of MySQL between 5.5 to 5.5.62 |
MySQL 5.6 | February 2013 | February 2021 | Releases of MySQL between 5.6 to 5.5.45 |
MySQL 5.7 | October 2015 | October 2023 | Releases of MySQL between 5.7 to 5.6.27 |
MySQL 8.0 | April 2018 | April 2026 | Releases of MySQL between 8.0 to 8.0.21 |
b. Differences
i. PostgreSQL vs MySQL
Parameter | PostgreSQL | MySQL |
Definition | PostgreSQL is an open-source, cross-platform, and object-relational database management system (ORDBMS) built in the computer science department, University of California. | It is an open-source, cross-platform relational database management system built by Swedish Company MYSQL AB and currently supported by Oracle. |
Known as | PostgreSQL is a more densely featured database system. It is described as the most advanced open-source database version of Oracle in the world. | MySQL is known for its fast speed, but it is less featured than PostgreSQL. It is the most popular database among the organization. |
Release | It was released as Postgre95 in May 1995. | It was released in 1995. |
Licensing | It is licensed under the MIT style. | It is licensed under the GNU (General Public License). |
Popularity | PostgreSQL is popular among the developers who come from the Oracle or SQL Server background. | MySQL is popular among developers because of its fast speed and ease of use. |
GUI Tool | It provides PgAdmin GUI. | It provides MySQL Workbench GUI. |
Storage Engine | PostgreSQL is a unified database server having a single storage engine. | MySQL has a multi-layer structure having a set of storage engines. For example, InnoDB, MyISAM. |
ACID Compliance | It has the complete support of ACID-compliant. | Only some versions are ACID-compliant. |
Main Focus | PostgreSQL is developed with a focus on features and standards. | MySQL is developed with a focus on speed. |
Used | PostgreSQL is generally used on large and complex operations. It is more reliable for them. | MySQL is generally used on simple operations. |
Security | It has Native SSL support. | It has TLS support. |
Provides | PostgreSQL provides reliability, data integrity, and developers-friendly features. | MySQL is generally used with PHP to deal with web pages and optimize simple queries. |
Temporary Table | It does not have a TEMP or TEMPORARY keyword in the DROP TABLE statement. | It has a TEMP or TEMPORARY keyword in the DROP TABLE statement to remove the temporary table. |
Table Inheritance | It supports. | It does not Support. |
Replication | Asynchronous, Cascade, and Synchronous. | Asynchronous, Synchronous, and Semi-synchronous. |
Task Scheduler | It has a pgAgent task scheduler. | It has a Scheduled event. |
Connection Scalability | Here, every time a connection is created, it is an OS process. | Here, every time a connection is created, it is an OS thread. |
Community Support | It has strong and active community support of developers who continually improve the existing features with access to free resources. | It has broad community support of developers who always maintain existing features with new features. |
ii. MySQL vs Oracle:
Parameter | MySQL | Oracle |
Release | It was released in 1995. | It was released in 1980. |
Cost | It is free and open-source. It is licensed under the GNU. | It is licensed for commercial purposes, but it provides the express edition for free. The express edition is recommended for students only. |
Scalability | MySQL database is used for small and big businesses. | Oracle database is used for very large-scale deployments. |
Data Partitioning | It does not support data partitioning. | It supports data partitioning. |
Security | It requires a username, password, and host to access the database. | It requires a username, password, and profile validation to access the database. |
System Type | It only works with the static system. | It can work with both static and dynamic systems. |
Null Value | MySQL supports the null value. | Oracle does not support the null value. |
Character | MySQL support only two characters that are CHAR and VARCHAR. | Oracle supports four different characters that are CHAR, VARCHAR2, NCHAR, and NVARCHAR2. |
Backup Mechanism | It offers only two backup mechanisms that are mysqlhotcopy and mysqldump. | It offers many backup mechanisms that are backup, hot backup, import, export, etc. |
XML Support | It does not support XML. | It supports XML. |
Storage Features | It contains only a few storage features like tablespace, synonym, packages, and many others. | It supports many storage features that are tablespace, synonym, packages, etc. |
Locking facility | MySQL has only a table locking facility. | Oracle has table locking as well as a row locking facility. |
Language support | MySQL support only SQL language. | Oracle supports both SQL and PL/SQL languages. |
Operating System Support | It supports the following Operating systems: Windows, Mac OS X, Linux, UNIX | It supports the following Operating systems: Windows, Mac OS X, Linux, UNIX
|
You are welcome to like and leave feedback in the comment area.
Link:
Main:
EP 01_01:
The Series of MySQL -1- Basic of MySQL - EP 01_01
EP 01_02:
EP 01_04:
EP 01_05:
The Series of MySQL -1- Basic of MySQL - EP 01_05
Source:
· https://www.w3schools.com/mySQl/default.asp
· https://www.mysqltutorial.org/mysql-basics/
M M Zaheer Hussain
Stay Safe!
