DBI - R Database Interface

A database interface definition for communication between R and relational database management systems. All classes in this package are virtual and need to be extended by the various R/DBMS implementations.

Last updated

databaseinterface

21.04 score 317 stars 3.2k dependents 29k scripts 703k downloads

RSQLite - SQLite Interface for R

Embeds the SQLite database engine in R and provides an interface compliant with the DBI package. The source for the SQLite engine and for various extensions is included. System libraries will never be consulted because this package relies on static linking for the plugins it includes; this also ensures a consistent experience across all installations.

Last updated

databasesqlite3cpp

19.27 score 336 stars 1.2k dependents 11k scripts 236k downloads

odbc - Connect to ODBC Compatible Databases (using the DBI Interface)

A DBI-compatible interface to ODBC databases.

Last updated

databaseodbcunixodbccpp

16.72 score 414 stars 30 dependents 3.5k scripts 159k downloads

RPostgres - C++ Interface to PostgreSQL

Fully DBI-compliant C++-backed interface to PostgreSQL <https://www.postgresql.org/>, an open-source relational database.

Last updated

databasepostgrespostgresqlcpp

15.48 score 337 stars 40 dependents 3.9k scripts 54k downloads

RMySQL - Database Interface and 'MySQL' Driver for R

Legacy 'DBI' interface to 'MySQL' / 'MariaDB' based on old code ported from S-PLUS. A modern 'MySQL' client written in 'C++' is available from the 'RMariaDB' package.

Last updated

databasemysql

13.45 score 209 stars 15 dependents 4.4k scripts 46k downloads

RMariaDB - Database Interface and MariaDB Driver

Implements a DBI-compliant interface to MariaDB (<https://mariadb.org/>) and MySQL (<https://www.mysql.com/>) databases.

Last updated

databasemariadbmysqlcpp

12.55 score 137 stars 11 dependents 1.2k scripts 28k downloads

bigrquery - An Interface to Google's 'BigQuery' 'API'

Easily talk to Google's 'BigQuery' database from R.

Last updated

bigquerydatabasecpp

12.54 score 528 stars 4 dependents 2.5k scripts 12k downloads

DBItest - Testing DBI Backends

A helper that tests DBI back ends for conformity to the interface.

Last updated

databasetesting

8.44 score 24 stars 11 scripts 13k downloads

adbi - 'DBI' Compliant Database Access Using 'ADBC'

In order to make Arrow Database Connectivity ('ADBC' <https://arrow.apache.org/adbc/>) accessible from R, an interface compliant with the 'DBI' package is provided, using driver back-ends that are implemented in the 'adbcdrivermanager' framework. This enables interacting with database systems using the Arrow data format, thereby offering an efficient alternative to 'ODBC' for analytical applications.

Last updated

arrowdatabase

5.54 score 21 stars 4 scripts 289 downloads

dblog - Logging for DBI

Provides logging of DBI methods for arbitrary backends.

Last updated

databasedbilogging

3.70 score 10 stars 7 scripts