Designing Safe Database Schema Changes
Of all the operational risks I worry about as a CTO in regulated payments, the one that keeps recurring in postmortems is not a fancy distributed-systems...
11 min354Read →
Tagged #database
5 articles tagged #database.
Connection Pooling and Why It Matters
Most of the worst production incidents I have managed in fintech did not start with a dramatic failure. They started quietly, with a service that was perfectly...
12 min926Read →
Database Indexing for Application Developers
Most application developers treat the database as a black box. They write a query, it returns rows, and as long as the page loads in under a second nobody asks...
11 min720Read →
Optimistic vs Pessimistic Locking
Every payments engineer eventually meets the same enemy: two requests that arrive at almost the same instant, both convinced they are operating on the truth. A...
11 min346Read →
Database Migrations Without Downtime in .NET
Every team I have led eventually hits the same wall: the schema needs to change, the business cannot tolerate a maintenance window, and the database underneath...
10 min468Read →