Summary

In this chapter, you learned what the CONNECT engine is, and the purpose it should be used for. You also learned how to read and write CSV, XML, and HTML data directly from MariaDB. Then we went deeper into the CONNECT engine, and used the XCOL, OCCUR, and PIVOT tables to transform data.

In the end, you also learned more about the MariaDB community, and some general information about the third-party plugins and storage engines distributed with MariaDB.

To sum up, in this book you first learned how to pick the right version of MariaDB for your needs, how to install MariaDB on the different operating systems, and how to use the console client. After that, we reviewed together the basics of relational databases, and the SQL language implementation used by MariaDB. Then we talked more about the advanced features such as data import and export, views, and virtual columns and dynamic columns. Finally, we discussed the advanced features of MariaDB that are not present in MySQL, full-text...