Score Cards of MySQLDB vs MariaDB vs PostgreSQL

MySQLDB_MariaDB_PostgreSQL_ScoreCards

 

  MySQL #Scr MariaDB #Scr PostgreSQL #Scr
  MySQL application compatible open source RDBMS, enhanced with high availability, security, interoperability and performance capabilities   Widely used open source RDBMS   Based on the object relational DBMS Postgres   
             
Features             
Supported OS Windows/Linux/Unix/Mac OSX/BSD/Android/Solaris 10 Windows/Linux/Unix/Mac OSX/BSD/Solaris 9 Windows/Linux/Unix/Mac OSX/BSD/Android/Solaris 10
ACID,RI,Transactions Y,Y,Y( except for DDL) 9 Y,P,Y( except for DDL) 8 Y,Y,Y 10
Replication Master-Master & Master-Slave 10 Master-Master & Master-Slave 10 Only Master-Slave 5
Sharding Yes, with MPP query engine. 7 Yes, with MPP query engine. 7 No ( but possible with 3rd party tool https://www.citusdata.com/citus-products/pg-shard) 3
Truggers yes 10 Yes 10 No (Alternatively possible) 7
Master-Master Replication (Active-Active) Yes 10 Yes 10 No, Only support Master-Slave Replication 5
In-Memory Capabilities  Yes 10 Yes 10 No 0
Embeddable  Yes 10 Yes 10 No 0
TTL for entries  No 0 No 0 Yes 10
Graph Support No 0 Yes 10 Conditional  5
Online Backup, Incremental Backup & PITR yes, with MEB/ XtraBackup 10 yes with XtraBackup (not included by default with MariaDB) 8 Yes with some Complications ( you may need 3rd party tools help for large dbs) 6
XML Support Yes 10 Yes 10 No 0
Supported Programming Languages    10   9   6
APIs and other access methods  ADO.NET, JDBC, ODBC 6 ADO.NET, JDBC, ODBC 6 ADO.NET, JDBC, ODBC, C, Streaming API for large objects 10
License  GPL 10 GPL 10 PostgreSQl License, similar to BSD/MIT License 9
DB Engine Ranking Score 1278.96, Rank : 2 Overall, 2 RDBMS 10 Score 24.62, Rank : 25 Overall, 14 RDBMS 9 Score 282.13, Rank : 5 Overall, 4 RDBMS 7
Official website  www.mysql.com   mariadb.org   www.postgresql.org  
Technical Documentation dev.mysql.com/­doc   mariadb.com/­kb/­en/­mariadb   www.postgresql.org/­docs/­manuals  
Initial Release  1995   2009   1989  
Implimentation Language C &  C++   C &  C++   C  
  • Ask Question