MySQL vs PostgreSQL vs MongoDB

mysql-vs-postgresql-vs-mongodb
MySQL

VS
PostgreSQL

VS
MongoDB

Database Structure
Type
Relational
Relational
NoSQL

Data Storage
Tables
Tables
Documents

Performance & Scalability
Speed
High performance for read-heavy workloads
Excellent performance for complex queries
High performance with large sets of unstructured data

Vertical Scaling
Supports vertical scaling
Supports vertical scaling
Limited vertical scaling

Horizontal Scaling
Challenging
Challenging
Easy with sharding

Features
ACID Compliance
Fully ACID compliant
Fully ACID compliant
Not ACID compliant but provides eventual consistency

Support for JSON
Limited support
Strong support
Native support

Use Cases
Best for Transactions
Ideal for transactional applications
Ideal for transactional applications
Less suited for transactional use

Best for Big Data
Not ideal for big data
Not ideal for big data
Designed for big data applications