{ "_id": "6af7ac48f58eaab79920e55e", "Package": "duckdf", "Type": "Package", "Title": "SQL for Dataframes, but with Ducks", "Version": "0.2.1", "Authors@R": "person(\"Phill\", \"Clarke\", email = \"phill@mimosadev.org\",\nrole = c(\"aut\", \"cre\"))", "Description": "An SQL interface for R dataframes built on the DuckDB\nembedded analytical database. Dataframes are registered\ndirectly with an in-process DuckDB instance and queried with\nstandard SQL, so analyses can join, filter, aggregate and\nreshape R objects with SQL while results are returned as\ndataframes, without copying data to an external database\nserver. The package wraps the 'duckdb' R package with a\nDBI-compliant connection and provides a small, checked surface\nfor the common register-query-unnregister workflow. The\nunderlying engine and its vectorised execution model are\ndescribed in Raasveldt and Mühleisen (2019)\n.", "License": "AGPL-3", "Encoding": "UTF-8", "URL": "https://github.com/phillc73/duckdf", "BugReports": "https://github.com/phillc73/duckdf/issues", "Config/testthat/edition": "3", "Config/roxygen2/version": "8.1.1", "NeedsCompilation": "no", "Packaged": { "Date": "2026-11-14 00:29:59 UTC", "User": "root" }, "Author": "Phill Clarke [aut, cre]", "Maintainer": "Phill Clarke ", "Repository": "https://cran.r-universe.dev", "Date/Publication": "2026-11-13 17:10:14 UTC", "RemoteUrl": "https://github.com/cran/duckdf", "RemoteRef": "HEAD", "RemoteSha": "e0be8640e0527bb49f24b5b9446101e9cece6157", "_user": "cran", "_type": "src", "_file": "duckdf_0.2.1.tar.gz", "_fileid": "https://r2.ropensci.org/fc66e86c07f498928fc2e0f2293fc352667719a6b24c4e019a8119a92a94c39e", "_filesize": 131566, "_sha256": "fc66e86c07f498928fc2e0f2293fc352667719a6b24c4e019a8119a92a94c39e", "_expires": "2027-02-22T00:33:10.000Z", "_created": "2026-11-14T00:29:59.000Z", "_published": "2026-11-14T00:33:12.489Z", "_upstream": "https://github.com/cran/duckdf", "_status": "success", "_maintainer": { "name": "Phill Clarke", "email": "phill@mimosadev.org", "login": "phillc73", "description": "Usage limit reached", "uuid": 815126 }, "_jobs": [ { "job": 132260498846, "time": 122, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "14088758402" }, { "job": 132260498983, "time": 126, "config": "linux-release-x86_64", "r": "4.6.2", "check": "OK", "artifact": "14088593739" }, { "job": 132259322241, "time": 190, "config": "source", "r": "4.6.2", "check": "OK", "artifact": "14089206897" }, { "job": 132260498803, "time": 98, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "14089386670" }, { "job": 132260498840, "time": 157, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "14088303721" }, { "job": 132260498819, "time": 148, "config": "windows-release-x86_64", "r": "4.6.2", "check": "OK", "artifact": "14088738636" } ], "_buildurl": "https://github.com/r-universe/cran/actions/runs/43534234037", "_commit": { "id": "e0be8640e0527bb49f24b5b9446101e9cece6157", "author": "Phill Clarke ", "committer": "cran-robot ", "message": "version 0.2.1\n", "time": 1794589814 }, "_distro": "resolute", "_host": "GitHub-Actions", "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.2.0", "role": "Depends" }, { "package": "DBI", "version": ">= 1.1.3", "role": "Imports" }, { "package": "checkmate", "role": "Imports" }, { "package": "duckdb", "version": ">= 1.5.6", "role": "Imports" }, { "package": "jsonlite", "role": "Imports" }, { "package": "bench", "role": "Suggests" }, { "package": "data.table", "role": "Suggests" }, { "package": "dbplyr", "role": "Suggests" }, { "package": "dplyr", "role": "Suggests" }, { "package": "duckplyr", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "sqldf", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" }, { "package": "tibble", "role": "Suggests" }, { "package": "withr", "role": "Suggests" } ], "_owner": "cran", "_selfowned": false, "_usedby": 0, "_updates": [ { "week": "2026-46", "n": 1 } ], "_tags": [ { "name": "0.2.1", "date": "2026-11-13" } ], "_stars": 0, "_contributors": [ { "user": "phillc73", "count": 1, "uuid": 815126 } ], "_userbio": { "uuid": 6899542, "type": "organization", "name": "cran", "followers": 637, "description": "Unofficial read-only mirror of all CRAN R packages" }, "_downloads": { "count": 0, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/duckdf" }, "_devurl": "https://github.com/phillc73/duckdf", "_searchresults": 1, "_rbuild": "4.6.2", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/duckdf.html", "extra/manual.pdf", "extra/readme.html", "extra/readme.md" ], "_cranurl": false, "_releases": [ { "version": "0.2.1", "date": "2026-11-13" } ], "_exports": [ "cleanup", "duckdf", "duckdf_views", "gander", "ingest", "persist" ], "_help": [ { "page": "cleanup", "title": "Clean up your duckdbs", "topics": [ "cleanup" ] }, { "page": "duckdf", "title": "Query your dataframes with SQL", "topics": [ "duckdf" ] }, { "page": "duckdf_views", "title": "List your registered views", "topics": [ "duckdf_views" ] }, { "page": "gander", "title": "Gander at duckdbs", "topics": [ "gander" ] }, { "page": "ingest", "title": "Ingest data", "topics": [ "ingest" ] }, { "page": "persist", "title": "Write persistent duckdb to disk", "topics": [ "persist" ] } ], "_readme": "https://github.com/cran/duckdf/raw/HEAD/README.md", "_rundeps": [ "backports", "checkmate", "DBI", "duckdb", "jsonlite" ], "_score": 1.6989700043360187, "_indexed": true, "_nocasepkg": "duckdf", "_universes": [ "cran", "phillc73" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.2.1", "date": "2026-11-14T00:32:03.000Z", "distro": "resolute", "commit": "e0be8640e0527bb49f24b5b9446101e9cece6157", "fileid": "https://r2.ropensci.org/e52939a7c28a07c459150e59887485357037a85e4c7d33cfc8863595654df997", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/43534234037" }, { "r": "4.6.2", "os": "linux", "version": "0.2.1", "date": "2026-11-14T00:32:11.000Z", "distro": "resolute", "commit": "e0be8640e0527bb49f24b5b9446101e9cece6157", "fileid": "https://r2.ropensci.org/8fb8cc9e1332fa6fa4edb93a930478ffc83b7a68a7626fcfc576b518f46315b3", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/43534234037" }, { "r": "4.6.0", "os": "wasm", "version": "0.2.1", "date": "2026-11-14T00:31:53.000Z", "commit": "e0be8640e0527bb49f24b5b9446101e9cece6157", "fileid": "https://r2.ropensci.org/ce34bcae2d518e6feb57acd5bdc74fe3438916da3d852480809ccd29b46bb356", "status": "success", "buildurl": "https://github.com/r-universe/cran/actions/runs/43534234037" }, { "r": "4.7.0", "os": "win", "version": "0.2.1", "date": "2026-11-14T00:31:57.000Z", "commit": "e0be8640e0527bb49f24b5b9446101e9cece6157", "fileid": "https://r2.ropensci.org/a2a8dbbbd83fa51f2cc079aa13fb295f397e4cfc87831173bab4ff4a7e2e24b5", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/43534234037" }, { "r": "4.6.2", "os": "win", "version": "0.2.1", "date": "2026-11-14T00:32:07.000Z", "commit": "e0be8640e0527bb49f24b5b9446101e9cece6157", "fileid": "https://r2.ropensci.org/8f8fe0da8ddcaa2b177686712fcfa74a9df5aaae56199def7ba464b272902a84", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/43534234037" } ] }