Materials for the R database connectivity: what did we leave behind? talk given on the useR! 2015 conference.
You will find the presentation in the vignettes folder.
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)
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent