20h ago · 11 min read · Source: Techniques to Make Database Integration Tests Fast Enough for Developers to Actually Run Them There is a particular kind of dread in a codebase when a developer hears "run the integration tests" — it sounds like a half-hour ritual of waitin...
Join discussion
1d ago · 8 min read · What did you imagine deploying your first project would feel like? For me, it was one clean command. A progress bar. A green checkmark. A live URL I could paste into a browser and say, "Look, it's rea
Join discussion1d ago · 4 min read · PostgreSQL Parallel Query: Configuration & Performance Tuning I was helping a team optimize their reporting pipeline. Their aggregation queries against a 100M-row table were taking 30+ seconds each. They had a 32-core server with plenty of RAM. When ...
Join discussion
2d ago · 5 min read · Welcome to the world of full-stack development! If you've ever wondered how a website remembers who you are—and more importantly, how it keeps your private data away from everyone else—you're in the r
Join discussion
3d ago · 7 min read · I recently resolved two separate production bugs that turned out to share the same root cause — a seemingly innocent DATE() call wrapped around a timestamptz column. What made it worse: the pattern ha
Join discussion
2d ago · 5 min read · Originally published at recca0120.github.io JOIN two tables on a nullable column and the rows disappear. Insert two NULLs into a UNIQUE column and neither insert fails. Both problems share the same root: SQL defines NULL as unknown, and unknown is ne...
Join discussion3d ago · 6 min read · If you have ever used Google Login, GitHub Login, or "Sign in with X", you have used OpenID Connect (OIDC). In this guide, we will build a production-style OIDC Authorization Server, step by step, usi
Join discussion
