Skip to content
Velloreth

#database

Posts tagged with “database”.

13 posts

01

ACID Transactions Explained With Examples

Atomicity, consistency, isolation and durability are the guarantees a transaction provides. Learn each one and the isolation levels.

02

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.

03

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.

04

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.

05

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.

06

Database Normalization Explained: 1NF to 3NF

Normalization removes redundancy and update anomalies. Learn the normal forms, the trade-offs, and when to denormalize deliberately.

07

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.

08

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.

09

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.

10

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.

11

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.

12

SQL vs NoSQL: Choosing a Database

Relational and non-relational databases make different trade-offs. Learn the categories, the guarantees, and how to choose.

13

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.