Database Comparison
PostgreSQL
ACID-compliant relational DB. Best for complex queries, joins, JSONB support. Extensions ecosystem (PostGIS, pgvector).
MySQL
Widely-used relational DB. Strong read performance, mature replication. Powers most of the web (WordPress, Shopify).
MongoDB
Document store (BSON). Flexible schema, horizontal scaling via sharding. Good for rapid prototyping and unstructured data.
CockroachDB
Distributed SQL. Serializable isolation, auto-sharding, multi-region. PostgreSQL wire-compatible. Survives zone failures.
Redis
In-memory key-value store. Sub-millisecond latency. Caching, sessions, pub/sub, rate limiting. Persistence optional.
Cassandra
Wide-column store. Masterless, linearly scalable writes. Eventual consistency. Great for time-series and IoT data.
DynamoDB
Managed NoSQL by AWS. Single-digit ms latency at any scale. Pay-per-request pricing. Global tables for multi-region.
ClickHouse
Column-oriented OLAP. Blazing fast aggregations on billions of rows. Best for analytics, logs, and event data.