Database Options — 🗄️ SQL, NoSQL, and Data Storage

Cloud databases fall into two main categories: SQL (relational) and NoSQL (non-relational). Each excels in different scenarios.

🎯 SQL Databases (Relational)

Data organized in tables with rows and columns. Relationships between tables.

Best for: Structured data, transactions, complex queries

Examples:

• AWS: RDS (MySQL, PostgreSQL, MariaDB)

• GCP: Cloud SQL

• Azure: SQL Database

Customers Table:
│ ID │ Name    │ Email         │
├────┼─────────┼───────────────┤
│ 1  │ Alice   │ alice@ex.com  │
│ 2  │ Bob     │ bob@ex.com    │

Orders Table:
│ ID │ CustomerID │ Product  │ Amount │
├────┼────────────┼──────────┼────────┤
│ 1  │ 1          │ Laptop   │ $1000  │
│ 2  │ 1          │ Mouse    │ $50    │

Pros:

• Structured data storage

• Data integrity (transactions)

• Complex queries possible

• Familiar technology

Cons:

• Scaling is complex (vertical scaling mainly)

• Fixed schema (hard to change structure)

• Requires database design planning

💡 NoSQL Databases (Non-Relational)

Flexible document storage. No strict table structure.

Best for: Unstructured data, massive scale, rapid iteration

Types:

• **Document Stores:** Firestore, MongoDB (store JSON documents)

• **Key-Value Stores:** DynamoDB (fast lookups)

• **Time Series:** InfluxDB (metrics, logs)

• **Graph:** Neo4j (relationships)

Examples:

• AWS: DynamoDB

• GCP: Firestore

• Azure: Cosmos DB

Document Database (Firestore):
{
  "user_id": "123",
  "name": "Alice",
  "email": "alice@ex.com",
  "preferences": {
    "theme": "dark",
    "notifications": true
  }
}

Pros:

• Schema-less (flexible structure)

• Scales horizontally (add more servers)

• Fast reads/writes

• Handles massive scale (millions of ops/sec)

Cons:

• No transactions (in traditional sense)

• Complex queries harder

• Consistency tradeoffs

📊 SQL vs NoSQL Comparison

🎨 Real-World Examples

SQL (Traditional Applications)

• Banking system (transactions critical)

• E-commerce catalog (structured products)

• Accounting software (relationships important)

NoSQL (Modern Applications)

• Social media feeds (massive scale, unstructured)

• Real-time analytics (fast writes)

• Mobile app backend (flexible schema)

• IoT sensors (time series data)

💾 Other Storage Options

Object Storage (Files)

Store any file type (images, videos, documents). Cheapest storage.

• AWS: S3

• GCP: Cloud Storage

• Azure: Blob Storage

Cost: ~$0.02-0.05 per GB/month

Data Warehousing

Analyze massive datasets (terabytes/petabytes).

• AWS: Redshift

• GCP: BigQuery

• Azure: Synapse Analytics

🔑 Key Takeaways

• ✅ SQL for structured, relational data (transactions, complex queries)

• ✅ NoSQL for flexible, massive scale data (documents, key-value)

• ✅ Object storage for files (images, videos)

• ✅ Most applications use both SQL and NoSQL

• ✅ Data volume and access patterns determine choice

Want optimization strategies? 🗄️ Database Options (Experienced)