Learn R Programming

⚠️There's a newer version (2.5.0) of this package.Take me there.

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.

Issues

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.19.3 [:memory:]
#>      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

Copy Link

Version

Install

install.packages('dbplyr')

Monthly Downloads

484,776

Version

1.2.2

License

MIT + file LICENSE

Issues

Pull Requests

Stars

Forks

Maintainer

Hadley Wickham

Last Published

July 25th, 2018

Functions in dbplyr (1.2.2)

partial_eval

Partially evaluate an expression.
in_schema

Refer to a table in a schema
escape

Escape/quote a string.
sql

SQL escaping.
sql_build

Build and render SQL from a sequence of lazy operations
sql_variant

Create an sql translator
remote_name

Metadata about a remote table
src_dbi

dplyr backend for any DBI-compatible database
src_sql

Create a "sql src" object
lazy_ops

Lazy operations
memdb_frame

Create a database table in temporary in-memory database.
nycflights13

Database versions of the nycflights13 data
named_commas

Provides comma-separated string out ot the parameters
sql_escape_logical

More SQL generics
simulate_dbi

Create a local lazy tibble
tbl_sql

Create an SQL tbl (abstract)
sql_expr

Generate SQL from R expressions
testing

Infrastructure for testing dplyr
translate_sql

Translate an expression to sql.
win_over

Generate SQL expression for window functions
window_order

Override window order and frame
ident

Flag a character vector as SQL identifiers
join.tbl_sql

Join sql tbls.
lahman

Cache and retrieve an src_sqlite of the Lahman baseball database.
build_sql

Build a SQL string.
copy_to.src_sql

Copy a local data frame to a DBI backend.
db_copy_to

More db generics
sql_quote

Helper function for quoting sql elements.
dbplyr-package

dbplyr: A 'dplyr' Back End for Databases
do.tbl_sql

Perform arbitrary computation on remote backend