Postgres
Staging cannot tell you how long a lock is held
A migration that runs instantly against a seeded table can hold an exclusive lock for minutes against a real one. The difference is row count, and staging does not have it.
Read itWriting
Notes on shipping schema changes without taking production down.
What staging cannot measure, what masking has to prove, and what a test environment should do with an outbound call. Written from the parts of the system that already work.
- Postgres
Masking data is easy. Proving it worked is the product.
Any UPDATE statement can overwrite an email column. The hard part is showing that nothing identifying survived anywhere, and that nobody can skip the check.
Read it - Testing
There are five useful answers to an outbound HTTP call in a test environment
Most environments have two: let it through, or break. Neither is right for a payment processor, and the gap is where test runs charge real cards.
Read it
There is a feed.
Next
Know what happens before you deploy.
Create a disposable production twin for every risky change. Catch migration failures before they reach customers.