Region: A Lesson in Data Integrity

The author, a database-minded engineer, argues that data integrity belongs in the database rather than application code, and walks through four ways to enforce a region column on a 24-million-row Postgres table: a domain, an enum, a text column with a check constraint, and a reference table.