Databases
Why more teams are running SQLite in production
Once dismissed as a toy, SQLite now powers serious web apps. WAL mode, fast NVMe disks and better tooling changed the math.
Tag
#performance
Every story tagged #performance.
Databases
Postgres indexes beyond the basics: partial, expression and covering
A plain B-tree index on the right column solves most problems. For the rest, Postgres has index types that are smaller, faster and more precise.
DevOps
Writing Dockerfiles that build in seconds, not minutes
Most slow Docker builds come down to layer ordering. A few structural habits make rebuilds dramatically faster.
Databases
N+1 queries: how to spot them and how to fix them
The most common ORM performance bug hides in plain sight in your logs. Eager loading fixes it — once you know where to look.
Web
HTTP caching, properly: Cache-Control, ETags and what browsers actually do
The fastest request is the one that never reaches your server. A practical guide to the headers that control browser and CDN caching.
Languages
How garbage collectors work, and why your app pauses
Garbage collection frees you from manual memory management, but it isn't free. A tour of the main algorithms and what they mean for latency.
Databases
Database connection pooling, explained
Hitting "too many connections" errors is a rite of passage. Understanding how pools work — in your app and in front of your database — makes them go away.