dbplyr

A 'dplyr' Back End for Databases

A 'dplyr' back end 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' back end; more advanced features require 'SQL' translation to be provided by the package author.

Total

42,186

Last month

15,962

Last week

3,488

Average per day

532

Daily downloads

Total downloads

Description file content

Package
dbplyr
Type
Package
Version
1.1.0
Title
A 'dplyr' Back End for Databases
Description
A 'dplyr' back end 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' back end; more advanced features require 'SQL' translation to be provided by the package author.
URL
BugReports
https://github.com/tidyverse/dplyr/issues
Depends
R (>= 3.1.2)
Imports
assertthat, DBI (>= 0.5), dplyr (>= 0.5.0.9004), glue, methods, purrr, rlang (>= 0.1.0), tibble (>= 1.3.0.9007), R6, utils
Suggests
covr, knitr, Lahman (>= 3.0-1), nycflights13, rmarkdown, RSQLite (>= 1.0.0), RMySQL, RPostgreSQL, testthat
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-odbc-oracle.R' 'db-odbc-postgres.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-clause.r' 'translate-sql-odbc.R' 'translate-sql.r' 'utils-format.r' 'utils.r' 'window.R' 'zzz.R'
RoxygenNote
6.0.1
NeedsCompilation
no
Packaged
2017-06-26 19:19:44 UTC; hadley
Author
Hadley Wickham [aut, cre], RStudio [cph, fnd]
Maintainer
Hadley Wickham
Repository
CRAN
Date/Publication
2017-06-27 06:55:24 UTC

install.packages('dbplyr')

1.1.0

a month ago

https://github.com/tidyverse/dbplyr

Hadley Wickham

MIT + file LICENSE

Depends on

R (>= 3.1.2)

Imports

assertthat, DBI (>= 0.5), dplyr (>= 0.5.0.9004), glue, methods, purrr, rlang (>= 0.1.0), tibble (>= 1.3.0.9007), R6, utils

Suggests

covr, knitr, Lahman (>= 3.0-1), nycflights13, rmarkdown, RSQLite (>= 1.0.0), RMySQL, RPostgreSQL, testthat

Discussions