A DBI-compliant R interface to MariaDB and MySQL databases, designed as a modern replacement for RMySQL.
RMariaDB is an R package that provides a database interface and driver for connecting to MariaDB and MySQL databases. It implements the DBI specification to offer a consistent and reliable way to perform database operations—such as querying, data fetching, and table management—directly from R. It is designed as a modern replacement for the older RMySQL package, with improved compliance and maintainability.
R developers and data analysts who need to interact with MariaDB or MySQL databases from within their R workflows, particularly those requiring DBI-compliant database operations.
Developers choose RMariaDB for its strict DBI compliance, ensuring consistent behavior across database operations, and its role as the modern, actively maintained successor to RMySQL with better support for current MariaDB and MySQL features.
An R interface to MariaDB
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Fully implements the DBI specification, ensuring consistent and reliable database operations across R, as emphasized in the README as a core philosophy.
Connects to both MariaDB and MySQL servers using native client libraries, providing flexibility for common database environments without switching packages.
Supports configuration via MariaDB option files (e.g., ~/.my.cnf), allowing secure credential storage without exposing passwords in code, as demonstrated in the Hello World example.
Offers functions for fetching results in chunks (e.g., dbFetch with n parameter), enabling memory-efficient processing of large datasets, as shown in the README code snippet.
Installing from source on Linux requires manual installation of MariaDB Connector/C or libmysqlclient, which adds steps and potential for errors, as detailed in the installation section.
Only supports MariaDB and MySQL, so projects needing to interact with other database systems must use alternative packages, limiting its versatility.
The README warns that older versions of MariaDB Connector/C may cause unreliable behavior with character and blob columns, requiring careful version management and updates.