Join Sheeri Cabral for an in-depth discussion in this video Next steps, part of Understanding MariaDB for MySQL Users.
- View Offline
…MariaDB is a fork of MySQL.…Ir has many features that help DBAs and developers work more efficiently.…Dynamic Columns allow MariaDB to work with semi-structured data.…Tables can have more than one dynamic column, and dynamic columns can be nested.…The CONNECT storage engine was originally designed to mimic the FEDERATED and…FEDERATED X storage engines.…Those storage engines connect to remote MySQL databases.…The CONNECT storage engine does that and much more.…
It's possible to connect not only to MySQL databases, but…any data store that uses ODBC drivers.…Postgres, Oracle, Microsoft SQL server,…even Microsoft Excel formatted spreadsheets.…The CONNECT storage engine allows database tables to be made out of…many different kinds of text files.…CSV, INI, and CSF files, and XML files.…Reading and writing files in remote databases is easy.…There's even a special CONNECT table type that reads metadata from…remote databases and files.…Going beyond just connection, the CONNECT storage engine can…summarize information in a pivot table and unsummarize in occur tables.…
- Why use dynamic columns?
- Creating, updating, and querying dynamic columns
- Installing the CONNECT storage engine
- Connecting to remote data
- Connecting to CSV, INI, and XML files
- Using PIVOT tables
- Accessing database metadata
- Working with the Cassandra storage engine