duckdf: SQL for Dataframes, but with Ducks
An SQL interface for R dataframes built on the DuckDB embedded
analytical database. Dataframes are registered directly with an in-process
DuckDB instance and queried with standard SQL, so analyses can join,
filter, aggregate and reshape R objects with SQL while results are
returned as dataframes, without copying data to an external database
server. The package wraps the 'duckdb' R package with a DBI-compliant
connection and provides a small, checked surface for the common
register-query-unnregister workflow. The underlying engine and its
vectorised execution model are described in Raasveldt and Mühleisen
(2019) <doi:10.1145/3299869.3320212>.
| Version: |
0.2.1 |
| Depends: |
R (≥ 4.2.0) |
| Imports: |
DBI (≥ 1.1.3), checkmate, duckdb (≥ 1.5.6), jsonlite |
| Suggests: |
bench, data.table, dbplyr, dplyr, duckplyr, knitr, rmarkdown, sqldf, testthat (≥ 3.0.0), tibble, withr |
| Published: |
2026-11-13 |
| DOI: |
10.32614/CRAN.package.duckdf (may not be active yet) |
| Author: |
Phill Clarke [aut, cre] |
| Maintainer: |
Phill Clarke <phill at mimosadev.org> |
| BugReports: |
https://github.com/phillc73/duckdf/issues |
| License: |
AGPL-3 |
| URL: |
https://github.com/phillc73/duckdf |
| NeedsCompilation: |
no |
| Materials: |
README |
| CRAN checks: |
duckdf results |
Documentation:
Downloads:
Linking:
Please use the canonical form
https://CRAN.R-project.org/package=duckdf
to link to this page.