dplyr (version 0.5.0)

src_memdb: Per-session in-memory SQLite databases.

Description

src_memdb lets you easily access a sessio-temporary in-memory SQLite database. memdb_frame() works like data_frame, but instead of creating a new data frame in R, it creates a table in src_memdb

Usage

src_memdb()
memdb_frame(..., .name = random_table_name())

Arguments

...

A set of name-value pairs. Arguments are evaluated sequentially, so you can refer to previously created variables.

.name

Name of table in database: defaults to a random name that's unlikely to conflict with exist

Examples

if (require("RSQLite")) {
src_memdb()

df <- memdb_frame(x = runif(100), y = runif(100))
df %>% arrange(x)
df %>% arrange(x) %>% show_query()
}