The Dynamic column feature added into MariaDB since 5.3 allows you to store schemaless data inside a relational datbase. By using Dynamic Columns you a very flexible table structure, somewhat like a key-document store without giving up any of the ACID or other relational properties. You can use this feature to store any type of data where you don't know what attributes you will have in the future, which gives you create flexibility and ease of use. This talk will go through the main characteristics of the dynamic columns feature and show how you can use it to store data in JSON or any other format without having to worry about the column types and names beforehand.
Survey this Session