Posts

Bigtable -Google's NoSQL database

  Bigtable — Easy Notes 1. What is Bigtable? Bigtable is Google's NoSQL database designed for very large amounts of data. Think of it like: Bigtable = NoSQL database + huge data + very fast read/write It is built for high throughput and consistently low latency . 2. When should you choose Bigtable? Bigtable is a good choice when: Situation Example Very large data > 1 TB Billions of customer records Data changes very quickly Stock prices changing every second High read/write speed required Millions of requests per second NoSQL data Data that doesn't need complex table relationships Time-series data Sensor data over time Real-time processing Live analytics Big Data Large-scale data processing Machine Learning Training/processing large datasets Easy example Suppose you have 10 million IoT sensors . Every sensor sends: Sensor ID → Temperature → Time S001 → 28°C → 10:01 S002 → 31°C → 10:01 S003 → 27°C → 10:01 ... And this happens every second . T...
Post a Comment
Read more

Google Cloud Firestore

  Google Cloud Firestore — Easy Notes 🔥 What is Firestore? Firestore = Google Cloud's fully managed NoSQL database. It is mainly useful for: 📱 Mobile applications 🌐 Web applications 🖥️ Server-side applications Unlike Cloud SQL and Spanner, Firestore is NoSQL , not a traditional relational database. 📦 How does Firestore store data? Firestore uses: Collections → Documents → Fields Example: Users (Collection) │ ├── user001 (Document) │ ├── firstname: "Shivam" │ ├── lastname: "Kumar" │ └── age: 25 │ └── user002 (Document) ├── firstname: "Rahul" └── lastname: "Sharma" Collection A collection is like a group of related documents. Example: Users Products Orders Document A document contains the actual data. Example: user001 Key-value pairs Inside the document: firstname → Shivam lastname → Kumar age → 25 🪆 Documents can contain nested data A Firestore document can contain: Simp...
Post a Comment
Read more

Google Cloud Spanner

  Google Cloud Spanner — Easy Notes 🌐 What is Spanner? Spanner = Google Cloud’s fully managed relational database designed for very large-scale applications. The key idea is: Spanner gives you SQL + relational database features + global scalability + strong consistency. ⭐ Main Features 1. 🗄️ Relational Database Spanner is a relational database , so it supports: SQL Tables Relationships Joins Secondary indexes So it behaves like a traditional SQL database, but is designed to scale much further. 2. 📈 Horizontal Scaling This is one of the most important points . Horizontal scaling = add more machines/resources to handle more workload. For example: Small workload ↓ Node 1 More workload ↓ Node 1 + Node 2 + Node 3 + Node 4 Spanner can distribute data and workload across multiple machines. 3. 🔒 Strong Consistency Strong consistency means that after a successful write, subsequent reads see the correct/latest data. Example: You update:...
Post a Comment
Read more

Google Cloud SQL

  Google Cloud SQL — Easy Notes ☁️ What is Cloud SQL? Cloud SQL = Google Cloud’s fully managed relational database service. It supports: MySQL PostgreSQL SQL Server Think of it like: Normal database: You install, configure, patch, backup, and maintain it yourself. Cloud SQL: Google manages most of these tasks for you. 🔧 What does Google manage? Cloud SQL reduces your database maintenance work. Google handles things like: Patching and updates Backups Replication configuration Infrastructure maintenance So you can focus on your application , rather than managing database infrastructure. No software installation or database-server maintenance is required. 📈 Scaling Cloud SQL instances can scale significantly, including up to: 128 processor cores 864 GB RAM 64 TB storage So it can support fairly large relational workloads. 🔄 Replication Cloud SQL supports different replication scenarios. For example: Primary Database → Repl...
Post a Comment
Read more

Google Cloud Storage

☁️ Google Cloud Storage 1. What is Cloud Storage? 4 Cloud Storage = Google Cloud's Object Storage service. It is mainly used to store large amounts of data , especially files such as: 🖼️ Images 🎥 Videos 🎵 Audio 📄 Documents 💾 Backups 📦 Archived data It is fully managed and scalable , so you don't have to manage physical disks or storage servers. 2. What is Object Storage? There are 3 common ways to store data: Storage type How data is stored Example File Storage Files + folders Documents/photo.jpg Block Storage Blocks/chunks of a disk VM disk Object Storage Objects Image/video stored as an object Simple example Suppose you upload: holiday.jpg In object storage, the object contains: Actual data → the image itself Metadata → information about the image For example: File: holiday.jpg Created: 2 Sept 2026 Type: image/jpeg Author: Shivam Permissions: Read Unique ID → identifies the object. So you can think: Object = Data + Metadata + Unique Identifier 3. Why is Object Storage g...
Post a Comment
Read more