Posts tagged "database"

Ever wonder why your database crawls even with indexes? Standard indexes map every single row, but PostgreSQL offers partial and expression indexes to work smarter.

Imagine Alice and Bob clicking buy on the last iPhone at the exact same millisecond. Without proper database transaction isolation, you get double-selling. Here is how row-level locking solves it.