Tag Info

New answers tagged


JSONB may be easy to read, but it's complicated and inefficient to write into. See for example this question: PostgreSQL update and delete property from JSONB column, on how it looks like. It's an order of magnitude harder than an update/delete with classic EAV tables. Possibly when you'll have written the parts to append/merge/delete key/value pairs, the ...


What you are describing is the EAV (Entity Attribute Value) model which most database professionals would run a mile from. It's also sarcastically called OTLT (One True Lookup Table) and is a classic novice mistake. Your hunch is correct! Here (and here) is the opinion of Joe Celko (a veteran SQL programmer who is/was a member of the SQL standards ...

Top 50 recent answers are included