R database connectivity: what did we leave behind?

Materials for the R database connectivity: what did we leave behind? talk given on the useR! 2015 conference.

Presentation

You will find the presentation in the vignettes folder.

Tests

To prepare the presentation a set of tests for DBI drivers compatibility was developed.

To enable others to simply replicate the tests they were encapsuleted into an R package and published in this repository.

To install the package please type:

devtools::install_github('zozlak/useR2015')

Then you can use test functions e.g.:

library(useR2015)
library
system('monetdbd start monetdb')
handlers = list(
  SQLite = dbConnect(RSQLite::SQLite(), ":memory:"),
  MySQL = dbConnect(RMySQL::MySQL(), dbname = 'myDb'),
  PostgreSQL = dbConnect(RPostgreSQL::PostgreSQL(), dbname = 'myDb'),
  MonetDB = dbConnect(MonetDB.R::MonetDB.R(), 'pathToMyMonetDb')
)

# test all capabilities at once
sapply(handlers, test_dbi_driver)

# test specific API call
sapply(handlers, test_dbGetQuery)