News for hackers. Stuff that matters.
Re:MySQL Raytracer by KronisLV on Saturday August 13, 2022 @07:35AM (#32448903)
> 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.

There are no comments on this comment yet.