- SQL database
- NoSQL database
- Object Storage
Comparisons
| SQL | NoSQL | Object Storage |
|---|
| Scalability | Vertical | Horizontal | Horizontal |
| Transactions | ACID | Varies | |
| Queries | Complex requiring expensive joins | Flexible | Based on metadata of blob |
When to Use
| SQL | NoSQL | Object Storage |
|---|
| Structured data | Semi-structured | Unstructured or binary data (images, video, etc.) |
| Strict schema | Unknown or flexible schema | Backup/disaster recovery is critical |
| Data is relational | Non-relational data | Serving content directly to client such as a CDN |
| Straight-forward pattern for scalability | There is no need for complex joins | |
| Transactions | Very large data-sets (in the TB or PB) | |
| Need of complex joins | High throughput IOPS (input/output operations per second) | |
| Queries by index are fast | | |