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.
Tag
#sql
Every story tagged #sql.
Security
SQL injection is still here. Parameterized queries still fix it
One of the oldest web vulnerabilities keeps showing up in new code. The fix has been known for decades — here's how to apply it everywhere, including the places ORMs don't cover.
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
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.