Does that make sense...🤔🤔

I dont want it to

Yes.
Well at least in MySQL you can store and search json objects. I don't recommend it, but when you don't want to normalise some data it comes in handy.

You can do it also in postgres, there is json type

@vane @C0D4 Feels weird...

@Konsole it's mind boggling the first time you do it. But I tend to only use it for non essential data that serves no purpose at a database level.

Aka:
non searchable, non relational data, or I couldn't be bothered setting up 2-3 more tables for a small piece of data that isn't going to be selected directly anyway.

But I'm sure it has its uses for more practical data as well.

https://dev.mysql.com/doc/refman/...

I like this little tool. https://nosqlbooster.com/

I put my json data in a mongodb and with the little helper you can write sql statements to query it.

@Konsole well json is pretty nice format compared to xml and you can also store xml type, what is missing is storing yaml 🙂

@vane well I would take json over yaml anyday.

And quick question, are there any performance benefits of storing as Jason?

@Konsole I don’t know 🤷‍♂️ it’s good to store unstructured data as json, maybe if you want to query both sql and json from one database and combine those results but I can’t think of any good usage example.

But I am not database expert.