jsonnosqlmariadbdynamic-columns

MariaDB NoSQL data using dynamic columns or JSON


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?


Solution

  • 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: