Apr 5 · 25 min read · TLDR: Isolation levels control which concurrency anomalies a transaction can see. Read Committed (PostgreSQL and Oracle's default) prevents dirty reads but still silently allows non-repeatable reads, write skew, and lost updates. Repeatable Read adds...
Join discussion
Feb 12 · 11 min read · The Fundamental Problem with Traditional Locking Traditional pessimistic locking forces readers to wait for writers and writers to wait for readers, creating a serialization point that destroys throughput. In a system processing 50,000 transactions p...
Join discussionFeb 10 · 2 min read · Shelter 2026 opens in a near-future city where violent storms erase comfort, and therefore fear controls daily behaviour. At dawn, warning sirens echo across flooded streets, so people abandon homes without delay. Meanwhile, emergency screens repeat ...
Join discussion
Feb 3 · 12 min read · The fundamental challenge of modern distributed systems is not how to build for success, but how to design for inevitable failure. In a microservices architecture, the surface area for disaster is massive. A single latent dependency, a saturated data...
Join discussionJan 30 · 5 min read · This week was a short one for me as I spontaneously took Friday off - it’s important to take some time for yourself every now and again and I’d been feeling like I needed a long weekend for a little while. It’s Friday as I’m writing this, but I enjoy...
Join discussion
Jan 5 · 3 min read · A relational database organises data into tables (rows and columns) with relationships between them. Key Components: Rows (Records): Each row represents a single entry Columns (Fields): Each column represents a specific attribute Primary Key: Uniq...
Join discussionJun 9, 2025 · 1 min read · Cейчас я параллельно начал погружаться в проект RyeLang, для которого один из прототипов является Rebol, и в котором, в свою очередь, акцентируются наряду со словами (Форт?) области видимости, ассоциируемые с пространством имен. Идея многозначности т...
Join discussionApr 22, 2025 · 3 min read · After exploring Swift’s recommendation to “use struct by default,”I started thinking about how this impacts data ownership, freshness, and system design — especially in reactive contexts like Combine. In my previous post (link), I showed that structs...
Join discussion
Apr 18, 2025 · 5 min read · Transaction Isolation Levels Explained: A Barista’s Guide to Database Chaos Prevention Imagine two baristas working the same coffee shop register. Barista A starts a latte order but pauses to check the milk supply. Barista B jumps in to tally the day...
Join discussion
