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
Posts tagged “sql”
Tiny explainers grouped by topic. Spend less time Googling, more time building.
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