HomeProjectsBlogContact
Tips & writing

Notes from the workbench

Practical engineering tips, design theory and performance breakdowns — written for developers and founders who like their advice tested in production.

Why LOWER() and TRIM() Kill Your SQL Index Performance

Why LOWER() and TRIM() Kill Your SQL Index Performance

A query that runs in 4ms locally but takes 9 seconds in production usually has the same cause: a function like LOWER() or TRIM() wrapped around an indexed column. Learn why this makes queries non-sargable, how to spot it in your execution plan, and five engine-specific fixes — from functional indexes to PostgreSQL's citext type.

Read →
Clean Code Tips That Make a Real Difference

Clean Code Tips That Make a Real Difference

Clean code isn't about rules from a book. It's about the next person reading your code, who is often you. Practical habits for naming, functions, comments and structure that pay off every week.

Read →