Introduction
Let first start with the definations of each database and know about the basic of what they are for and get familiar with the database.
1. Mysql
Mysql is one of the popular relational database management system. It is widely used for building and managing large database. Mysql store data in tables having rows and columns. The journey of mysql started in 1994 by a swedish company mysqlab and the first version launched in 23 may 1995.
2. MariaDB
MariaDB is basically a fork of Mysql . It is a community-developed open source relational database management system. The main purpose of creating the mariaDB is to make it remain free and open source. MariaDB first release in 29 october 2009 and currently there are multiple version available.
3. PostgreSQL
PostgreSQL, often referred to as Postgres. it is an advanced level open source relational database management system know for its empahsis on extensibility and adherence to sql standards means it is architected with a focus of modularity and extensibility allowing developers to extend its functionality in various ways.
| Mysql | MariaDB | PostgreSQL |
|---|---|---|
| It was developed by MYSQLAB and currently ownd by oracle company |
It was created by original developer of Mysql to make it open source and license free and it is a modified version of Mysql |
It was developed by PostgreSQL Global Developement Group |
| It has High SQL standard compliance and have some differences in implementation and extensions. | MariaDb also has high sql standards compliance and similar differences in implementation and extensions | It has very strict sql standard compliance. It often implements feature before they become the part of the standards |
| It is oftenly used in read heavy scenarios and genrally it has good performance | It has similar functionality to mysql. | Its know for its powerful feature and steeper learning curve. It has an excellant performance for complex queries, transactions and anlaytical processing |
| It supports different types of storage engines like innoDB, MYISAM etc | It supports the storage engine which is available in mysql and it also has its own storage engine like TokuDB and Aria | It uses a single extensible storage system and it does not have a concept of sotrage engines |
Tags:
programming