|
|
|
|
|
by kmeisthax
775 days ago
|
|
Any semantic meaning in identifiers means all your data is completely denormalized. 1NF specifically requires storing all data as irreducible columns[0]. Most 1NF violations aren't actually all that consequential beyond not being able to do useful JOINs on the data in the column, but doing it in a candidate key column is a bottomless pit of update hazards. [0] This means no comma-separated lists in strings, JSON columns, serialized PHP objects, and so on. |
|