DBI for R

R's interface to databases, with a testable and human-readable specification, a selection of backend packages to connect with various databases, and a boilerplate for developing new backends.

Interface

The DBI package defines generic methods that work almost identically across databases. This is checked by DBItest, which also provides a human-readable specification.

Backends

The RSQLite, MariaDB, and RPostgres packages implement methods defined by DBI that connect to specific databases. There are more packages that connect to other databases.

Boilerplate

The RKazam package makes it easy for package developers to create a new package to a new DBMS.

Blog posts