Backends for R-DBI

Do you maintain a backend and think that yours should be on this list? Please open an issue in the backends repository.

adbi 0.1.1 (2024-01-25) 🔗 🔗 🐛

‘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.

Maintainer: Nicolas Bennett . License: LGPL (>= 2.1)

AzureKusto 1.1.3 (2023-10-12) 🔗 🐛

Interface to ‘Kusto’/‘Azure Data Explorer’

An interface to ‘Azure Data Explorer’, also known as ‘Kusto’, a fast, distributed data exploration service from Microsoft: https://azure.microsoft.com/en-us/products/data-explorer/. Includes ‘DBI’ and ‘dplyr’ interfaces, with the latter modelled after the ‘dbplyr’ package, whereby queries are translated from R into the native ‘KQL’ query language and executed lazily. On the admin side, the package extends the object framework provided by ‘AzureRMR’ to support creation and deletion of databases, and management of database principals. Part of the ‘AzureR’ family of packages.

Maintainer: Alex Kyllo . License: MIT + file LICENSE

bigrquery 1.5.1 (2024-03-14) 🔗 🐛

An Interface to Google’s ‘BigQuery’ ‘API’

Easily talk to Google’s ‘BigQuery’ database from R.

Maintainer: Hadley Wickham . License: MIT + file LICENSE

ckanr 0.7.0 (2023-03-17) 🔗 🐛

Client for the Comprehensive Knowledge Archive Network (‘CKAN’) API

Client for ‘CKAN’ API (https://ckan.org/). Includes interface to ‘CKAN’ ‘APIs’ for search, list, show for packages, organizations, and resources. In addition, provides an interface to the ‘datastore’ API.

Maintainer: Francisco Alves . License: MIT + file LICENSE

ClickHouseHTTP 0.3.3 (2024-04-18) 🐛

A Simple HTTP Database Interface to ‘ClickHouse’

‘ClickHouse’ (https://clickhouse.com/) is an open-source, high performance columnar OLAP (online analytical processing of queries) database management system for real-time analytics using SQL. This ‘DBI’ backend relies on the ‘ClickHouse’ HTTP interface and support HTTPS protocol.

Maintainer: Patrice Godard . License: GPL-3

connections 0.2.0 (2023-12-18) 🔗 🐛

Integrates with the ‘RStudio’ Connections Pane and ‘pins’

Enables ‘DBI’ compliant packages to integrate with the ‘RStudio’ connections pane, and the ‘pins’ package. It automates the display of schemata, tables, views, as well as the preview of the table’s top 1000 records.

Maintainer: Edgar Ruiz . License: MIT + file LICENSE

DatabaseConnector 6.3.2 (2023-12-11) 🔗 🐛

Connecting to Various Database Platforms

An R ‘DataBase Interface’ (‘DBI’) compatible interface to various database platforms (‘PostgreSQL’, ‘Oracle’, ‘Microsoft SQL Server’, ‘Amazon Redshift’, ‘Microsoft Parallel Database Warehouse’, ‘IBM Netezza’, ‘Apache Impala’, ‘Google BigQuery’, ‘Snowflake’, ‘Spark’, and ‘SQLite’). Also includes support for fetching data as ‘Andromeda’ objects. Uses either ‘Java Database Connectivity’ (‘JDBC’) or other ‘DBI’ drivers to connect to databases.

Maintainer: Martijn Schuemie . License: Apache License

DBI.RODBC 0.1-2

DBI front-end to RODBC

A simple DBI front-end to the RODBC package. This package uses version 4 style classes and methods to create a front-end to the existing RODBC (version 0.8-3) package.

Maintainer: David A. James . License: GPL (version 2 or later)

DBI.RPgSQL 0.1-2

DBI front-end to RPgSQL

A simple DBI front-end to the RPgSQL package. This package uses version 4 style classes and methods to create a front-end to the existing RPgSQL (version 1.0-0) package.

Maintainer: David A. James . License: GPL (version 2 or later)

dittodb 0.1.8 (2024-04-09) 🔗 🐛

A Test Environment for Database Requests

Testing and documenting code that communicates with remote databases can be painful. Although the interaction with R is usually relatively simple (e.g. data(frames) passed to and from a database), because they rely on a separate service and the data there, testing them can be difficult to set up, unsustainable in a continuous integration environment, or impossible without replicating an entire production cluster. This package addresses that by allowing you to make recordings from your database interactions and then play them back while testing (or in other contexts) all without needing to spin up or have access to the database your code would typically connect to.

Maintainer: Jonathan Keane . License: Apache License (>= 2.0)

duckdb 1.1.2 (2024-10-30) 🔗 🐛

DBI Package for the DuckDB Database Management System

The DuckDB project is an embedded analytical data management system with support for the Structured Query Language (SQL). This package includes all of DuckDB and an R Database Interface (DBI) connector.

Maintainer: Kirill Müller . License: MIT + file LICENSE

implyr 0.5.0 (2024-02-06) 🐛

R Interface for Apache Impala

‘SQL’ back-end to ‘dplyr’ for Apache Impala, the massively parallel processing query engine for Apache ‘Hadoop’. Impala enables low-latency ‘SQL’ queries on data stored in the ‘Hadoop’ Distributed File System ‘(HDFS)’, Apache ‘HBase’, Apache ‘Kudu’, Amazon Simple Storage Service ‘(S3)’, Microsoft Azure Data Lake Store ‘(ADLS)’, and Dell ‘EMC’ ‘Isilon’. See https://impala.apache.org for more information about Impala.

Maintainer: Ian Cook . License: Apache License 2.0 | file LICENSE

lazysf 0.1.0 (2020-11-14) 🐛

Delayed Read for ‘GDAL’ Vector Data Sources

Lazy read for drawings. A ‘dplyr’ back end for data sources supported by ‘GDAL’ vector drivers, that allows working with local or remote sources as if they are in-memory data frames. Basic features works with any drawing format (‘GDAL vector data source’) supported by the ‘sf’ package.

Maintainer: Michael Sumner . License: GPL-3

MonetDB.R 2.0.0 (2020-08-14)

Connect MonetDB to R

Allows to pull data from MonetDB into R.

Maintainer: Mitchell Weggemans . License: MPL (== 2.0)

MonetDBLite 0.6.0 (2018-07-27) 🐛

In-Process Version of ‘MonetDB’

An in-process version of ‘MonetDB’, a SQL database designed for analytical tasks. Similar to ‘SQLite’, the database runs entirely inside the ‘R’ shell.

Maintainer: Hannes Mühleisen . License: MPL (== 2.0)

noctua 2.6.2 (2023-08-08) 🐛

Connect to ‘AWS Athena’ using R ‘AWS SDK’ ‘paws’ (‘DBI’ Interface)

Designed to be compatible with the ‘R’ package ‘DBI’ (Database Interface) when connecting to Amazon Web Service (‘AWS’) Athena https://aws.amazon.com/athena/. To do this the ‘R’ ‘AWS’ Software Development Kit (‘SDK’) ‘paws’ https://github.com/paws-r/paws is used as a driver.

Maintainer: Dyfan Jones . License: MIT + file LICENSE

odbc 1.5.0 (2024-06-05) 🔗 🔗 🐛

Connect to ODBC Compatible Databases (using the DBI Interface)

A DBI-compatible interface to ODBC databases.

Maintainer: Hadley Wickham . License: MIT + file LICENSE

pool 1.0.4 (2024-10-07) 🔗 🐛

Object Pooling

Enables the creation of object pools, which make it less computationally expensive to fetch a new object. Currently the only supported pooled objects are ‘DBI’ connections.

Maintainer: Hadley Wickham . License: MIT + file LICENSE

RAthena 2.6.1 (2022-12-20) 🐛

Connect to ‘AWS Athena’ using ‘Boto3’ (‘DBI’ Interface)

Designed to be compatible with the R package ‘DBI’ (Database Interface) when connecting to Amazon Web Service (‘AWS’) Athena https://aws.amazon.com/athena/. To do this ‘Python’ ‘Boto3’ Software Development Kit (‘SDK’) https://boto3.amazonaws.com/v1/documentation/api/latest/index.html is used as a driver.

Maintainer: Dyfan Jones . License: MIT + file LICENSE

RClickhouse 0.6.9 (2024-01-19) 🐛

‘Yandex Clickhouse’ Interface for R with Basic ‘dplyr’ Support

‘Yandex Clickhouse’ (https://clickhouse.com/) is a high-performance relational column-store database to enable big data exploration and ‘analytics’ scaling to petabytes of data. Methods are provided that enable working with ‘Yandex Clickhouse’ databases via ‘DBI’ methods and using ‘dplyr’/‘dbplyr’ idioms.

Maintainer: Christian Hotz-Behofsits . License: GPL-2

RH2 0.2.4 (2018-03-14)

DBI/RJDBC Interface to H2 Database

DBI/RJDBC interface to h2 database. h2 version 1.3.175 is included.

Maintainer: “David M. Kaplan” . License: Mozilla Public License 1.1

RJDBC 0.2-10 (2022-03-24)

Provides Access to Databases Through the JDBC Interface

The RJDBC package is an implementation of R’s DBI interface using JDBC as a back-end. This allows R to connect to any DBMS that has a JDBC driver.

Maintainer: Simon Urbanek . License: MIT + file LICENSE

RMariaDB 1.3.3 (2024-11-18) 🔗 🔗 🐛

Database Interface and MariaDB Driver

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

Maintainer: Kirill Müller . License: MIT + file LICENSE

RMySQL 0.10.29 (2024-10-04) 🔗 🐛

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.

Maintainer: Jeroen Ooms . License: GPL-2

RODBCDBI 0.1.1 (2016-03-14)

Provides Access to Databases Through the ODBC Interface

An implementation of R’s DBI interface using ODBC package as a back-end. This allows R to connect to any DBMS that has a ODBC driver.

Maintainer: Nagi Teramo . License: MIT + file LICENSE

ROracle 1.3-1.1 (2021-11-10)

OCI Based Oracle Database Interface for R

Oracle Database interface (DBI) driver for R. This is a DBI-compliant Oracle driver based on the OCI.

Maintainer: Rajendra S. Pingte . License: LGPL

RPostgres 1.4.7 (2024-05-27) 🔗 🐛

C++ Interface to PostgreSQL

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

Maintainer: Kirill Müller . License: MIT + file LICENSE

RPostgreSQL 0.7-7 (2024-09-30) 🔗 🔗

R Interface to the ‘PostgreSQL’ Database System

Database interface and ‘PostgreSQL’ driver for ‘R’. This package provides a Database Interface ‘DBI’ compliant driver for ‘R’ to access ‘PostgreSQL’ database systems. In order to build and install this package from source, ‘PostgreSQL’ itself must be present your system to provide ‘PostgreSQL’ functionality via its libraries and header files. These files are provided as ‘postgresql-devel’ package under some Linux distributions. On ‘macOS’ and ‘Microsoft Windows’ system the attached ‘libpq’ library source will be used.

Maintainer: Tomoaki Nishiyama . License: GPL-3 | file LICENSE

RPresto 1.4.6 (2023-11-01) 🐛

DBI Connector to Presto

Implements a ‘DBI’ compliant interface to Presto. Presto is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes ranging from gigabytes to petabytes: https://prestodb.io/.

Maintainer: Jarod G.R. Meng . License: BSD_3_clause + file LICENSE

RRedshiftSQL 0.1.2 (2016-09-15)

R Interface to the ‘Redshift’ Database

Superclasses ‘PostgreSQL’ connection to help enable full ‘dplyr’ functionality on ‘Redshift’.

Maintainer: Michael Treadwell . License: GPL-2

RSQLite 2.3.8 (2024-11-17) 🔗 🐛

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 in a recent version 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.

Maintainer: Kirill Müller . License: LGPL (>= 2.1)

RSQLServer 0.3.0 (2017-06-17) 🐛

SQL Server R Database Interface (DBI) and ‘dplyr’ SQL Backend

Utilises The ‘jTDS’ project’s ‘JDBC’ 3.0 ‘SQL Server’ driver to extend ‘DBI’ classes and methods. The package also implements a ‘SQL’ backend to the ‘dplyr’ package.

Maintainer: Imanuel Costigan . License: GPL-2

sergeant 0.9.1 (2021-11-29) 🐛

Tools to Transform and Query Data with Apache Drill

Apache Drill is a low-latency distributed query engine designed to enable data exploration and analysis on both relational and non-relational data stores, scaling to petabytes of data. Methods are provided that enable working with Apache Drill instances via the REST API, DBI methods and using ‘dplyr’/‘dbplyr’ idioms. Helper functions are included to facilitate using official Drill Docker images/containers.

Maintainer: Bob Rudis . License: MIT + file LICENSE

sparklyr 1.8.6 (2024-04-29) 🐛

R Interface to Apache Spark

R interface to Apache Spark, a fast and general engine for big data processing, see https://spark.apache.org/. This package supports connecting to local and remote Apache Spark clusters, provides a ‘dplyr’ compatible back-end, and provides an interface to Spark’s built-in machine learning algorithms.

Maintainer: Edgar Ruiz . License: Apache License 2.0 | file LICENSE