{"Package":"dbplyr","Type":"Package","Version":"0.0.0.9001","Title":"A 'dplyr' Backend for Databases","Description":"A dplyr backend for databases that allows you to work with\nremote database tables as if they are in-memory data frames. Basic features\nworks with any database that has a DBI backend; more advanced features\nrequire SQL translation to be provided by the package author.","Authors@R":"c(\nperson(\"Hadley\", \"Wickham\", , \"hadley@rstudio.com\", c(\"aut\", \"cre\")),\nperson(\"RStudio\", role = c(\"cph\", \"fnd\"))\n)","URL":"https://github.com/tidyverse/dbplyr","BugReports":"https://github.com/tidyverse/dplyr/issues","Depends":"\nR (>= 3.1.2)","Imports":"\nassertthat,\nDBI (>= 0.5),\ndplyr (>= 0.5.0.9004),\nglue,\nmethods,\nrlang (>= 0.1.0),\ntibble (>= 1.3.0.9007),\nR6,\nutils","Suggests":"\ncovr,\nknitr,\nLahman (>= 3.0-1),\nnycflights13,\nrmarkdown,\nRSQLite (>= 1.0.0),\nRMySQL,\nRPostgreSQL,\ntestthat","VignetteBuilder":"knitr","LazyData":"yes","License":"MIT + file LICENSE","Collate":"\n'cache.r'\n'compat-purrr.R'\n'data-lahman.r'\n'data-nycflights13.r'\n'db-compute.R'\n'db-mysql.r'\n'db-odbc-hive.R'\n'db-odbc-impala.R'\n'db-odbc-mssql.R'\n'db-postgres.r'\n'db-sqlite.r'\n'dbi-s3.r'\n'dbplyr.R'\n'do.r'\n'explain.r'\n'ident.R'\n'lazy-ops.R'\n'memdb.R'\n'partial-eval.r'\n'query.r'\n'schema.R'\n'simulate.r'\n'sql-build.R'\n'sql-escape.r'\n'sql-generic.R'\n'sql-optimise.R'\n'sql-query.R'\n'sql-render.R'\n'sql.R'\n'src-sql.r'\n'src_dbi.R'\n'tbl-lazy.R'\n'tbl-sql.r'\n'test-frame.R'\n'testthat.r'\n'translate-sql-helpers.r'\n'translate-sql-window.r'\n'translate-sql-base.r'\n'translate-sql-odbc.R'\n'translate-sql.r'\n'utils-format.r'\n'utils.r'\n'zzz.R'","RoxygenNote":"6.0.1","Roxygen":"list(markdown = TRUE, roclets = c(\"rd\", \"namespace\", \"collate\"))","Remotes":"\ntidyverse/dplyr","repoType":"github","tarballUrl":"https://api.github.com/repos/tidyverse/dbplyr/tarball","jsonAuthors":[{"name":"Hadley Wickham","email":"hadley@rstudio.com","maintainer":true},{"name":"RStudio ","email":null,"maintainer":false}],"readme":"\n\ndbplyr

\n=======================================================\n\n[![Build Status](https://travis-ci.org/tidyverse/dbplyr.svg?branch=master)](https://travis-ci.org/tidyverse/dbplyr) [![CRAN\\_Status\\_Badge](http://www.r-pkg.org/badges/version/dbplyr)](http://cran.r-project.org/package=dbplyr) [![Coverage Status](https://img.shields.io/codecov/c/github/tidyverse/dbplyr/master.svg)](https://codecov.io/github/tidyverse/dbplyr?branch=master)\n\nOverview\n--------\n\ndbplyr 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.\n\nIf you find any bugs, please file in [dplyr](https://github.com/tidyverse/dplyr).\n\nInstallation\n------------\n\n``` r\n# You can install the released version from CRAN\ninstall.packages(\"dbplyr\")\n\n# Or the the development version from GitHub:\n# install.packages(\"devtools\")\ndevtools::install_github(\"tidyverse/dbplyr\")\n```\n\nUsage\n-----\n\n``` r\nlibrary(dplyr, warn.conflicts = FALSE)\n\ncon <- DBI::dbConnect(RSQLite::SQLite(), \":memory:\")\ncopy_to(con, mtcars)\n\nmtcars2 <- tbl(con, \"mtcars\")\nmtcars2\n#> Source: table [?? x 11]\n#> Database: sqlite 3.11.1 [:memory:]\n#> \n#> # S3: tbl_dbi\n#> mpg cyl disp hp drat wt qsec vs am gear carb\n#> \n#> 1 21.0 6 160.0 110 3.90 2.620 16.46 0 1 4 4\n#> 2 21.0 6 160.0 110 3.90 2.875 17.02 0 1 4 4\n#> 3 22.8 4 108.0 93 3.85 2.320 18.61 1 1 4 1\n#> 4 21.4 6 258.0 110 3.08 3.215 19.44 1 0 3 1\n#> 5 18.7 8 360.0 175 3.15 3.440 17.02 0 0 3 2\n#> 6 18.1 6 225.0 105 2.76 3.460 20.22 1 0 3 1\n#> 7 14.3 8 360.0 245 3.21 3.570 15.84 0 0 3 4\n#> 8 24.4 4 146.7 62 3.69 3.190 20.00 1 0 4 2\n#> 9 22.8 4 140.8 95 3.92 3.150 22.90 1 0 4 2\n#> 10 19.2 6 167.6 123 3.92 3.440 18.30 1 0 4 4\n#> # ... with more rows\n```"}

Description

Arguments

See Also