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.
Topic
Databases
SQL, NoSQL, storage engines and data modeling.
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.
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.
Databases
Full-text search without a search cluster
Before you add a dedicated search engine, check what your database already does. Postgres and SQLite both ship capable full-text search.
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.
Databases
Transaction isolation levels without the jargon
Your database lets concurrent transactions see each other in controlled ways. Knowing which anomalies your isolation level allows prevents subtle, expensive bugs.