#database
Posts tagged with “database”.
13 posts
ACID Transactions Explained With Examples
Atomicity, consistency, isolation and durability are the guarantees a transaction provides. Learn each one and the isolation levels.
API Pagination Patterns: Offset, Cursor and Keyset
Offset, cursor and keyset pagination each trade simplicity for correctness. Learn the trade-offs and which to choose for a large dataset.
Connection Pooling Explained for Developers
Opening a connection is expensive, so a pool reuses them. Learn the sizing, the exhaustion, the timeout, and the serverless trap.
Database Indexing Explained With Examples
An index trades write speed and space for read speed. Learn how a B-tree works, when an index is used, and the common mistakes.
Database Migrations: A Practical Guide
A migration changes a schema without losing data. Learn the safe patterns, the zero-downtime approach, and how to roll back.
Database Normalization Explained: 1NF to 3NF
Normalization removes redundancy and update anomalies. Learn the normal forms, the trade-offs, and when to denormalize deliberately.
MongoDB Basics: Documents, Collections and Queries
MongoDB stores a document, not a row. Learn the collection, the query, the index, the aggregation, and the schema design.
The N+1 Query Problem: Finding and Fixing It
One query becomes N+1. Learn how it happens, how to detect it, and the eager loading, batching and join fixes.
ORM vs Raw SQL: Choosing a Data Access Layer
An ORM trades control for convenience. Learn the trade-offs, the N+1 trap, and the hybrid approach most teams settle on.
PostgreSQL Basics: Queries, Indexes and Transactions
Postgres is a relational database with a rich feature set. Learn the query, the index, the transaction, and the JSON support.
SQL Joins Explained With Visual Examples
Inner, left, right, full and cross joins each return a different set of rows. Learn the difference and the mistakes that cause duplicates.
SQL vs NoSQL: Choosing a Database
Relational and non-relational databases make different trade-offs. Learn the categories, the guarantees, and how to choose.
Room Database Patterns for Real Apps
Practical patterns for Android Room — reactive Flow queries, relations, transactions, migrations, and testing — that hold up when the app grows past a toy project.