Connecting from R via RMariaDB
Similiar to Python, you can connect to MariaDB in R with installed packages. RMariaDB is a database interface and MariaDB driver for R. It is aimed at full compliance with R's DBI specification.
R & libraries
RMariaDB can be accessed via CRAN.
The package can be installed in R with the following statement:
And loaded in the R environment executing:
We encourage you to use this configuration file for all connections to the MariaDB server. This file contains the hostname of the server, connection port, login credentials, and the location of the certificate file. It should be saved at the appropriate location in your home folder. Guard this file as you would your credit card number! Please see our Configuration Files page for more information. Please contact RCS if you do not have this file.
We encourage you to use our R script file as a template for connecting to the MariaDB server. Please contact RCS for the simple sample script.
For detailed information about RMariaDB please refer to RMariaDB package documentation.