dplyr-src-h2

A dplyr extension which allows to use an H2 database as a data source.

Installation

Assuming devtools is installed, run:

devtools::install_github("hoesler/dplyr-src-h2")

Usage

# Use an H2 URL (http://h2database.com/html/features.html#database_url)
src <- src_h2("mem:")

# Use an H2Connection object
drv <- dbj.h2::driver(classpath = resolve(module('com.h2database:h2:1.3.176')))
src <- src_h2(dbConnect(drv, "mem:", "sa", ""))

# Create an H2 src with nycflights13 data (Used for tests, examples, ...)
src <- nycflights13_h2()