dbplyr 2.6.0 is here! This release leaned on Claude Code to clear a TON of smaller issues, freeing up time for the big stuff: brand-new ADBC and JDBC backends, new translations, and a new sql_dialect() to cleanly decouple connection from SQL dialect. Read more: opensource.posit.co/blog/2026-06...
dbplyr 2.6.0
dbplyr 2.6.0 is now on CRAN, with new ADBC and JDBC backends, IBM DB2 support, more translations, and a bunch of minor fixes and improvements.
opensource.posit.co
June 17, 2026 at 10:17 PM
dbplyr 2.6.0 is here! This release leaned on Claude Code to clear a TON of smaller issues, freeing up time for the big stuff: brand-new ADBC and JDBC backends, new translations, and a new sql_dialect() to cleanly decouple connection from SQL dialect. Read more: opensource.posit.co/blog/2026-06...
dbplyr 2.6.0 is out! 🎈 Streamline SQL generation for #RStats users.
New ADBC (Arrow buffers) and JDBC support, `bind_queries()` for UNION ALL, filter_out(), and 50+ fixes.
Learn more: opensource.posit.co/blog/2026-06...
New ADBC (Arrow buffers) and JDBC support, `bind_queries()` for UNION ALL, filter_out(), and 50+ fixes.
Learn more: opensource.posit.co/blog/2026-06...
dbplyr 2.6.0
dbplyr 2.6.0 is now on CRAN, with new ADBC and JDBC backends, IBM DB2 support, more translations, and a bunch of minor fixes and improvements.
opensource.posit.co
August 3, 2026 at 3:03 PM
dbplyr 2.6.0 is out! 🎈 Streamline SQL generation for #RStats users.
New ADBC (Arrow buffers) and JDBC support, `bind_queries()` for UNION ALL, filter_out(), and 50+ fixes.
Learn more: opensource.posit.co/blog/2026-06...
New ADBC (Arrow buffers) and JDBC support, `bind_queries()` for UNION ALL, filter_out(), and 50+ fixes.
Learn more: opensource.posit.co/blog/2026-06...
arrow + duckdb + dbplyr
Your life will change forever
Your life will change forever
February 21, 2025 at 7:43 PM
arrow + duckdb + dbplyr
Your life will change forever
Your life will change forever
I still read 100% of the code I write for R packages, where the stakes are generally high. It's really important for testthat, dbplyr, roxygen2 etc, to continue to be robust high-quality code.
September 21, 2026 at 7:35 PM
I still read 100% of the code I write for R packages, where the stakes are generally high. It's really important for testthat, dbplyr, roxygen2 etc, to continue to be robust high-quality code.
Tidier.jl brings…
#rstats
dplyr &
tidyr &
ggplot2 &
readr &
readxl &
writexl &
haven &
dbplyr &
purrr &
stringr &
forcats &
lubridate &
rvest &
janitor &
rio &
tidytext
…into #julialang
#rstats
dplyr &
tidyr &
ggplot2 &
readr &
readxl &
writexl &
haven &
dbplyr &
purrr &
stringr &
forcats &
lubridate &
rvest &
janitor &
rio &
tidytext
…into #julialang
March 27, 2025 at 11:33 AM
Tidier.jl brings…
#rstats
dplyr &
tidyr &
ggplot2 &
readr &
readxl &
writexl &
haven &
dbplyr &
purrr &
stringr &
forcats &
lubridate &
rvest &
janitor &
rio &
tidytext
…into #julialang
#rstats
dplyr &
tidyr &
ggplot2 &
readr &
readxl &
writexl &
haven &
dbplyr &
purrr &
stringr &
forcats &
lubridate &
rvest &
janitor &
rio &
tidytext
…into #julialang
People ask us, “when will TidierDB have feature parity with dbplyr?”
We like to ask, “when will dbplyr have feature parity with TidierDB?”
#julialang #rstats
😼
We like to ask, “when will dbplyr have feature parity with TidierDB?”
#julialang #rstats
😼
March 26, 2025 at 2:48 PM
People ask us, “when will TidierDB have feature parity with dbplyr?”
We like to ask, “when will dbplyr have feature parity with TidierDB?”
#julialang #rstats
😼
We like to ask, “when will dbplyr have feature parity with TidierDB?”
#julialang #rstats
😼
Sleep hit but @tidyverse.bsky.social now supports @duckdb.org package {duckplyr}
While I’m still using dbplyr as my main driver with some of the updates below I may finally transition to duckplyr.
Very cool work by the package developers.
#rstats
duckplyr.tidyverse.org/articles/duc...
While I’m still using dbplyr as my main driver with some of the updates below I may finally transition to duckplyr.
Very cool work by the package developers.
#rstats
duckplyr.tidyverse.org/articles/duc...
Interoperability with DuckDB and dbplyr
duckplyr.tidyverse.org
June 28, 2025 at 3:15 PM
Sleep hit but @tidyverse.bsky.social now supports @duckdb.org package {duckplyr}
While I’m still using dbplyr as my main driver with some of the updates below I may finally transition to duckplyr.
Very cool work by the package developers.
#rstats
duckplyr.tidyverse.org/articles/duc...
While I’m still using dbplyr as my main driver with some of the updates below I may finally transition to duckplyr.
Very cool work by the package developers.
#rstats
duckplyr.tidyverse.org/articles/duc...
States spend too much on clunky election night reporting. We just replaced ours using #rstats. dbplyr backend + reactable & leaflet viz + #quartopub site. Real magic happened with programmatic code chunks & targets pipeline done by @andrew.heiss.phd. #dataviz
results.voteidaho.gov
results.voteidaho.gov
November 20, 2024 at 7:11 PM
States spend too much on clunky election night reporting. We just replaced ours using #rstats. dbplyr backend + reactable & leaflet viz + #quartopub site. Real magic happened with programmatic code chunks & targets pipeline done by @andrew.heiss.phd. #dataviz
results.voteidaho.gov
results.voteidaho.gov
I would argue ibis is essentially dplyr and dbplyr in one. dbplyr (part of tidyverse) supports multiple database backends just like ibis.
November 20, 2024 at 5:31 AM
I would argue ibis is essentially dplyr and dbplyr in one. dbplyr (part of tidyverse) supports multiple database backends just like ibis.
We’re pleased to announce dbplyr 2.5.0!
dbplyr is a backend for dplyr that allows you to use a remote database as if it were a collection of local data frames. dbplyr 2.5.0 introduces new syntax for literal table identifiers.
Learn more on the tidyverse blog: www.tidyverse.org/blog/2024/04...
dbplyr is a backend for dplyr that allows you to use a remote database as if it were a collection of local data frames. dbplyr 2.5.0 introduces new syntax for literal table identifiers.
Learn more on the tidyverse blog: www.tidyverse.org/blog/2024/04...
dbplyr 2.5.0 - Tidyverse
dbplyr 2.5.0 brings improved syntax for referring to tables nested in schemas and catalogs along with a bunch of minor SQL generation improvements.
www.tidyverse.org
April 12, 2024 at 1:13 PM
We’re pleased to announce dbplyr 2.5.0!
dbplyr is a backend for dplyr that allows you to use a remote database as if it were a collection of local data frames. dbplyr 2.5.0 introduces new syntax for literal table identifiers.
Learn more on the tidyverse blog: www.tidyverse.org/blog/2024/04...
dbplyr is a backend for dplyr that allows you to use a remote database as if it were a collection of local data frames. dbplyr 2.5.0 introduces new syntax for literal table identifiers.
Learn more on the tidyverse blog: www.tidyverse.org/blog/2024/04...
Yup, TidierDB is a proud #JuliaLang cousin of dbplyr/ibis: tidierorg.github.io/TidierDB.jl/...
TidierDB.jl
TidierDB.jl
tidierorg.github.io
November 20, 2024 at 5:36 AM
Yup, TidierDB is a proud #JuliaLang cousin of dbplyr/ibis: tidierorg.github.io/TidierDB.jl/...
so many cool packages to explore and learn, almost done with my deep dives on DBI, dbplyr, sql, and S7.
probably will focus on shiny next but really tempted by httr2 and plumber2 as well.
probably will focus on shiny next but really tempted by httr2 and plumber2 as well.
November 30, 2025 at 7:06 PM
so many cool packages to explore and learn, almost done with my deep dives on DBI, dbplyr, sql, and S7.
probably will focus on shiny next but really tempted by httr2 and plumber2 as well.
probably will focus on shiny next but really tempted by httr2 and plumber2 as well.
Over 400 people are attending the {dbplyr} talk on Tuesday — that’s probably my biggest audience!
I’m doing a presentation to my company on {dbplyr}.
Any advice on how to structure it?
Eg should I explain dplyr first and its benefits then show it can be used with databases?
#rstats
Any advice on how to structure it?
Eg should I explain dplyr first and its benefits then show it can be used with databases?
#rstats
February 10, 2025 at 3:15 AM
Over 400 people are attending the {dbplyr} talk on Tuesday — that’s probably my biggest audience!
I say this all the time, but none of you can stop me from saying it again:
`{dbplyr}` is the single best idea to come out of the tidyverse (and the tidyverse is full of good ideas)
`{dbplyr}` is the single best idea to come out of the tidyverse (and the tidyverse is full of good ideas)
July 22, 2025 at 9:16 PM
I say this all the time, but none of you can stop me from saying it again:
`{dbplyr}` is the single best idea to come out of the tidyverse (and the tidyverse is full of good ideas)
`{dbplyr}` is the single best idea to come out of the tidyverse (and the tidyverse is full of good ideas)
🔥 Spark = Distributed, Big Data, clusters, in-memory processing.
🖥️ dplyr/dbplyr = SQL, single DB, pushes computations to the backend.
Spark pulls data to process, dbplyr pushes queries to the DB. #Rstats
🖥️ dplyr/dbplyr = SQL, single DB, pushes computations to the backend.
Spark pulls data to process, dbplyr pushes queries to the DB. #Rstats
December 20, 2024 at 1:26 AM
🔥 Spark = Distributed, Big Data, clusters, in-memory processing.
🖥️ dplyr/dbplyr = SQL, single DB, pushes computations to the backend.
Spark pulls data to process, dbplyr pushes queries to the DB. #Rstats
🖥️ dplyr/dbplyr = SQL, single DB, pushes computations to the backend.
Spark pulls data to process, dbplyr pushes queries to the DB. #Rstats
`dbplyr` is the GOAT
There is no table too large! (Assuming my employer pays their database bill)
There is no table too large! (Assuming my employer pays their database bill)
April 14, 2025 at 6:10 PM
`dbplyr` is the GOAT
There is no table too large! (Assuming my employer pays their database bill)
There is no table too large! (Assuming my employer pays their database bill)
the sql translation in dbplyr dbplyr.tidyverse.org/articles/tra...
Function translation
dbplyr.tidyverse.org
November 19, 2025 at 9:36 PM
the sql translation in dbplyr dbplyr.tidyverse.org/articles/tra...
In the 8 months since Tidier.jl became an umbrella package, it has expanded to 10 #JuliaLang 📦 re-implementing 14 #rstats 📦.
✅ dplyr ✅ dbplyr ✅ duckplyr ✅ haven ✅ forcats ✅ ggplot2 ✅ janitor ✅ lubridate ✅ readr ✅ rvest ✅ stringr ✅ tidyr ✅ tidytext ✅ writexl
tidierorg.github.io/Tidier.jl/dev/
✅ dplyr ✅ dbplyr ✅ duckplyr ✅ haven ✅ forcats ✅ ggplot2 ✅ janitor ✅ lubridate ✅ readr ✅ rvest ✅ stringr ✅ tidyr ✅ tidytext ✅ writexl
tidierorg.github.io/Tidier.jl/dev/
April 14, 2024 at 9:32 PM
In the 8 months since Tidier.jl became an umbrella package, it has expanded to 10 #JuliaLang 📦 re-implementing 14 #rstats 📦.
✅ dplyr ✅ dbplyr ✅ duckplyr ✅ haven ✅ forcats ✅ ggplot2 ✅ janitor ✅ lubridate ✅ readr ✅ rvest ✅ stringr ✅ tidyr ✅ tidytext ✅ writexl
tidierorg.github.io/Tidier.jl/dev/
✅ dplyr ✅ dbplyr ✅ duckplyr ✅ haven ✅ forcats ✅ ggplot2 ✅ janitor ✅ lubridate ✅ readr ✅ rvest ✅ stringr ✅ tidyr ✅ tidytext ✅ writexl
tidierorg.github.io/Tidier.jl/dev/
dbplyr release note:
```
New verb support
- bind_queries() makes it easy to combine multiple lazy queries using UNION ALL (#1342). It’s the dbplyr equivalent of dplyr::bind_rows().
```
ha ha sob wisclab.github.io/wisclabmisc/...
```
New verb support
- bind_queries() makes it easy to combine multiple lazy queries using UNION ALL (#1342). It’s the dbplyr equivalent of dplyr::bind_rows().
```
ha ha sob wisclab.github.io/wisclabmisc/...
July 6, 2026 at 2:37 PM
dbplyr release note:
```
New verb support
- bind_queries() makes it easy to combine multiple lazy queries using UNION ALL (#1342). It’s the dbplyr equivalent of dplyr::bind_rows().
```
ha ha sob wisclab.github.io/wisclabmisc/...
```
New verb support
- bind_queries() makes it easy to combine multiple lazy queries using UNION ALL (#1342). It’s the dbplyr equivalent of dplyr::bind_rows().
```
ha ha sob wisclab.github.io/wisclabmisc/...
It's not just those! Also applies to SQL (DBI and dbplyr), Java (rJava), Rust (extendr), Python (reticulate), Lua (Quarto extensions). Extensions are part of R! #rstats
December 3, 2025 at 12:39 PM
It's not just those! Also applies to SQL (DBI and dbplyr), Java (rJava), Rust (extendr), Python (reticulate), Lua (Quarto extensions). Extensions are part of R! #rstats
Anyone have an example of setting up and using @duckdb.org's ducklake in #rstats, yet? Preferably with dbplyr or duckplyr
June 5, 2025 at 10:22 PM
Anyone have an example of setting up and using @duckdb.org's ducklake in #rstats, yet? Preferably with dbplyr or duckplyr
I had to reinstall #rstats on my computer which means starting fresh with new packages -- below are the packages I use 90% of the time. Any other recommendations?
c(
"tidyverse"
,"tidymodels"
,"janitor"
,"here"
,"scales"
,"pak"
,"duckdb"
,"rlang"
,"DBI"
,"dbplyr"
,"devtools"
,"beepr"
,"S7"
,"cli"
)
c(
"tidyverse"
,"tidymodels"
,"janitor"
,"here"
,"scales"
,"pak"
,"duckdb"
,"rlang"
,"DBI"
,"dbplyr"
,"devtools"
,"beepr"
,"S7"
,"cli"
)
January 21, 2026 at 11:32 AM
I had to reinstall #rstats on my computer which means starting fresh with new packages -- below are the packages I use 90% of the time. Any other recommendations?
c(
"tidyverse"
,"tidymodels"
,"janitor"
,"here"
,"scales"
,"pak"
,"duckdb"
,"rlang"
,"DBI"
,"dbplyr"
,"devtools"
,"beepr"
,"S7"
,"cli"
)
c(
"tidyverse"
,"tidymodels"
,"janitor"
,"here"
,"scales"
,"pak"
,"duckdb"
,"rlang"
,"DBI"
,"dbplyr"
,"devtools"
,"beepr"
,"S7"
,"cli"
)
You can use SQL from within SAS and with a package in R. Or you can use dbplyr.
March 11, 2026 at 10:27 PM
You can use SQL from within SAS and with a package in R. Or you can use dbplyr.
say it with me!!!
duck👏🏼 plyr 👏🏼 doesn't 👏🏼 support 👏🏼 larger 👏🏼 than 👏🏼 memory 👏🏼 workloads 👏🏼 but 👏🏼 DuckDB 👏🏼 with 👏🏼 {dbplyr} 👏🏼 does
duck👏🏼 plyr 👏🏼 doesn't 👏🏼 support 👏🏼 larger 👏🏼 than 👏🏼 memory 👏🏼 workloads 👏🏼 but 👏🏼 DuckDB 👏🏼 with 👏🏼 {dbplyr} 👏🏼 does
December 6, 2024 at 11:44 PM
say it with me!!!
duck👏🏼 plyr 👏🏼 doesn't 👏🏼 support 👏🏼 larger 👏🏼 than 👏🏼 memory 👏🏼 workloads 👏🏼 but 👏🏼 DuckDB 👏🏼 with 👏🏼 {dbplyr} 👏🏼 does
duck👏🏼 plyr 👏🏼 doesn't 👏🏼 support 👏🏼 larger 👏🏼 than 👏🏼 memory 👏🏼 workloads 👏🏼 but 👏🏼 DuckDB 👏🏼 with 👏🏼 {dbplyr} 👏🏼 does