I use ENUM - Vindicating the Underdog of Data Types
summary
Covers the ENUM column type for relational databases, explaining its strengths and weaknesses for constraining column values and making schemas more descriptive. Details practical usage: how to design schemas with ENUM, use and rely on enum value ordering, cast values, and manipulate ENUM columns.
AI-written summary · about
related talks
43mAdvanced Data Types in PostgreSQL
01h 02mDesign Good Schemas - Get a Better Database
28mSchema-as-Code: Developer platforms and database schema changes
39mThe base problem
46mThe Lost Art of Database Design
44mEvolutionary Database Design & Architecture
27mStrategies for Reliable Database Schema Migrations
45mAdvanced Data Types in PostgreSQL