dbplyr v0.0.0.9001
0
Monthly downloads
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 
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! | ||
Last month downloads
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 |
Include our badge in your README
[](http://www.rdocumentation.org/packages/dbplyr)
