Open Source | Purely open source | Open source,But owned by Oracle and several paid edition. |
---|
Governance | The product of the global development group | The product under the terms of the GNU(general public licence). |
---|
Perfomance | Mostly used for web-based projects that you need a database for
straightforward data transaction. | Highly used in large system where to read and write speeds are
important and require execution of complex queries. |
---|
ACID Compliance | Fully ACID compliance | Partially ACID compliance |
---|
SQL Compliance | Mostly SQL Compliant | Partially SQL Compliant |
---|
Supported platforms | Linux,Windows (Win 2000 SP4 and later),Free BSD,Open BSD,Net
BSD,mac OS x,AIX,IRIX,Solaris and open-source Unix OS. | Solaris,Microsoft Windows,Linux mac OS X a Free BSD OS. |
---|
Programming Language | C/C++,R,Tcl,Go,Lisp,Erlang Delphi,Java Script,Java,Python,and .Net. | C/C++,PHP,R,Go,Lisp,Perl,Erlang,Delphi,Java,and Node.JS. |
---|
Materialised View | Supported | Not Supported |
---|
Replication Platform | Master-slave replication and other types of implementation can be
put using third party extensions. | Uses Master-Master replication and perform master-Slave
replication. |
---|
Extensible | Supported | Not Supported |
---|
Access Method | Supported all standards | Supported all standards |
---|
Security | Security secure from ground up with SSL support for connections for
encryptions. | Highly Security, a lot of features are built in MySQL. |
---|
Site web | postgresql.org | mysql.com |
---|
Avis utilisateurs et commentaires