dbplyr v0.0.0.9001

by Hadley Wickham

A 'dplyr' Backend for Databases

A dplyr backend for databases that allows you to work with remote database tables as if they are in-memory data frames. Basic features works with any database that has a DBI backend; more advanced features require SQL translation to be provided by the package author.

Readme

dbplyr

Build Status CRAN\_Status\_Badge Coverage Status

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!

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

Include our badge in your README

[![Rdoc](http://www.rdocumentation.org/badges/version/dbplyr)](http://www.rdocumentation.org/packages/dbplyr)