SQL vs NoSQL
Why SQL
- Structured Data
- Strict Schema
- Relational data
- Need for complex joins
- Transactions
- Clear patterns for scaling
- Mature
- Index Lookups are fast
Why NoSQL
- Semi-structured Data
- Dynamic Schema
- Non-relational data
- No need for joins
- TB or PB data requirement
- Data intensive
- High Throughput