Comparison of Google Cloud Database Options
Bigtable
Section titled “Bigtable”There are many pros to using Bigtable: it handles large amounts of data, scales up or down as needed, and supports a variety of data types. Additionally, Bigtable is designed to be highly available and can provide near-real-time access to data, resizing without downtime, with simple administration and scalability.
BigQuery
Section titled “BigQuery”BigQuery is a powerful tool that can handle large amounts of data efficiently. It is also easy to use and has many features that make it a good fit for data analysis. On the downside, BigQuery can be expensive to use, and it can be challenging to get started if you are not familiar with it.
Cloud SQL
Section titled “Cloud SQL”Google Cloud SQL is fully managed, flexible, automatically replicated across multiple zones, encrypted at rest and in transit, automatic updates.
Cloud Spanner
Section titled “Cloud Spanner”Cloud Spanner uses TrueTime to execute the same query on multiple regions to ensure consistency. If your data needs to be consistent and cannot wait for replication, choose Cloud Spanner.
Compute VM
Section titled “Compute VM”Running a database cluster on Compute VM, you take all the management upon yourself. If you select the wrong compute sizes, either too big or too small, you run risks of rising costs or falling performance.
| Product | Relational | Structured | Unstructured | Heavy R/W | Low Latency | Global Consistency |
|---|---|---|---|---|---|---|
| Bigtable | 🔴 | 🟢 | 🟢 | 🟢 | 🟢 | 🔴 |
| BigQuery | 🟢 | 🟢 | 🟢✝ | 🔴✝✝ | 🔴 | 🔴 |
| Cloud Firestore | 🔴 | 🔴 | 🟢 | 🔴 | 🔴 | 🔴 |
| Firebase Realtime Database | 🟢 | 🟢 | 🟢✝ | 🔴✝✝ | 🔴 | 🟢 |
| Cloud SQL | 🟢 | 🟢 | 🟢 | 🔴 | 🔴 | 🔴 |
| Cloud Spanner | 🟢 | 🟢 | 🔴 | 🔴 | 🔴 | 🟢 |
| Compute VM | 🟢 | 🟢 | 🟢 | 🔴 | 🔴 | 🔴 |
| Symbol | Meaning |
|---|---|
| 🟢 | Yes |
| 🔴 | No |
| ✝ | Semi Unstructured Data with the Json type |
| ✝✝ | Read / Append Only |