Pagination That Scales: Offset vs Cursor vs Keyset
Trade-offs, pitfalls, and production-ready code with SQL, Node, FastAPI, MongoDB and Elasticsearch examples.
databasesbackendpostgresql
Posts tagged “databases”
Tiny explainers grouped by topic. Spend less time Googling, more time building.
Time, Timezones, and Timestamps — the least boring, most dangerous part of your stack
UTC vs local time, offsets vs zones, DST edge cases, ISO 8601/RFC 3339, DB column types, and sane patterns in JS/Python/SQL. How to store, compare, schedule, and display time without pain.
devtimedatetime
Zero‑Downtime Migrations — expand/contract without breaking prod
Change schemas safely with backward‑compatible steps, dual writes, background backfills, and rolling deploys. Postgres‑flavored, but patterns apply to MySQL and friends.
devdatabasesmigrations
Database Indexing 101 — faster queries, fewer surprises
A practical mental model for indexes, with copy‑paste patterns for B‑tree, composite order, covering, partial, and expression indexes—plus when **not** to index.
devdatabasessql
What is an N+1 Query and How Do You Fix It?
A fundamental database performance problem: why N+1 happens, how to spot it, and fixes with eager loading/batching in popular ORMs (Django, Rails, Prisma/Sequelize, SQLAlchemy).
devdatabasesorm
SQL vs NoSQL Databases — The 2‑Minute Guide
A high-level comparison of relational and non-relational databases with common use cases for each.
devdatabasessql