Link | PostgreSQL | MySQL |
---|---|---|
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. |
Sito web | postgresql.org | mysql.com |