Scribd
Upload
41 views1 page

GCP Storage Database CheatSheet

The document provides a cheat sheet for Google Cloud Platform (GCP) storage and database services, outlining key features of Cloud Storage, Cloud SQL, Cloud Spanner, Cloud Firestore, BigQuery, and Bigtable. It highlights their capabilities such as scalability, transaction support, and use cases for various applications. Each service is tailored for specific workloads, from small to large-scale data management and analytics.

Uploaded by

Anish Roshan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
41 views1 page

GCP Storage Database CheatSheet

The document provides a cheat sheet for Google Cloud Platform (GCP) storage and database services, outlining key features of Cloud Storage, Cloud SQL, Cloud Spanner, Cloud Firestore, BigQuery, and Bigtable. It highlights their capabilities such as scalability, transaction support, and use cases for various applications. Each service is tailored for specific workloads, from small to large-scale data management and analytics.

Uploaded by

Anish Roshan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

GCP Storage & Database Cheat Sheet

Cloud Storage
- Store immutable objects > 10MB
- Batch, near real-time uploads
- Backup, global scale, secure storage
- Google Cloud Console: gsutil, user, root

Cloud SQL (Relational DB)


- Managed relational DB with MySQL, PostgreSQL
- Transaction System (ACID)
- Small to medium workload
- Web framework & existing apps

Cloud Spanner (Relational DB)


- Scalable relational DB for high availability
- For large-scale transaction apps
- SQL queries with horizontal scalability

Cloud Firestore (NoSQL)


- NoSQL document DB for mobile and web apps
- Serverless NoSQL
- Real-time sync for mobile apps
- Offline query supported

BigQuery (Data Warehouse)


- Data warehouse & analytics for large datasets
- Serverless architecture with auto-scaling
- Massive dataset support with SQL-like queries
- Big data, real-time analytics

Bigtable (NoSQL)
- NoSQL for time series & large-scale data
- High throughput, low latency
- Used for IoT, user analytics, monitoring systems

You might also like