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 |