{ "_id": "6a5dc98a9baadeef8ab54971", "Package": "duckdbfs", "Title": "High Performance Remote File System, Database and 'Geospatial'\nAccess Using 'duckdb'", "Version": "0.1.2.99", "Authors@R": "c(person(\"Carl\", \"Boettiger\", , \"cboettig@gmail.com\", c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0002-1642-628X\")),\nperson(\"Michael D.\",\"Sumner\", role = c(\"ctb\"), email =\n\"mdsumner@gmail.com\", comment=c(ORCID = \"0000-0002-2471-7511\")))", "Description": "Provides friendly wrappers for creating 'duckdb'-backed\nconnections to tabular datasets ('csv', parquet, etc) on local\nor remote file systems. This mimics the behaviour of\n\"open_dataset\" in the 'arrow' package, but in addition to 'S3'\nfile system also generalizes to any list of 'http' URLs.", "License": "MIT + file LICENSE", "Encoding": "UTF-8", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.3.3", "URL": "https://github.com/cboettig/duckdbfs,\nhttps://cboettig.github.io/duckdbfs/", "BugReports": "https://github.com/cboettig/duckdbfs/issues", "Config/testthat/edition": "3", "Language": "en-US", "Config/pak/sysreqs": "cmake make libicu-dev libuv1-dev xz-utils", "Repository": "https://cboettig.r-universe.dev", "Date/Publication": "2026-04-21 22:41:56 UTC", "RemoteUrl": "https://github.com/cboettig/duckdbfs", "RemoteRef": "HEAD", "RemoteSha": "0b48916e7b4085d951318e2bd42d14c9433fa182", "NeedsCompilation": "no", "Packaged": { "Date": "2026-07-20 07:05:58 UTC", "User": "root" }, "Author": "Carl Boettiger [aut, cre] (ORCID:\n),\nMichael D. Sumner [ctb] (ORCID:\n)", "Maintainer": "Carl Boettiger ", "_user": "cboettig", "_type": "src", "_file": "duckdbfs_0.1.2.99.tar.gz", "_fileid": "https://r2.ropensci.org/8f5088066b25b91a05b36765e180411c8fa7ae8b2e5f07aa6ea9495dcfc19aca", "_filesize": 684102, "_sha256": "8f5088066b25b91a05b36765e180411c8fa7ae8b2e5f07aa6ea9495dcfc19aca", "_expires": "2026-10-28T07:08:56.000Z", "_created": "2026-07-20T07:05:58.000Z", "_published": "2026-07-20T07:08:58.624Z", "_jobs": [ { "job": 88291483806, "time": 137, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "8453329763" }, { "job": 88291483848, "time": 128, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "8453326791" }, { "job": 88291483840, "time": 115, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "8453322766" }, { "job": 88291483874, "time": 82, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "8453311745" }, { "job": 88290952292, "time": 203, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "8453284385" }, { "job": 88291483853, "time": 110, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "8453321243" }, { "job": 88291483843, "time": 82, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "8453312137" }, { "job": 88291483829, "time": 79, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "8453310992" }, { "job": 88291483841, "time": 80, "config": "windows-release", "r": "4.6.1", "check": "OK", "artifact": "8453311513" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/cboettig/actions/runs/29723365933", "_status": "success", "_upstream": "https://github.com/cboettig/duckdbfs", "_commit": { "id": "0b48916e7b4085d951318e2bd42d14c9433fa182", "author": "Carl Boettiger ", "committer": "GitHub ", "message": "Merge pull request #56 from cboettig/quick-wins\n\nQuick wins: fix #21, improve to_sf (#30/#18), docs for #44/#54", "time": 1776811316 }, "_maintainer": { "name": "Carl Boettiger", "email": "cboettig@gmail.com", "login": "cboettig", "mastodon": "@cboettig@ecoevo.social", "bluesky": "@cboettig.bsky.social", "orcid": "0000-0002-1642-628X", "description": "", "uuid": 222586 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.2", "role": "Depends" }, { "package": "DBI", "role": "Imports" }, { "package": "dbplyr", "role": "Imports" }, { "package": "dplyr", "role": "Imports" }, { "package": "duckdb", "version": ">= 1.1", "role": "Imports" }, { "package": "fs", "role": "Imports" }, { "package": "glue", "role": "Imports" }, { "package": "curl", "role": "Suggests" }, { "package": "sf", "role": "Suggests" }, { "package": "jsonlite", "role": "Suggests" }, { "package": "spelling", "role": "Suggests" }, { "package": "minioclient", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" } ], "_owner": "cboettig", "_selfowned": true, "_usedby": 10, "_updates": [ { "week": "2025-29", "n": 10 }, { "week": "2025-32", "n": 2 }, { "week": "2025-37", "n": 3 }, { "week": "2025-41", "n": 5 }, { "week": "2025-42", "n": 6 }, { "week": "2025-48", "n": 2 }, { "week": "2026-16", "n": 1 }, { "week": "2026-17", "n": 1 } ], "_tags": [], "_stars": 101, "_contributors": [ { "user": "cboettig", "count": 206, "uuid": 222586 }, { "user": "einarhjorleifsson", "count": 2, "uuid": 948860 }, { "user": "mdsumner", "count": 2, "uuid": 4107631 } ], "_userbio": { "uuid": 222586, "type": "user", "name": "Carl Boettiger", "followers": 1015 }, "_downloads": { "count": 2197, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/duckdbfs" }, "_devurl": "https://github.com/cboettig/duckdbfs", "_pkgdown": "https://cboettig.github.io/duckdbfs/", "_searchresults": 196, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/duckdbfs.html", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "LICENSE", "manual.pdf" ], "_homeurl": "https://github.com/cboettig/duckdbfs", "_realowner": "cboettig", "_cranurl": true, "_releases": [ { "version": "0.0.1", "date": "2023-08-09" }, { "version": "0.0.2", "date": "2023-09-07" }, { "version": "0.0.3", "date": "2023-10-19" }, { "version": "0.0.4", "date": "2024-02-28" }, { "version": "0.0.5", "date": "2024-08-17" }, { "version": "0.0.7", "date": "2024-08-29" }, { "version": "0.0.8", "date": "2024-12-09" }, { "version": "0.0.9", "date": "2024-12-17" }, { "version": "0.1.0", "date": "2025-04-04" }, { "version": "0.1.1", "date": "2025-07-17" }, { "version": "0.1.2", "date": "2025-10-12" } ], "_exports": [ "as_dataset", "as_view", "cached_connection", "close_connection", "duckdb_config", "duckdb_connect", "duckdb_extensions", "duckdb_get_config", "duckdb_reset", "duckdb_s3_config", "duckdb_secrets", "load_h3", "load_spatial", "open_dataset", "raw_sql", "spatial_join", "st_read_meta", "to_geojson", "to_h3j", "to_sf", "write_dataset", "write_geo" ], "_help": [ { "page": "as_dataset", "title": "as_dataset", "topics": [ "as_dataset" ] }, { "page": "as_view", "title": "as_view", "topics": [ "as_view" ] }, { "page": "cached_connection", "title": "create a cachable duckdb connection", "topics": [ "cached_connection", "duckdb_connect" ] }, { "page": "close_connection", "title": "close connection", "topics": [ "close_connection" ] }, { "page": "duckdb_config", "title": "duckdb configuration", "topics": [ "duckdb_config" ] }, { "page": "duckdb_extensions", "title": "show duckdb extensions", "topics": [ "duckdb_extensions" ] }, { "page": "duckdb_get_config", "title": "duckdb reset configuration to default", "topics": [ "duckdb_get_config" ] }, { "page": "duckdb_reset", "title": "duckdb reset configuration to default", "topics": [ "duckdb_reset" ] }, { "page": "duckdb_s3_config", "title": "Configure S3 settings for database connection", "topics": [ "duckdb_s3_config" ] }, { "page": "duckdb_secrets", "title": "duckdb secrets", "topics": [ "duckdb_secrets" ] }, { "page": "load_h3", "title": "load the duckdb geospatial data plugin", "topics": [ "load_h3" ] }, { "page": "load_spatial", "title": "load the duckdb geospatial data plugin", "topics": [ "load_spatial" ] }, { "page": "open_dataset", "title": "Open a dataset from a variety of sources", "topics": [ "open_dataset" ] }, { "page": "raw_sql", "title": "Run a raw SQL query and return a lazy table", "topics": [ "raw_sql" ] }, { "page": "spatial_join", "title": "spatial_join", "topics": [ "spatial_join" ] }, { "page": "st_read_meta", "title": "read spatial metadata", "topics": [ "st_read_meta" ] }, { "page": "to_geojson", "title": "Write geojson using duckdb's native JSON writer", "topics": [ "to_geojson" ] }, { "page": "to_h3j", "title": "Write H3 hexagon data out as an h3j-compliant JSON file NOTE: the column containing H3 hashes must be named 'hexid'", "topics": [ "to_h3j" ] }, { "page": "to_json", "title": "to_json write data out as a JSON object", "topics": [ "to_json" ] }, { "page": "to_sf", "title": "Convert output to sf object", "topics": [ "to_sf" ] }, { "page": "write_dataset", "title": "write_dataset", "topics": [ "write_dataset" ] }, { "page": "write_geo", "title": "Write a spatial file with gdal", "topics": [ "write_geo" ] } ], "_readme": "https://github.com/cboettig/duckdbfs/raw/HEAD/README.md", "_rundeps": [ "blob", "cli", "cpp11", "DBI", "dbplyr", "dplyr", "duckdb", "fs", "generics", "glue", "lifecycle", "magrittr", "pillar", "pkgconfig", "purrr", "R6", "rlang", "stringi", "stringr", "tibble", "tidyr", "tidyselect", "utf8", "vctrs", "withr" ], "_score": 9.018618743771237, "_indexed": true, "_nocasepkg": "duckdbfs", "_universes": [ "cboettig" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.2.99", "date": "2026-07-20T07:08:17.000Z", "distro": "resolute", "commit": "0b48916e7b4085d951318e2bd42d14c9433fa182", "fileid": "https://r2.ropensci.org/79808991bed70f939262fd3c787e76d4cd6fae627d6b215431ce2f56148ba292", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cboettig/actions/runs/29723365933" }, { "r": "4.6.1", "os": "linux", "version": "0.1.2.99", "date": "2026-07-20T07:08:06.000Z", "distro": "resolute", "commit": "0b48916e7b4085d951318e2bd42d14c9433fa182", "fileid": "https://r2.ropensci.org/7b254b82b1c516497b0415cc8ceaf1ba1c1e3c00f56bd526e901764d03174d51", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cboettig/actions/runs/29723365933" }, { "r": "4.5.3", "os": "mac", "version": "0.1.2.99", "date": "2026-07-20T07:07:51.000Z", "commit": "0b48916e7b4085d951318e2bd42d14c9433fa182", "fileid": "https://r2.ropensci.org/ca7e8a03c5f37f57ed69bbf2434fc751226e6804d62e9eb1f8dff83d278b647b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cboettig/actions/runs/29723365933" }, { "r": "4.6.1", "os": "mac", "version": "0.1.2.99", "date": "2026-07-20T07:07:25.000Z", "commit": "0b48916e7b4085d951318e2bd42d14c9433fa182", "fileid": "https://r2.ropensci.org/970d560d64757d08fa90ffba45d296a47c273155474cc1a229051864d4748f9e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cboettig/actions/runs/29723365933" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.2.99", "date": "2026-07-20T07:08:08.000Z", "commit": "0b48916e7b4085d951318e2bd42d14c9433fa182", "fileid": "https://r2.ropensci.org/a2095150c5c786eecc08c797221aaa873039d249699e20e397589f544cff6d5b", "status": "success", "buildurl": "https://github.com/r-universe/cboettig/actions/runs/29723365933" }, { "r": "4.7.0", "os": "win", "version": "0.1.2.99", "date": "2026-07-20T07:07:10.000Z", "commit": "0b48916e7b4085d951318e2bd42d14c9433fa182", "fileid": "https://r2.ropensci.org/438ca6d3d3eaab2e6ddb2d5441d2d50b3e491cbdc658b6e92c2bd2f2ee1783da", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cboettig/actions/runs/29723365933" }, { "r": "4.5.3", "os": "win", "version": "0.1.2.99", "date": "2026-07-20T07:07:18.000Z", "commit": "0b48916e7b4085d951318e2bd42d14c9433fa182", "fileid": "https://r2.ropensci.org/cd49b7339929207b63172a8a291a0dcd5fe1a9b0e0d5062ff643f5d59d8cde87", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cboettig/actions/runs/29723365933" }, { "r": "4.6.1", "os": "win", "version": "0.1.2.99", "date": "2026-07-20T07:07:22.000Z", "commit": "0b48916e7b4085d951318e2bd42d14c9433fa182", "fileid": "https://r2.ropensci.org/56776206aada3202d5b0b64801dd72ed9ba07489d25d438d57cb28f8a169c408", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cboettig/actions/runs/29723365933" } ] }