MySQL vs PostgreSQL
)
MySQL
MySQL is an open-source relational database management system (RDBMS).
MySQL was developed by MySQL AB in 1995. Now managed, supported and distributed by Oracle Corporation.
MySQL was implemented in C and C++.
MySQL has multiple storage engines i.e InnoDB and MyISAM.
MySQL uses tables as a core component
MySQL uses the MySQL Workbench GUI Tool.
PostgreSQL
PostgreSQL is an open-source object relational database management system (ORDBMS).
PostgreSQL was developed at the University of California, Berkeley in 1996. Now managed by PostgreSQL Global Development Group.
PostgreSQL was implemented in C.
PostgreSQL has a single storage engine.
PostgreSQL uses tables, constraints, triggers, roles, stored procedures and views as the core components
PostgreSQL uses the PgAdmin GUI Tool.
