backends

The goal of backends is to provide a web API that lists all known DBI backends. It is implemented as a set of static JSON files

Usage

Query all packages

all <- httr::GET("https://r-dbi.github.io/backends/all.json")
httr::stop_for_status(all)
all_df <- httr::content(all, flatten = TRUE, simplifyVector = TRUE)

all_df$url <- purrr::map_chr(all_df$url, glue::glue_collapse, ", ")
all_df

name	version	title	description	date	maintainer	license	url	bugs
AzureKusto	1.0.6	Interface to ‘Kusto’/‘Azure Data Explorer’	An interface to ‘Azure Data Explorer’, also known as ‘Kusto’, a fast, highly scalable data exploration service from Microsoft: https://azure.microsoft.com/en-us/services/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.	2020-04-27	Alex Kyllo jekyllo@microsoft.com	MIT + file LICENSE	https://github.com/Azure/AzureKusto, https://github.com/Azure/AzureR	https://github.com/Azure/AzureKusto/issues
bigrquery	1.3.1	An Interface to Google’s ‘BigQuery’ ‘API’	Easily talk to Google’s ‘BigQuery’ database from R.	2020-05-15	Hadley Wickham hadley@rstudio.com	GPL-3	https://github.com/rstats-db/bigrquery	https://github.com/rstats-db/bigrquery/issues
ckanr	0.5.0	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.	2020-07-30	Scott Chamberlain myrmecocystus@gmail.com	MIT + file LICENSE	https://docs.ropensci.org/ckanr, https://github.com/ropensci/ckanr	https://github.com/ropensci/ckanr/issues
connections	0.1.1	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.	2020-02-07	Javier Luraschi javier@rstudio.com	GPL-3	https://github.com/edgararuiz/connections	https://github.com/edgararuiz/connections/issues
DatabaseConnector	3.0.0	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’, and ‘SQLite’). Also includes support for fetching data as ‘Andromeda’ objects. Uses ‘Java Database Connectivity’ (‘JDBC’) to connect to databases (except SQLite).	2020-06-06	Martijn Schuemie schuemie@ohdsi.org	Apache License	https://ohdsi.github.io/DatabaseConnector, https://github.com/OHDSI/DatabaseConnector	https://github.com/OHDSI/DatabaseConnector/issues
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.	NA	David A. James dj@bell-labs.com	GPL (version 2 or later)	http://developer.r-project.org/db	NA
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.	NA	David A. James dj@bell-labs.com	GPL (version 2 or later)	http://developer.r-project.org/db	NA
DBItest	1.7.0	Testing ‘DBI’ ‘Backends’	A helper that tests ‘DBI’ back ends for conformity to the interface.	2019-12-16	Kirill Müller krlmlr+r@mailbox.org	LGPL (>= 2.1)	https://dbitest.r-dbi.org, https://github.com/r-dbi/DBItest	https://github.com/r-dbi/DBItest/issues
duckdb	0.2.1	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 a R Database Interface (DBI) connector.	2020-09-10	Hannes Mühleisen hannes@cwi.nl	MPL	https://duckdb.org/, https://github.com/cwida/duckdb	https://github.com/cwida/duckdb/issues
implyr	0.3.0	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.	2019-07-21	Ian Cook ian@cloudera.com	Apache License 2.0	file LICENSE	https://github.com/ianmcook/implyr
MonetDB.R	2.0.0	Connect MonetDB to R	Allows to pull data from MonetDB into R.	2020-08-14	Mitchell Weggemans mitchell.weggemans@monetdbsolutions.com	MPL (== 2.0)	http://www.monetdb.org	NA
MonetDBLite	0.6.0	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.	2018-07-27	Hannes Mühleisen hannes@cwi.nl	MPL (== 2.0)	https://github.com/hannesmuehleisen/MonetDBLite-R	https://github.com/hannesmuehleisen/MonetDBLite-R/issues
noctua	1.8.1	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.	2020-09-25	Dyfan Jones dyfan.r.jones@gmail.com	MIT + file LICENSE	https://github.com/DyfanJones/noctua	https://github.com/DyfanJones/noctua/issues
odbc	1.2.3	Connect to ODBC Compatible Databases (using the DBI Interface)	A DBI-compatible interface to ODBC databases.	2020-06-18	Jim Hester jim.hester@rstudio.com	MIT + file LICENSE	https://github.com/r-dbi/odbc	https://github.com/r-dbi/odbc/issues
pool	0.1.4.3	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.	2019-10-03	Joe Cheng joe@rstudio.com	GPL-3	https://github.com/rstudio/pool	https://github.com/rstudio/pool/issues
rapbase	1.10.0	Base Functions and Resources for Rapporteket	Provide common functions and resources for registry specific R-packages at Rapporteket https://rapporteket.github.io/rapporteket/articles/short_introduction.html. This package is relevant for developers of packages/registries at Rapporteket.	2019-08-07	Are Edvardsen biorakel@gmail.com	GPL-3	http://github.com/Rapporteket/rapbase	http://github.com/Rapporteket/rapbase/issues
RAthena	1.10.1	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.	2020-09-27	Dyfan Jones dyfan.r.jones@gmail.com	MIT + file LICENSE	https://github.com/DyfanJones/RAthena	https://github.com/DyfanJones/RAthena/issues
RClickhouse	0.5.2	A ‘DBI’ Interface to the ‘Yandex Clickhouse’ Database Providing Basic ‘dplyr’ Support	‘Yandex Clickhouse’ (https://clickhouse.yandex/) 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.	2020-03-06	Christian Hotz-Behofsits christian.hotz-behofsits@wu.ac.at	GPL-2	https://github.com/IMSMWU/RClickhouse	https://github.com/IMSMWU/RClickhouse/issues
RecordLinkage	0.4-12.1	Record Linkage Functions for Linking and Deduplicating Data Sets	Provides functions for linking and deduplicating data sets. Methods based on a stochastic approach are implemented as well as classification algorithms from the machine learning domain. For details, see our paper “The RecordLinkage Package: Detecting Errors in Data” Sariyar M / Borg A (2010) doi:10.32614/RJ-2010-017.	2020-08-25	Murat Sariyar murat.sariyar@bfh.ch	GPL (>= 2)	, https://journal.r-project.org/archive/2010-2/RJournal_2010-2_Sariyar+Borg.pdf	NA
RJDBC	0.2-8	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.	2020-03-10	Simon Urbanek Simon.Urbanek@r-project.org	MIT + file LICENSE	http://www.rforge.net/RJDBC/	NA
RMariaDB	1.0.10	Database Interface and ‘MariaDB’ Driver	Implements a ‘DBI’-compliant interface to ‘MariaDB’ (https://mariadb.org/) and ‘MySQL’ (https://www.mysql.com/) databases.	2020-08-27	Kirill Müller krlmlr+r@mailbox.org	GPL-3	https://rmariadb.r-dbi.org, https://github.com/r-dbi/RMariaDB, https://downloads.mariadb.org/connector-c/	https://github.com/r-dbi/RMariaDB/issues
RMySQL	0.10.20	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 based on ‘Rcpp’ is available from the ‘RMariaDB’ package.	2020-03-14	Jeroen Ooms jeroen@berkeley.edu	GPL-2	https://downloads.mariadb.org/connector-c/	https://github.com/r-dbi/rmysql/issues
RODBCDBI	0.1.1	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.	2016-03-14	Nagi Teramo teramonagi@gmail.com	MIT + file LICENSE	NA	NA
ROracle	1.3-1	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.	2016-10-26	Rajendra S. Pingte rajendra.pingte@oracle.com	LGPL	http://www.oracle.com	NA
RPostgres	1.2.0	‘Rcpp’ Interface to ‘PostgreSQL’	Fully ‘DBI’-compliant ‘Rcpp’-backed interface to ‘PostgreSQL’ https://www.postgresql.org/, an open-source relational database.	2019-12-18	Kirill Müller krlmlr+r@mailbox.org	GPL-3	https://rpostgres.r-dbi.org, https://github.com/r-dbi/RPostgres	https://github.com/r-dbi/RPostgres/issues
RPostgreSQL	0.6-2	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.	2017-06-24	Tomoaki Nishiyama tomoakin@staff.kanazawa-u.ac.jp	GPL-2	file LICENSE	https://github.com/tomoakin/RPostgreSQL, https://cran.r-project.org/package=DBI, http://www.postgresql.org
RPresto	1.3.4	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/.	2019-10-18	Onur Ismail Filiz onur@fb.com	BSD_3_clause + file LICENSE	https://github.com/prestodb/RPresto	https://github.com/prestodb/RPresto/issues
RSQLite	2.2.0	‘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 is included.	2020-01-07	Kirill Müller krlmlr+r@mailbox.org	LGPL (>= 2.1)	https://rsqlite.r-dbi.org, https://github.com/r-dbi/RSQLite	https://github.com/r-dbi/RSQLite/issues
RSQLServer	0.3.0	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.	2017-06-17	Imanuel Costigan i.costigan@me.com	GPL-2	https://github.com/imanuelcostigan/RSQLServer	https://github.com/imanuelcostigan/RSQLServer/issues
sergeant	0.9.0	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.	2020-06-01	Bob Rudis bob@rud.is	MIT + file LICENSE	https://gitlab.com/hrbrmstr/sergeant	https://gitlab.com/hrbrmstr/sergeant/issues
SpaDES.core	1.0.3	Core Utilities for Developing and Running Spatially Explicit Discrete Event Models	Provides the core framework for a discrete event system (DES) to implement a complete data-to-decisions, reproducible workflow. The core DES components facilitate modularity, and easily enable the user to include additional functionality by running user-built modules. Includes conditional scheduling, restart after interruption, packaging of reusable modules, tools for developing arbitrary automated workflows, automated interweaving of modules of different temporal resolution, and tools for visualizing and understanding the DES project.	2020-09-12	Alex M Chubaty alex.chubaty@gmail.com	GPL-3	https://spades-core.predictiveecology.org/, https://github.com/PredictiveEcology/SpaDES.core	https://github.com/PredictiveEcology/SpaDES.core/issues
TSfame	2015.4-1	‘TSdbi’ Extensions for Fame	A ‘fame’ interface for ‘TSdbi’. Comprehensive examples of all the ’TS*’ packages is provided in the vignette Guide.pdf with the ‘TSdata’ package.	2015-04-30	Paul Gilbert pgilbert.ttv9z@ncf.ca	GPL-2	http://tsdbi.r-forge.r-project.org/	NA
TSgetSymbol	2013.9-1	TSdbi extension to connect with getSymbols	Provides methods for generics in the TSdbi package to retrieve data with getSymbols, in particular from the Federal Reserve FRED database. Comprehensive examples of all the TS* packages is provided in the vignette Guide.pdf with the TSdata package.	2013-09-29	Paul Gilbert pgilbert.ttv9z@ncf.ca	GPL-2	http://tsdbi.r-forge.r-project.org/	NA
TShistQuote	2013.9-1	TSdbi extensions for get.hist.quote	Provides methods for generics in the TSdbi package to retrieve data from historical quote URLs. Comprehensive examples of all the TS* packages is provided in the vignette Guide.pdf with the TSdata package.	2013-09-29	Paul Gilbert pgilbert.ttv9z@ncf.ca	GPL-2	http://tsdbi.r-forge.r-project.org/	NA
TSjson	2014.4-1	TSdbi extension for importing time series from web sources via JSON	Provides methods for generics in the TSdbi package to retrieve data from web data sources, importing them using Javascript object notation. Direct connections or a proxy connection are possible. (Only Statistics Canada connections are currently supported.) Comprehensive examples of all the TS* packages is provided in the vignette Guide.pdf with the TSdata package.	2014-04-09	Paul Gilbert pgilbert.ttv9z@ncf.ca	GPL-2	http://tsdbi.r-forge.r-project.org/	NA
TSmisc	2016.8-1	‘TSdbi’ Extensions to Wrap Miscellaneous Data Sources	Methods to retrieve data from several different sources. This include historical quote data from ‘Yahoo’ and ‘Oanda’, economic data from ‘FRED’, and ‘xls’ and ‘csv’ data from different sources. Comprehensive examples of all the ’TS*’ packages is provided in the vignette Guide.pdf with the ‘TSdata’ package.	2016-08-26	Paul Gilbert pgilbert.ttv9z@ncf.ca	GPL-2	http://tsdbi.r-forge.r-project.org/	NA
TSpadi	2012.8-1	TSdbi extensions for PADI Time Series Server	Provides methods for generics in the TSdbi package to connect through a protocol for application database interface (PADI) to a time series database (e.g. Fame). Comprehensive examples of all the TS* packages is provided in the vignette Guide.pdf with the TSdata package.	2012-10-02	Paul Gilbert pgilbert.ttv9z@ncf.ca	GPL-2	http://tsdbi.r-forge.r-project.org/	NA
TSsdmx	2016.8-1	‘TSdbi’ Extension to Connect with ‘SDMX’	Methods to retrieve data in the Statistical Data and Metadata Exchange (‘SDMX’) format from several database. (For example, ‘EuroStat’, the European Central Bank, the Organisation for Economic Co-operation and Development, the ‘Unesco’ Institute for Statistics, and the International Labor Organization.) This is a wrapper for package ‘RJSDMX’. Comprehensive examples of all the ’TS*’ packages is provided in the vignette Guide.pdf with the ‘TSdata’ package.	2016-08-26	Paul Gilbert pgilbert.ttv9z@ncf.ca	GPL-2	http://tsdbi.r-forge.r-project.org/	NA
TSxls	2013.8-2	TSdbi extension to connect to spreadsheets	Provides TSdbi package methods to retrieve time series data from spreadsheets, pretending the spreadsheet is a database. Comprehensive examples of all the TS* packages is provided in the vignette Guide.pdf with the TSdata package.	2013-09-29	Paul Gilbert pgilbert.ttv9z@ncf.ca	GPL-2	http://tsdbi.r-forge.r-project.org/	NA
TSzip	2013.9-1	TSdbi extension to connect to zip files	Provides TSdbi package methods to retrieve time series data from zipped, as if the files form a database. Comprehensive examples of all the TS* packages is provided in the vignette Guide.pdf with the TSdata package.	2013-09-29	Paul Gilbert pgilbert.ttv9z@ncf.ca	GPL-2	http://tsdbi.r-forge.r-project.org/	NA

Query a single package

first_name <- all_df$name[[1]]
first_url <- paste0("https://r-dbi.github.io/backends/by-package/", first_name, ".json")
first <- httr::GET(first_url)
httr::stop_for_status(first)
httr::content(first)
#> $version
#> [1] "1.0.6"
#> 
#> $title
#> [1] "Interface to 'Kusto'/'Azure Data Explorer'"
#> 
#> $description
#> [1] "An interface to 'Azure Data Explorer', also known as 'Kusto', a fast, highly scalable data exploration service from Microsoft: <https://azure.microsoft.com/en-us/services/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."
#> 
#> $date
#> [1] "2020-04-27"
#> 
#> $maintainer
#> [1] "Alex Kyllo <jekyllo@microsoft.com>"
#> 
#> $license
#> [1] "MIT + file LICENSE"
#> 
#> $url
#> $url[[1]]
#> [1] "https://github.com/Azure/AzureKusto"
#> 
#> $url[[2]]
#> [1] "https://github.com/Azure/AzureR"
#> 
#> 
#> $bugs
#> [1] "https://github.com/Azure/AzureKusto/issues"

---

Please note that the ‘backends’ project is released with a Contributor Code of Conduct. By contributing to this project, you agree to abide by its terms.