Posts about databases
3 posts
-
Zero-downtime schema migrations with expand and contract
Old and new code run side by side during every deploy. Here is how to change a database schema in small, safe steps so neither version breaks.
-
Database connection pooling: what it is and how to size it
Why opening a database connection per request hurts, how a connection pool fixes it, and how to choose pool sizes that do not overload your database.
-
Database indexes, explained without the magic
Indexes fix slow queries but can slow down writes. What they actually do, and how to decide when one is worth it.