Package: duckdf 0.2.1
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-unregister workflow. The underlying engine and its vectorised execution model are described in Raasveldt and Mühleisen (2019) <doi:10.1145/3299869.3320212>.
Authors:
duckdf_0.2.1.tar.gz
duckdf_0.2.1.zip(r-4.7-any)duckdf_0.2.1.zip(r-4.6-any)duckdf_0.2.1.zip(r-4.5-any)
duckdf_0.2.1.tgz(r-4.6-any)duckdf_0.2.1.tgz(r-4.5-any)
duckdf_0.2.1.tar.gz(r-4.7-any)duckdf_0.2.1.tar.gz(r-4.6-any)
duckdf_0.2.1.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION
card.svg |card.png
duckdf/json (API)
| # Install 'duckdf' in R: |
| install.packages('duckdf', repos = c('https://phillc73.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/phillc73/duckdf/issues
Last updated from:331754015e. Checks:9 OK. Indexed: yes.
| Target | Result | Time | Files | Syslog |
|---|---|---|---|---|
| linux-devel | OK | 122 | ||
| source / vignettes | OK | 176 | ||
| linux-release | OK | 111 | ||
| macos-release | OK | 135 | ||
| macos-oldrel | OK | 1797 | ||
| windows-devel | OK | 202 | ||
| windows-release | OK | 190 | ||
| windows-oldrel | OK | 164 | ||
| wasm-release | OK | 120 |
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| Clean up your duckdbs | cleanup |
| Query your dataframes with SQL | duckdf |
| List your registered views | duckdf_views |
| Gander at duckdbs | gander |
| Ingest data | ingest |
| Write persistent duckdb to disk | persist |