3 ms·
> I was not aware one could (or even would want to) store JSON data in a relational database... Perhaps it's to borrow some elements from data stores like Mong
by KronisLV 4y ago
> I was not aware one could (or even would want to) store JSON data in a relational database...
Perhaps it's to borrow some elements from data stores like MongoDB, but whilst keeping most of the system based on the typical table/relation principles.
I've actually seen JSON used in PostgreSQL and admittedly I found the approach to be pretty horrible in most cases, performance/functions/syntax regarding the datatype aside.
Yet, I can't say that there aren't valid use cases for something like that, even if generally I'd advise against storing data that you actually want to query in a relational DB inside of JSON. Perhaps that's just because I believe that it'd increase complexity unnecessarily in most cases.