Difference between MariaDB and PostgreSQL
Last Updated :
23 Jun, 2020
1. MariaDB :
MariaDB is an open source relational database management system (RDBMS) that is a compatible drop-in replacement for the widely used MySQL database technology. It is developed by MariaDB Foundation and initially released on 29 October 2009. MariaDB has a significantly high number of new features, which makes it better in terms of performance and user-orientation than MySQL.
2. PostgreSQL :
PostgreSQL is a powerful, open-source Object-relational database system. It provides good performance with low maintenance efforts because of its high stability. PostgreSQL was the first DBMS that implemented multi-version concurrency control (MVCC) feature.
Difference between MariaDB and PostgreSQL :
S.NO. |
MARIADB |
POSTGRESQL |
1. |
Developed by MariaDB Corporation Ab and MariaDB Foundation on 2009. |
Developed By PostgreSQL Global Development Group on 1989. |
2. |
It is a MySQL application compatible open source RDBMS, enhanced with high availability, security, interoperability and performance capabilities. |
It is widely used open source RDBMS. |
3. |
MariaDB is written in C and C++ languages. |
PostgreSQL is written in C languages. |
4. |
The primary database model for MariaDB is Relational DBMS. |
Also the primary database model for PostgreSQL is Relational DBMS. |
5. |
It has two Secondary database models – Document store and Graph DBMS. |
It has Document store as Secondary database models. |
6. |
Server operating systems for MariaDB are FreeBSD, Linux, Solaris and Windows. |
Server operating systems for PostgreSQL are FreeBSD, HP-UX, Linux, NetBSD, OpenBSD, OS X, Solaris, Unix and Windows. |
7. |
It supports Server-side scripting. |
It has user defined functions for Server-side scripts |
8. |
Supported Partitioning method are – Horizontal partitioning, sharding with Spider storage engine and Galera cluster. |
In PostgreSQL, partitioning can be done by range, list and hash. |
9. |
It support two replication methods – Master-master replication and Master-slave replication. |
It support only one replication methods – Master-master replication |
10. |
It supports in-memory capabilities. |
It does not supports in-memory capabilities. |
Like Article
Suggest improvement
Share your thoughts in the comments
Please Login to comment...