Re:MySQL Raytracer
by Alupis on Friday August 12, 2022 @08:10PM
(#32445481)
Very interesting, I was not aware one could (or even would want to) store JSON data in a relational database...
[1] https://mariadb.com/kb/en/json-data-type/
[ Parent
| on HN ]
> 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.
Re:MySQL Raytracer
by geraldwhen on Friday August 12, 2022 @09:27PM
(#32446020)
I use it to store metadata I don’t need to query for the most part.
Saves a lot of time data modeling and managing schemas for that kind of non critical data.