The hardware and bandwidth for this mirror is donated by dogado GmbH, the Webhosting and Full Service-Cloud Provider. Check out our Wordpress Tutorial.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]dogado.de.

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:

Reference manual: duckdf.html , duckdf.pdf

Downloads:

Package source: duckdf_0.2.1.tar.gz
Windows binaries: r-devel: not available, r-release: duckdf_0.2.1.zip, r-oldrel: duckdf_0.2.1.zip
macOS binaries: r-release (arm64): duckdf_0.2.1.tgz, r-oldrel (arm64): duckdf_0.2.1.tgz, r-release (x86_64): duckdf_0.2.1.tgz, r-oldrel (x86_64): not available

Linking:

Please use the canonical form https://CRAN.R-project.org/package=duckdf to link to this page.

These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.
Health stats visible at Monitor.