RMariaDB

RMariaDB is a database interface and MariaDB driver for R that provides full compliance with the DBI specification. It serves as a modern replacement for the older RMySQL package, enabling R users to connect to and interact with MariaDB and MySQL databases.

The package implements the complete DBI interface, allowing users to execute queries, fetch results in chunks or all at once, and manage database connections reliably. It supports MariaDB Connector/C (version 2.3.4/3.0.3 or later recommended) and Oracle’s libmysqlclient for improved handling of character and blob columns. Users can configure database connections through MariaDB configuration files rather than hardcoding credentials, improving security and convenience.