Oracle 19c, 21c, 23ai, 26ai: the silent rewrite of value domains
Seven years of Oracle seen through enumerations: from 19c CHECK to 23ai SQL Domains, all the way to 26ai Assertions. An insurance migration story.
Schema-Design
4 tagged articles
Oracle
Oracle
Enumerations in Oracle: twenty years of workarounds, and the road that opened up with 23ai
Oracle never had a native ENUM. CHECK constraints, lookup tables and SQL Domains 23ai: three roads, a real banking case, and what's coming with 26ai.
PostgreSQL
ENUM in PostgreSQL: when the choice pays off, and when it bites back
PostgreSQL ENUM vs CHECK vs lookup table: ALTER TYPE ADD VALUE is metadata-cheap, dropping a value costs a migration. Three paths, one real telco case.
MySQL
ENUM in MySQL: when it makes your day, and when it ruins your week
MySQL ENUM vs CHECK constraint vs lookup table: three ways to model an enumeration. Pros, cons and real case of a shipment tracking system.