Package: duckdbfs 0.1.2.99
duckdbfs: High Performance Remote File System, Database and 'Geospatial' Access Using 'duckdb'
Provides friendly wrappers for creating 'duckdb'-backed connections to tabular datasets ('csv', parquet, etc) on local or remote file systems. This mimics the behaviour of "open_dataset" in the 'arrow' package, but in addition to 'S3' file system also generalizes to any list of 'http' URLs.
Authors:
duckdbfs_0.1.2.99.tar.gz
duckdbfs_0.1.2.99.zip(r-4.7)duckdbfs_0.1.2.99.zip(r-4.6)duckdbfs_0.1.2.99.zip(r-4.5)
duckdbfs_0.1.2.99.tgz(r-4.6-any)duckdbfs_0.1.2.99.tgz(r-4.5-any)
duckdbfs_0.1.2.99.tar.gz(r-4.7-any)duckdbfs_0.1.2.99.tar.gz(r-4.6-any)
duckdbfs_0.1.2.99.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
card.svg |card.png
duckdbfs/json (API)
NEWS
| # Install 'duckdbfs' in R: |
| install.packages('duckdbfs', repos = c('https://cboettig.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/cboettig/duckdbfs/issues
Pkgdown/docs site:https://cboettig.github.io
Last updated from:0b48916e7b. Checks:9 OK. Indexed: yes.
| Target | Result | Time | Files | Syslog |
|---|---|---|---|---|
| linux-devel-x86_64 | OK | 129 | ||
| source / vignettes | OK | 180 | ||
| linux-release-x86_64 | OK | 134 | ||
| macos-release-arm64 | OK | 103 | ||
| macos-oldrel-arm64 | OK | 98 | ||
| windows-devel | OK | 73 | ||
| windows-release | OK | 87 | ||
| windows-oldrel | OK | 82 | ||
| wasm-release | OK | 111 |
Exports:as_datasetas_viewcached_connectionclose_connectionduckdb_configduckdb_connectduckdb_extensionsduckdb_get_configduckdb_resetduckdb_s3_configduckdb_secretsload_h3load_spatialopen_datasetraw_sqlspatial_joinst_read_metato_geojsonto_h3jto_sfwrite_datasetwrite_geo
Dependencies:blobclicpp11DBIdbplyrdplyrduckdbfsgenericsgluelifecyclemagrittrpillarpkgconfigpurrrR6rlangstringistringrtibbletidyrtidyselectutf8vctrswithr
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| as_dataset | as_dataset |
| as_view | as_view |
| create a cachable duckdb connection | cached_connection duckdb_connect |
| close connection | close_connection |
| duckdb configuration | duckdb_config |
| show duckdb extensions | duckdb_extensions |
| duckdb reset configuration to default | duckdb_get_config |
| duckdb reset configuration to default | duckdb_reset |
| Configure S3 settings for database connection | duckdb_s3_config |
| duckdb secrets | duckdb_secrets |
| load the duckdb geospatial data plugin | load_h3 |
| load the duckdb geospatial data plugin | load_spatial |
| Open a dataset from a variety of sources | open_dataset |
| Run a raw SQL query and return a lazy table | raw_sql |
| spatial_join | spatial_join |
| read spatial metadata | st_read_meta |
| Write geojson using duckdb's native JSON writer | to_geojson |
| Write H3 hexagon data out as an h3j-compliant JSON file NOTE: the column containing H3 hashes must be named 'hexid' | to_h3j |
| to_json write data out as a JSON object | to_json |
| Convert output to sf object | to_sf |
| write_dataset | write_dataset |
| Write a spatial file with gdal | write_geo |
