Native JSON Data Type In MariaDB - Does it solve searching issue?
@thebigk
•
Oct 26, 2024
Oct 26, 2024
1.7K
I'm reading about JSON data type support in MariaDB and wondering if it specifically addresses the data search issue. For example:
-----------------------------------------------------------------------
ID | Table1 | Table 2 | Table 3 | ...
----------------------------------------------------------------------
1 | Book1 | author1 | ......
----------------------------------------------------------------------
Vs.
-----------------------------------------------------------------------
ID | jSON BLOB | ...
----------------------------------------------------------------------
1 | {book1: author1}| ......
----------------------------------------------------------------------
PS: above json blob is incorrect; but it doesn't matter.
Under normal circumstances, searching json data would put lot of unnecessary burden on the server because you'll first have to fetch the blob, decode it and then check for individual values.
My question is: Does the new JSON data type actually solves this issue and allow users to directly query json blobs efficiently; like the NoSQL solutions out there.
-----------------------------------------------------------------------
ID | Table1 | Table 2 | Table 3 | ...
----------------------------------------------------------------------
1 | Book1 | author1 | ......
----------------------------------------------------------------------
Vs.
-----------------------------------------------------------------------
ID | jSON BLOB | ...
----------------------------------------------------------------------
1 | {book1: author1}| ......
----------------------------------------------------------------------
PS: above json blob is incorrect; but it doesn't matter.
Under normal circumstances, searching json data would put lot of unnecessary burden on the server because you'll first have to fetch the blob, decode it and then check for individual values.
My question is: Does the new JSON data type actually solves this issue and allow users to directly query json blobs efficiently; like the NoSQL solutions out there.