{ "_id": "6af855bc535793c85332e06e", "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-unregister 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", "Repository": "https://phillc73.r-universe.dev", "Date/Publication": "2026-11-13 19:29:39 UTC", "RemoteUrl": "https://github.com/phillc73/duckdf", "RemoteRef": "HEAD", "RemoteSha": "331754015e1908ffe954eb73d1d9a77f347db8c4", "NeedsCompilation": "no", "Packaged": { "Date": "2026-11-14 12:05:39 UTC", "User": "root" }, "Author": "Phill Clarke [aut, cre]", "Maintainer": "Phill Clarke ", "_user": "phillc73", "_type": "src", "_file": "duckdf_0.2.1.tar.gz", "_fileid": "https://r2.ropensci.org/ffbb6c312a64f701e5a746bec2623046cb877f9e2719576521da35e8155ea0ef", "_filesize": 130870, "_sha256": "ffbb6c312a64f701e5a746bec2623046cb877f9e2719576521da35e8155ea0ef", "_expires": "2027-02-22T12:36:10.000Z", "_created": "2026-11-14T12:05:39.000Z", "_published": "2026-11-14T12:36:12.150Z", "_upstream": "https://github.com/phillc73/duckdf", "_status": "success", "_maintainer": { "name": "Phill Clarke", "email": "phill@mimosadev.org", "login": "phillc73", "description": "Usage limit reached", "uuid": 815126 }, "_jobs": [ { "job": 132441899133, "time": 122, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "14113725451" }, { "job": 132441899179, "time": 111, "config": "linux-release-x86_64", "r": "4.6.2", "check": "OK", "artifact": "14112658441" }, { "job": 132441899243, "time": 1797, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "14114530165" }, { "job": 132441899171, "time": 135, "config": "macos-release-arm64", "r": "4.6.2", "check": "OK", "artifact": "14113431505" }, { "job": 132441176252, "time": 176, "config": "source", "r": "4.6.2", "check": "OK", "artifact": "14113132025" }, { "job": 132441899141, "time": 120, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "14113521123" }, { "job": 132441899221, "time": 202, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "14113690648" }, { "job": 132441899183, "time": 164, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "14112987750" }, { "job": 132441899226, "time": 190, "config": "windows-release-x86_64", "r": "4.6.2", "check": "OK", "artifact": "14113505790" } ], "_buildurl": "https://github.com/r-universe/phillc73/actions/runs/43592865870", "_commit": { "id": "331754015e1908ffe954eb73d1d9a77f347db8c4", "author": "Phill Clarke ", "committer": "Phill Clarke ", "message": "fix: CRAN 0.2.1 round - Description, typo, README install routes\n\nDescription expanded for CRAN review; unnregister typo fixed; redundant\nLICENSE dropped; README gains the CRAN and remotes install routes.\n", "time": 1794598179 }, "_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": "phillc73", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2026-42", "n": 33 }, { "week": "2026-46", "n": 1 } ], "_tags": [], "_topics": [ "duckdb", "duckdb-database", "ducks", "sql" ], "_stars": 48, "_contributors": [ { "user": "phillc73", "count": 34, "uuid": 815126 } ], "_userbio": { "uuid": 815126, "type": "user", "name": "Phill", "followers": 79, "description": "Usage limit reached" }, "_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" ], "_homeurl": "https://github.com/phillc73/duckdf", "_realowner": "phillc73", "_cranurl": true, "_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/phillc73/duckdf/raw/HEAD/README.md", "_rundeps": [ "backports", "checkmate", "DBI", "duckdb", "jsonlite" ], "_score": 4.681241237375588, "_indexed": true, "_nocasepkg": "duckdf", "_universes": [ "phillc73" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.2.1", "date": "2026-11-14T12:07:47.000Z", "distro": "resolute", "commit": "331754015e1908ffe954eb73d1d9a77f347db8c4", "fileid": "https://r2.ropensci.org/6789030ad7219db5058d8b5f29ff7972cfc89362afe6d5f8c51a82024e3ff594", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/phillc73/actions/runs/43592865870" }, { "r": "4.6.2", "os": "linux", "version": "0.2.1", "date": "2026-11-14T12:07:35.000Z", "distro": "resolute", "commit": "331754015e1908ffe954eb73d1d9a77f347db8c4", "fileid": "https://r2.ropensci.org/e11a8cf6f4b9d97aa742c728ad384f323ca73b6d811d22591b8099d1b28b72c1", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/phillc73/actions/runs/43592865870" }, { "r": "4.5.3", "os": "mac", "version": "0.2.1", "date": "2026-11-14T12:35:11.000Z", "commit": "331754015e1908ffe954eb73d1d9a77f347db8c4", "fileid": "https://r2.ropensci.org/4352baa98142b707da787eeb596b0f03d030beffbfe244f7da586c27145bc2a9", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/phillc73/actions/runs/43592865870" }, { "r": "4.6.2", "os": "mac", "version": "0.2.1", "date": "2026-11-14T12:07:35.000Z", "commit": "331754015e1908ffe954eb73d1d9a77f347db8c4", "fileid": "https://r2.ropensci.org/a6a406710639abf77bee3582dd3d39f5f53190c4904c1d43a23fd9753013efb3", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/phillc73/actions/runs/43592865870" }, { "r": "4.6.0", "os": "wasm", "version": "0.2.1", "date": "2026-11-14T12:07:53.000Z", "commit": "331754015e1908ffe954eb73d1d9a77f347db8c4", "fileid": "https://r2.ropensci.org/7673fa396ca2daafda10d4aa7925a03c2613ccc105ad21d701883567a463a142", "status": "success", "buildurl": "https://github.com/r-universe/phillc73/actions/runs/43592865870" }, { "r": "4.7.0", "os": "win", "version": "0.2.1", "date": "2026-11-14T12:08:05.000Z", "commit": "331754015e1908ffe954eb73d1d9a77f347db8c4", "fileid": "https://r2.ropensci.org/13f2b8b46b37687fcc8201039494e5bddb1d5b918c40082bbbc0af8a1e6f6367", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/phillc73/actions/runs/43592865870" }, { "r": "4.5.3", "os": "win", "version": "0.2.1", "date": "2026-11-14T12:07:31.000Z", "commit": "331754015e1908ffe954eb73d1d9a77f347db8c4", "fileid": "https://r2.ropensci.org/9c9fa1fa49075dcf269f027cde4a6a977d9f93e11d036190fbe1f021fe1bf9b5", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/phillc73/actions/runs/43592865870" }, { "r": "4.6.2", "os": "win", "version": "0.2.1", "date": "2026-11-14T12:08:06.000Z", "commit": "331754015e1908ffe954eb73d1d9a77f347db8c4", "fileid": "https://r2.ropensci.org/32ee15ee3096a059510f9e5e2194091211537e09f7bc2b69d085507483537e71", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/phillc73/actions/runs/43592865870" } ] }