PostgreSQL Isolation Levels Explained with Python
A tested Python tutorial: see what each PostgreSQL isolation level lets through, overspend a budget three ways, then stop it with SERIALIZABLE retries, a row lock or one UPDATE.
PostgreSQL24 min read
Notes from building and running backends, cloud platforms and AI products in production. Each post starts from something real: a migration that went sideways, a design that held up under load, a cost that surprised everyone.
Written for engineers who want the specifics, with a clear takeaway for the managers and founders who have to make the call.
A tested Python tutorial: see what each PostgreSQL isolation level lets through, overspend a budget three ways, then stop it with SERIALIZABLE retries, a row lock or one UPDATE.
PostgreSQL24 min read
A tested, step-by-step Python tutorial: lose and invent payment events with a dual write, then build an outbox, a relay and an idempotent Kafka consumer that survive crashes.
Distributed Systems27 min read
Plan a GCP to AWS migration around a short, rehearsed cutover: the service map, the data sync, re-encrypting Vault data, old URL redirects and a clean GCP teardown.
AWS21 min read
A tested, step-by-step Go tutorial: reproduce a retried payment charging the card twice, then make idempotency keys in PostgreSQL hold up under races, crashes and load.
Distributed Systems31 min read
A tested, step-by-step Go tutorial: reproduce two requests spending the same balance, fix it with a Redis lock, then make the fix hold up when things go wrong.
Distributed Systems29 min read
An AWS security checklist for small teams, built on the AWS Startup Security Baseline: 19 controls in three tiers, each with a command, a verify step and its cost.
AWS27 min read
GitHub now issues two OIDC subject formats. Here is a trust policy that accepts both, a way to prove it against every repository, and a safe order for retiring keys.
AWS14 min read
Deny a verb or assert a state? A practical guide to choosing between SCPs, RCPs and declarative policies, with examples and a safe rollout checklist.
AWS13 min read
The order of operations for moving an AWS account between organizations: invite from the destination, enroll in Control Tower, then close the sign-on, guardrail and old-role gaps.
AWS12 min read
Cookie preferences
This site uses Google Analytics cookies to understand how visitors use it. Analytics loads only if you accept, and the data is never used for advertising or sold. Privacy notice