PostgreSQL Vs. MySQL

Likes 1

Database The Database is an organized collection of various forms of data. It is used by any organization for storing, retrieving and manipulating information to design the web application or website. If You are working with the database the first step is to research which database will best serve your needs. Many database packages are available, some are free (MySQL, Microsoft SQL, PostgreSQL) and others cost hundreds of thousands of dollars(Oracle). Features of PostgreSQL vs MySQL

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