
Isolation Levels Across Databases: Why the Labels Mislead
The transaction setting you trust might describe very different behavior depending on the engine underneath it.
Follow my Substack blog where I write about software engineering, system architecture, infrastructure, and building things that scale 📝
Live Last read · last published · next check

The transaction setting you trust might describe very different behavior depending on the engine underneath it.

Why strong AI agent systems mix command-line execution, schema-based integrations, and a better interface layer on top

What the 2026 agent-framework RCE wave taught us about trust, tooling, and the real security boundary in AI systems

Why external API calls and database locks should never share the same critical section in 2026

How to review `redirect_uri`, enforce PKCE and `state`, and detect suspicious callback and token behavior before an implementation gap becomes account takeover.

How a webview input-handling flaw turned a single click into GitHub token exposure in 2026

Two database deletion incidents, nine months apart, show the same infrastructure flaw hiding behind different tools

Why a powerful platform can slow product delivery when your team is still small, your scale is modest, and your real bottleneck is engineering time.

Why tool-using systems turn one malicious instruction into a cross-system security incident in 2026

Using an automated transaction runner to revisit old concurrency results and expose where modern engines now diverge

Subtitle: A practical guide to PostgreSQL’s eight table-level lock modes, the DDL statements that trigger them, and what those locks really stop in production.

How a write-optimized index design improved ingest speed, exposed a replication flaw, and led to a safer approach for standby nodes in 2026.

What a controlled study of experienced open-source developers suggests about real-world productivity, benchmark hype, and why “helpful” tools can still make people slower in 2026.

A practical guide to scalable GitOps architecture, release flows, multi-cluster design, security, and adoption risks for platform teams

How locks, snapshots, and InnoDB isolation rules shape concurrent reads and writes

A developer-focused look at how prompt injection moved from edge case to production security risk

A developer-focused guide to telemetry, debugging workflows, and resilient distributed systems

Common CI/CD design mistakes that quietly erode speed, reliability, and release confidence in 2026

What actually goes wrong in ANN-backed retrieval systems, and which signals tell you trouble is already underway

Why PostgreSQL serialization errors are not just for writes