Re:How and why the Relational Model works for databases
by bshipp on Monday January 17, 2022 @02:33PM
(#29970760)
Indeed, you are correct. A lot of these lessons came hard-earned from doing it the wrong way first.
I thought I was being such a good little programmer by normalizing my data as soon as possible. All it did was provide me job security (at the cost of headaches) every time the schema changed.
Then yes, you'd have to parse it yourself, but you'd be doing that anyway with JSON fields, more or less.