On the recordRead 5 Oct 202614 facts
dbplyr
Plans and prices
dbplyr
Free
Open-source R package · MIT license
Read 5 Oct 2026 · dbplyr.tidyverse.org
On the record
- Connection interface
- Database connections are coordinated through DBI, and users install a backend package for the database they want to connect to.dbplyr.tidyverse.org · read 5 Oct 2026
- Database backends
- The package index lists built-in dialects or backends including SQLite, PostgreSQL, MySQL/MariaDB, SQL Server, Oracle, Snowflake, Redshift, Spark SQL, Teradata, Hive, and others.dbplyr.tidyverse.org · read 5 Oct 2026
- Inspect queries
- The package provides functions to show generated SQL and query plans.dbplyr.tidyverse.org · read 5 Oct 2026
- Installation
- The documentation gives installation commands for dbplyr from CRAN and for the development version from GitHub.dbplyr.tidyverse.org · read 5 Oct 2026
- Intended users
- The documentation describes using dbplyr when data already lives in a database or is too large to fit in memory at once.dbplyr.tidyverse.org · read 5 Oct 2026
- Lazy queries
- Operations on remote tables are delayed and sent to the database when results are requested.dbplyr.tidyverse.org · read 5 Oct 2026
- License
- The dbplyr site identifies the package license as MIT.dbplyr.tidyverse.org · read 5 Oct 2026
- Maintainers
- The site lists Hadley Wickham as author and maintainer and names Maximilian Girlich and Edgar Ruiz as authors.dbplyr.tidyverse.org · read 5 Oct 2026
- Maker history
- Posit says RStudio, now Posit, was founded in 2009 to create open-source software for data scientists.posit.co · read 5 Oct 2026
- Purpose
- dbplyr is the database backend for dplyr and converts dplyr code into SQL for remote database tables.dbplyr.tidyverse.org · read 5 Oct 2026
- Requirements
- Using dbplyr with a database requires a DBI backend package for that database.dbplyr.tidyverse.org · read 5 Oct 2026
- SQL scope
- dbplyr focuses on generating SELECT statements and does not translate all of SQL.dbplyr.tidyverse.org · read 5 Oct 2026
- Support
- The site links users to a getting-help page and a GitHub issue tracker for reporting bugs.dbplyr.tidyverse.org · read 5 Oct 2026
- Supported operations
- Documented operations include filtering, selecting, mutating, grouping, summarising, joins, set operations, and row modifications.dbplyr.tidyverse.org · read 5 Oct 2026
