8 min read
PostgreSQL EXPLAIN ANALYZE: Read a Query Plan
Learn to read PostgreSQL EXPLAIN ANALYZE output: spot row estimate errors, nested loop blowups, and disk spills, then verify the fix with real numbers.
postgresqlquery plansindexing
Blog
Notes on building web applications: Next.js, Laravel, databases, and the automation around them.
9 min read
SQL Indexing: A Practical Debugging Guide
A step-by-step method for finding why an index is ignored: verify column order, wrap types, and operator choices before rewriting the query or adding a new
composite indexindex selectivitycovering index
8 min read
Laravel Queue Workers: Tune Concurrency
Diagnose queue lag caused by blocking sleeps, then size worker concurrency and per-worker memory from measured RSS instead of guessing.
queue workersconcurrencyworker memory
6 min read
Index Database SQL Server: Design, Rebuild, Fill Factor
A practical guide to indexing a SQL Server database: clustered vs nonclustered design, fill factor, and how to rebuild indexes without locking production
sql serverindexingdatabase
6 min read
Laravel Webhooks: Send and Receive Reliably
A practical guide to Laravel webhooks: HMAC signature verification, queue-based delivery, retries, and idempotency for production APIs.
6 min read
Laravel Bail Validation: Stop on the First Failure
Laravel's bail rule stops validation at the first failure per field, when to use it, how stopOnFirstFailure differs, and when showing all errors wins.
laravelvalidation
