| 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 |
|---|
User reviews and comments