Skip to main content


Showing posts with the label sqlserver;postgres;mysql;

Why Oracel or SQL DBA like Postgres than mysql

We can create database server architecture similar to Oracle/SQL as well as mysql and also feature of mongodb. Postgres Supports all sorts of performance optimization that we used in Oracle or SQL Server. I think in that's case where MySQL is lacking. Supports materialized views and temporary tables. Supports temporary tables but does not support materialized views. It implements the SQL standard very well. It includes support for "advanced" SQL stuff like window functions or common table expressions (now supported in MySQL 8.0) . Postgres is very innovative in the matter of how plpgsql interacts with SQL. It supports lots of advanced data types, such as (multi-dimensional) arrays, user-defined types, etc. MySQL is partially compliant on some of the versions (e.g does not support CHECK constraints). PostgreSQL is widely used in large systems where read and write speeds are crucial and data needs to validated. In addition, it supports a variety of performance op