Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Difference Between MySQL and PostgreSQL
In this post, we will understand the difference between MySQL and PostgreSQL.
MySQL
It is a relational database management system.
It is the product developed by Oracle Corporation.
It is supported by Windows, Mac OS X, Linux, BSD, UNIX, z/OS, Symbian, AmigaOS.
It can’t be extended.
In this system, the phpMyAdmin tool gives the GUI.
Mysqldump and XtraBackup provide backup in MySQL.
It provides temporary table.
It doesn’t provide a materialized view.
It doesn’t provide Data Domain Object to the system.
PostgreSQL
It is an object-relational database management system.
It was developed by the Global Development Group.
It is supported by Windows, Mac OS X, Linux and BSD but not by UNIX, z/OS, Symbian, AmigaOS.
It can be extended.
In this system, the pgAdmin tool provides the GUI.
It provides online backup to the data.
It provides temporary table to the system.
It provides a materialized view to the system.
It provides the Data Domain Object to the system.
136 Views
