Readme

dbplyr

Overview

dbplyr is the database backend for dplyr. If you are using dplyr to connect to databases, you generally will not need to use any functions from dbplyr, but you will need to make sure it's installed.

If you find any bugs, please file in dplyr.

Installation

# You can install the released version from CRAN
install.packages("dbplyr")

# Or the the development version from GitHub:
# install.packages("devtools")
devtools::install_github("tidyverse/dbplyr")

Usage

library(dplyr, warn.conflicts = FALSE)

con <- DBI::dbConnect(RSQLite::SQLite(), ":memory:")
copy_to(con, mtcars)

mtcars2 <- tbl(con, "mtcars")
mtcars2
#> Source:     table<mtcars> [?? x 11]
#> Database:   sqlite 3.11.1 [:memory:]
#> 
#> # S3: tbl_dbi
#>      mpg   cyl  disp    hp  drat    wt  qsec    vs    am  gear  carb
#>    <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
#>  1  21.0     6 160.0   110  3.90 2.620 16.46     0     1     4     4
#>  2  21.0     6 160.0   110  3.90 2.875 17.02     0     1     4     4
#>  3  22.8     4 108.0    93  3.85 2.320 18.61     1     1     4     1
#>  4  21.4     6 258.0   110  3.08 3.215 19.44     1     0     3     1
#>  5  18.7     8 360.0   175  3.15 3.440 17.02     0     0     3     2
#>  6  18.1     6 225.0   105  2.76 3.460 20.22     1     0     3     1
#>  7  14.3     8 360.0   245  3.21 3.570 15.84     0     0     3     4
#>  8  24.4     4 146.7    62  3.69 3.190 20.00     1     0     4     2
#>  9  22.8     4 140.8    95  3.92 3.150 22.90     1     0     4     2
#> 10  19.2     6 167.6   123  3.92 3.440 18.30     1     0     4     4
#> # ... with more rows

Functions in dbplyr

Name	Description
db_copy_to	More db generics
do.tbl_sql	Perform arbitrary computation on remote backend
ident	Flag a character vector as SQL identifiers
join.tbl_sql	Join sql tbls.
sql_quote	Helper function for quoting sql elements.
sql_variant	Create an sql translator
memdb_frame	Create a database table in temporary in-memory database.
named_commas	Provides comma-separated string out ot the parameters
reexports	Objects exported from other packages
sql	SQL escaping.
testing	Infrastructure for testing dplyr
win_over	Generate SQL expression for window functions
src_dbi	dplyr backend for any DBI-compatible database
src_sql	Create a "sql src" object
simulate_dbi	Create a local lazy tibble
tbl_sql	Create an SQL tbl (abstract)
translate_sql	Translate an expression to sql.
lahman	Cache and retrieve an
lazy_ops	Lazy operations
sql_build	Build and render SQL from a sequence of lazy operations
sql_escape_logical	More SQL generics
build_sql	Build a SQL string.
copy_to.src_sql	Copy a local data frame to a DBI backend.
nycflights13	Database versions of the nycflights13 data
partial_eval	Partially evaluate an expression.
escape	Escape/quote a string.
in_schema	Refer to a table in a schema
dbplyr-package	dbplyr: A 'dplyr' Backend for Databases
No Results!

Name

Description

db_copy_to

More db generics

do.tbl_sql

Perform arbitrary computation on remote backend

ident

Flag a character vector as SQL identifiers

join.tbl_sql

Join sql tbls.

sql_quote

Helper function for quoting sql elements.

sql_variant

Create an sql translator

memdb_frame

Create a database table in temporary in-memory database.

named_commas

Provides comma-separated string out ot the parameters

reexports

Objects exported from other packages

sql

SQL escaping.

testing

Infrastructure for testing dplyr

win_over

Generate SQL expression for window functions

src_dbi

dplyr backend for any DBI-compatible database

src_sql

Create a "sql src" object

simulate_dbi

Create a local lazy tibble

tbl_sql

Create an SQL tbl (abstract)

translate_sql

Translate an expression to sql.

lahman

Cache and retrieve an

lazy_ops

Lazy operations

sql_build

Build and render SQL from a sequence of lazy operations

sql_escape_logical

More SQL generics

build_sql

Build a SQL string.

copy_to.src_sql

Copy a local data frame to a DBI backend.

nycflights13

Database versions of the nycflights13 data

partial_eval

Partially evaluate an expression.

escape

Escape/quote a string.

in_schema

Refer to a table in a schema

dbplyr-package

dbplyr: A 'dplyr' Backend for Databases

No Results!

Details

Type	Package
URL	https://github.com/tidyverse/dbplyr
BugReports	https://github.com/tidyverse/dplyr/issues
VignetteBuilder	knitr
LazyData	yes
License	MIT + file LICENSE
Collate	'cache.r' 'compat-purrr.R' 'data-lahman.r' 'data-nycflights13.r' 'db-compute.R' 'db-mysql.r' 'db-odbc-hive.R' 'db-odbc-impala.R' 'db-odbc-mssql.R' 'db-postgres.r' 'db-sqlite.r' 'dbi-s3.r' 'dbplyr.R' 'do.r' 'explain.r' 'ident.R' 'lazy-ops.R' 'memdb.R' 'partial-eval.r' 'query.r' 'schema.R' 'simulate.r' 'sql-build.R' 'sql-escape.r' 'sql-generic.R' 'sql-optimise.R' 'sql-query.R' 'sql-render.R' 'sql.R' 'src-sql.r' 'src_dbi.R' 'tbl-lazy.R' 'tbl-sql.r' 'test-frame.R' 'testthat.r' 'translate-sql-helpers.r' 'translate-sql-window.r' 'translate-sql-base.r' 'translate-sql-odbc.R' 'translate-sql.r' 'utils-format.r' 'utils.r' 'zzz.R'
RoxygenNote	6.0.1
Roxygen	list(markdown = TRUE, roclets = c("rd", "namespace", "collate"))
Remotes	tidyverse/dplyr

imports	assertthat , DBI (>= 0.5) , dplyr (>= 0.5.0.9004) , glue , methods , R6 , rlang (>= 0.0.0.9018) , tibble (>= 1.3.0.9007) , utils
suggests	covr , knitr , Lahman (>= 3.0-1) , nycflights13 , rmarkdown , RMySQL , RPostgreSQL , RSQLite (>= 1.0.0) , testthat
depends	R (>= 3.1.2)
Contributors	RStudio

dbplyr v0.0.0.9001

A 'dplyr' Backend for Databases