Become an expert in R — Interactive courses, Cheat Sheets, certificates and more!

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.

Functions (69)

arrange.tbl_lazy

Arrange rows by column values

backend-access

Backend: MS Access

backend-hana

Backend: SAP HANA

backend-hive

Backend: Hive

backend-impala

Backend: Impala

backend-mssql

Backend: SQL server

backend-mysql

Backend: MySQL/MariaDB

backend-odbc

Backend: ODBC

backend-oracle

Backend: Oracle

backend-postgres

Backend: PostgreSQL

backend-redshift

Backend: Redshift

backend-snowflake

Backend: Snowflake

backend-sqlite

Backend: SQLite

backend-teradata

Backend: Teradata

build_sql

Build a SQL string.

collapse.tbl_sql

Compute results of a query

complete.tbl_lazy

Complete a SQL table with missing combinations of data

copy_to.src_sql

Copy a local data frame to a remote database

count.tbl_lazy

Count observations by group

db-io

Database I/O generics

db-misc

Miscellaneous database generics

db-quote

SQL escaping/quoting generics

db-sql

SQL generation generics

dbplyr-package

dbplyr: A 'dplyr' Back End for Databases

dbplyr-slice

Subset rows using their positions

dbplyr_uncount

"Uncount" a database table

distinct.tbl_lazy

Subset distinct/unique rows

do.tbl_sql

Perform arbitrary computation on remote backend

escape

Escape/quote a string.

expand.tbl_lazy

Expand SQL tables to include all possible combinations of values

fill.tbl_lazy

Fill in missing values with previous or next value

filter.tbl_lazy

Subset rows using column values

group_by.tbl_lazy

Group by one or more variables

head.tbl_lazy

Subset the first rows

ident

Flag a character vector as SQL identifiers

ident_q

Declare a identifer as being pre-quoted.

in_schema

Refer to a table in a schema

intersect.tbl_lazy

SQL set operations

join.tbl_sql

Join SQL tables

lahman

Cache and retrieve an src_sqlite of the Lahman baseball database.

lazy_ops

Lazy operations

memdb_frame

Create a database table in temporary in-memory database.

mutate.tbl_lazy

Create, modify, and delete columns

named_commas

Provides comma-separated string out of the parameters

nycflights13

Database versions of the nycflights13 data

partial_eval

Partially evaluate an expression.

pivot_longer.tbl_lazy

Pivot data from wide to long

pivot_wider.tbl_lazy

Pivot data from long to wide

pull.tbl_sql

Extract a single column

reexports

Objects exported from other packages

remote_name

Metadata about a remote table

replace_na.tbl_lazy

Replace NAs with specified values

select.tbl_lazy

Subset, rename, and reorder columns using their names

simulate_dbi

Simulate database connections

sql

SQL escaping.

sql_build

Build and render SQL from a sequence of lazy operations

sql_expr

Generate SQL from R expressions

sql_quote

Helper function for quoting sql elements.

sql_variant

Create an sql translator

src_dbi

Database src

src_sql

Create a "sql src" object

summarise.tbl_lazy

Summarise each group to one row

tbl.src_dbi

Use dplyr verbs with a remote database table

tbl_lazy

Create a local lazy tibble

tbl_sql

Create an SQL tbl (abstract)

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

dbplyr

A 'dplyr' Back End for Databases

v2.1.1

MIT + file LICENSE

Authors

Hadley Wickham [aut, cre], Maximilian Girlich [aut], Edgar Ruiz [aut], RStudio [cph, fnd]

Initial release

dbplyr

Functions (69)

dbplyr

We don't support your browser anymore