Cloud Data Storage Solutions
Here is a comparison of some of Google Cloud's data storage solutions:
| Cloud Datastore | Cloud Bigtable | Cloud Storage | Cloud SQL | Cloud Spanner | BigQuery | |
|---|---|---|---|---|---|---|
| Type | NoSQL document | NoSQL wide column | Blobstore | Relational SQL for OLTP | Relational SQL for OLTP | Relational SQL for OLAP |
| Best for | Semi-structured application data, durable key-value data | "Flat" data, Heavy read/write, events, analytical data | Structured and unstructured binary or object data | Web frameworks, existing applications | Large-scale database applications (> ~2 TB) | Interactive querying, offline analytics |
| Use cases | Getting started, App Engine applications | AdTech, Financial and IoT data | Images, large media files, backups | User credentials, customer orders | Whenever high I/O, global consistency is needed | Data warehousing |