 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. |
| Website | postgresql.org | mysql.com |