I want to store dynamic statistical data in a NoSQL way - a structured document and be able to work on a parameter basis.
e.g.
{
'client': 1245,
'amount': 25425,
'create_date': '2019-01-01'
}
As I understand, MariaDB has two different approaches since version 10.2:
I see some pros and cons in both ways:
I also feel the development of the JSON approach is more active in recent years.
Since I need to decide which way to go for the next couple of years and I haven't found any comparison of the approaches can someone shed some light on this topic?
There are no comments on my topic, so I can at least say what we decided for and why.
We went the way of JSON because of these reasons: