4 ms·
If you want to allow user-defined fields in a relational database, your realistic are either EAV or stuff json into a text column. EAV, if done extremely carefu
by malisper 10y ago
If you want to allow user-defined fields in a relational database, your realistic are either EAV or stuff json into a text column. EAV, if done extremely carefully, can be a good solution, but 99% of the time, it's going to be a huge pain.
- approachingtraj 10y ago> stuff json into a text column You did see the article was about JSONB, which is significantly more sophisticated than "json in a text column", yes?
- malisper 10y agoYes, the person I was replying to was asking about what to do if you don't have jsonb.