Why SELECT Before INSERT Causes Duplicate RecordsChecking records before an insert causes race conditions under load. Learn why row locks fail and how unique constraints reliably prevent duplicate records.4 min read·doogal.dev12d ago
The 7 Threads Running Inside Every Node.js ProcessExplore why an empty Node.js process launches 7 OS threads, what V8 does in the background, and how these threads differ from the libuv thread pool.5 min read·doogal.dev85ASL5d ago
Why ASP.NET Core Accepts Expired JWTs (And How to Fix It)ASP.NET Core validates expired JWTs due to a default 5-minute clock skew. Learn why this happens, how frameworks compare, and how to set ClockSkew to zero.4 min read·doogal.dev54LAS6d ago
A Day Isn't 24 Hours: Fixing Date Math & DST BugsA calendar day isn't always 24 hours. Learn why duration math breaks during Daylight Saving Time and how to write resilient calendar arithmetic in your code.5 min read·doogal.dev1Nov 11
Why SQL UNIQUE Constraints Allow Duplicate NULLsUnderstand why SQL unique constraints permit duplicate NULLs, the impact on composite keys, and how to use NULLS NOT DISTINCT in PostgreSQL.5 min read·doogal.dev73OSNov 10