What is the Entity-Attribute-Value (EAV) model and when is it a bad idea?

Answer preview

EAV (Entity-Attribute-Value) stores attributes as rows instead of columns: (entity_id, attribute_name, value). It buys a schema that never needs DDL for a new attribute, and pays with the loss of almost everything a relational database gives you — data types, constraints, readabl…