Why NoSQL on GCP matters - Why It Works

Introduction

Sometimes data doesn't fit neatly into tables with rows and columns. NoSQL databases let you store and access data in flexible ways. Google Cloud Platform offers NoSQL services that help apps handle big, changing, or complex data easily.

When your app needs to store lots of data that changes quickly, like user profiles or game scores.

When you want to build apps that handle different types of data, like text, images, or location info, without strict rules.

When you need your app to respond fast to many users at the same time, like chat apps or online shopping carts.

When you want to avoid managing database servers and let Google handle scaling and backups.

When your data structure might change often and you want to avoid costly database redesigns.

Commands

This command creates a Firestore NoSQL database in the us-central1 region on Google Cloud. Firestore is a flexible NoSQL database service.

Terminal

gcloud firestore databases create --region=us-central1

Expected Output

Created Firestore database in region us-central1.

→

--region - Specifies the geographic location for the database to reduce latency.

This command creates a composite index on the 'users' collection to speed up queries filtering by last name ascending and age descending.

Terminal

gcloud firestore indexes composite create --collection-group=users --field-config=fieldPath=lastName,order=ASCENDING --field-config=fieldPath=age,order=DESCENDING

Expected Output

Created composite index for collection group users.

→

--collection-group - Specifies the collection group to index.

→

--field-config - Defines the fields and their sort order for the index.

This command adds a new document with user data to the 'users' collection in Firestore.

Terminal

gcloud firestore documents create users/user123 --data='{"firstName":"Alice","lastName":"Smith","age":30}'

Expected Output

Created document users/user123.

This command retrieves the document data for user123 from the 'users' collection to verify it was stored correctly.

Terminal

gcloud firestore documents get users/user123

Expected Output

{

  "firstName": "Alice",

  "lastName": "Smith",

  "age": 30

}

Key Concept

If you remember nothing else, remember: NoSQL on GCP lets you store and access flexible, fast-changing data without managing servers.

Common Mistakes

Trying to create a Firestore database without specifying the region.

The command fails because Firestore requires a region to know where to place your data.

Always include the --region flag with a valid region like us-central1 when creating a Firestore database.

Not creating necessary indexes before running complex queries.

Queries without proper indexes run slowly or fail because Firestore needs indexes to optimize data retrieval.

Create composite or single-field indexes matching your query patterns before querying.

Using SQL thinking when querying NoSQL data.

NoSQL databases like Firestore use document-based queries, not SQL syntax, so SQL commands won't work.

Use Firestore's document and collection commands or SDK methods designed for NoSQL.

Summary

Create a Firestore NoSQL database in a specific region to store flexible data.

Add indexes to speed up queries on your data collections.

Store and retrieve documents easily without managing database servers.