RDBMS · NoSQL · Beyond
Database Systems
Explore relational and non-relational databases side by side — when to use SQL vs document stores, how indexing works, and what interviewers expect at FAANG and startups.
Quick Compare
Pick the right database type
| Type | Best for | Examples | Trade-off |
|---|---|---|---|
| Relational | Transactions, reporting, joins | PostgreSQL, MySQL | Schema rigidity |
| Document | Flexible JSON documents | MongoDB, Firestore | Join complexity |
| Key-value | Cache, sessions, rate limits | Redis, DynamoDB | Limited query patterns |
| Graph | Relationships, recommendations | Neo4j, Neptune | Niche, ops overhead |