SQL vs NoSQL

Introduction

Both store data, but they make different trade-offs. SQL databases use fixed schemas, strong consistency and joins — perfect for money, orders, inventory. NoSQL databases use flexible schemas and horizontal scale — perfect for logs, IoT, social feeds and caching.

Beginner analogy: SQL is a structured filing cabinet with strict labels; NoSQL is a giant box where you toss anything in and search later.

Understanding the topic

Core concepts to understand:

• SQL: Postgres, MySQL — strong ACID, joins, fixed schema.
• Document NoSQL: MongoDB — flexible JSON-like records.
• Key-Value: Redis, DynamoDB — ultra-fast lookups by key.
• Column: Cassandra, ScyllaDB — write-heavy time series.
• Graph: Neo4j — relationships are first-class.
• Modern apps usually use both — SQL for source-of-truth, NoSQL for cache/search.

Syntax reference

Visual workflow / architecture:

       ┌─────────────────────────────┐
       │         Your App            │
       └──────┬───────────────┬──────┘
              │               │
        ┌─────▼─────┐   ┌─────▼─────┐
        │  SQL DB   │   │ NoSQL DB  │
        │ Postgres  │   │ Redis /   │
        │ (orders)  │   │ Mongo     │
        │ ACID      │   │ (cache,   │
        │ joins     │   │  feeds)   │
        └───────────┘   └───────────┘

Real-world use

Stripe stores every charge in Postgres (must be ACID); they use Redis to cache rate limits and DynamoDB for high-throughput logs. Knowing when to use each is a senior-level skill.

Best practices

• Default to SQL — choose NoSQL only when you have a specific need it solves.
• Never rely on NoSQL for money or inventory without strong app-level checks.
• Use the right tool for each part of the system; polyglot persistence is fine.

Hands-on exercise

Interview preparation — practice these questions:

• Q1. Three differences between SQL and NoSQL.
• Q2. When would you choose MongoDB over Postgres?
• Q3. Can NoSQL be ACID? Give an example.
• Q4. What is polyglot persistence?
• Q5. Why do banks rarely use NoSQL for ledgers?