MySQL vs PostgreSQL

MySQL has no write-up on Specifiction yet; its figures are above.

PostgreSQL is a free, open-source database system for storing and scaling complex data workloads. It uses SQL and adds object-relational capabilities, with support for primitive and structured values as well as documents, geometric data, and custom types. Its supported formats include JSON/JSONB, XML, arrays, ranges, and UUIDs. For data integrity, it provides keys, constraints, locks, transactions, savepoints, and SQL-standard transaction isolation levels. Performance tools include multiple index types, query planning and optimization, parallel processing, partitioning, just-in-time expression compilation, and asynchronous I/O. Recovery and availability features include write-ahead logging, several replication methods, point-in-time recovery, and active standbys. Security options include multiple authentication methods, access controls, row- and column-level security, and multi-factor authentication. Extensions, procedural languages, and foreign data wrappers can connect PostgreSQL to other databases or streams. It runs on Linux, macOS, and Windows, and is self-hosted; no managed service is listed. The PostgreSQL License permits use, copying, modification, and distribution without a fee, subject to its conditions.