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) .


Reference manual

It appears you don't have a PDF plugin for this browser. You can click here to download the reference manual.

install.packages("duckdf")

0.2.1 by Phill Clarke, 5 hours ago


https://github.com/phillc73/duckdf


Report a bug at https://github.com/phillc73/duckdf/issues


Browse source code at https://github.com/cran/duckdf


Authors: Phill Clarke [aut, cre]


Documentation:   PDF Manual  


AGPL-3 license


Imports DBI, checkmate, duckdb, jsonlite

Suggests bench, data.table, dbplyr, dplyr, duckplyr, knitr, rmarkdown, sqldf, testthat, tibble, withr


See at CRAN