memdb_frame {dbplyr} | R Documentation |
memdb_frame()
works like tibble::tibble()
, but instead of creating a new
data frame in R, it creates a table in src_memdb()
.
memdb_frame(..., .name = unique_table_name()) tbl_memdb(df, name = deparse(substitute(df))) src_memdb()
... |
A set of name-value pairs. Arguments are evaluated sequentially,
so you can refer to previously created elements. These arguments are
processed with |
df |
Data frame to copy |
name, .name |
Name of table in database: defaults to a random name that's unlikely to conflict with an existing table. |
library(dplyr) df <- memdb_frame(x = runif(100), y = runif(100)) df %>% arrange(x) df %>% arrange(x) %>% show_query() mtcars_db <- tbl_memdb(mtcars) mtcars_db %>% count(cyl) %>% show_query()