Writing
Technical articles on PostgreSQL, distributed systems, multi-tenant architecture, and backend engineering patterns I've encountered in production.
The Fan-In That Never Fires
A correct-looking fan-in check stalls PostgreSQL workflows under READ COMMITTED with no error and no retry. The fix is a lock on the parent row.
postgresqldistributed-systemskotlinkonduit8 min read
Schema-per-Tenant vs RLS: When to Use Which
A practical comparison of PostgreSQL multi-tenant isolation strategies: row-level security vs separate schemas, from someone who built both.
postgresqlmulti-tenancyarchitecturenest-tenant8 min read
SKIP LOCKED Is Not Enough
Closing the race window in PostgreSQL task queues: why SELECT then UPDATE fails under concurrency, and how atomic CTEs fix it.
postgresqldistributed-systemskotlinkonduit7 min read
Why SET LOCAL, not SET
Connection pool safety in multi-tenant PostgreSQL, and why session-scoped SET poisons shared pools.
postgresqlmulti-tenancynode.jsnest-tenant6 min read