CSV (comma separated values) is a very common data-interchange format. MariaDB can easily import CSV formatted files using the
LOAD DATA INFILE command, and there is a CSV storage engine that stores data in the CSV format. However, neither of these handles cases where we need to be capable of querying CSV files that are updated outside of MariaDB and CSV files that we don't have to import before we can query them. The CONNECT storage engine's
CSV data type allows us to do this easily.
We need to have some CSV data to work with for this recipe. We'll use data from the
ISFDB database for this. To start with, perform the following steps:
ISFDBdatabase as described in the Importing ...