Databases

Most developers know indexes make queries faster. Fewer know why, or when adding one makes things worse.

SQL is easy to write badly. A few habits make queries more readable, more correct, and much easier to optimize later.

N+1 is one of the most common performance bugs in backend development. It's subtle, easy to introduce, and can turn a fast endpoint into a slow one as data grows.