install.packages("duckdb")
install.packages("duckdb", repos = c("https://duckdb.r-universe.dev", "https://cloud.r-project.org"))
# install.packages("pak", repos = sprintf("https://r-lib.github.io/p/pak/stable/%s/%s/%s", .Platform$pkgType, R.Version()$os, R.Version()$arch))
pak::pak("duckdb/duckdb-r")
See the R API in the DuckDB documentation.
To build the bleeding edge of duckdb-r, you can clone this repository and run
~duckdb-r: R CMD INSTALL .
If you wish to test new duckdb functionality with duckdb-r, make sure your clones of duckdb-r
and duckdb
share the same parent directory.
Then run the following commands
~ (cd duckdb && git checkout {{desired_branch}})
~ (cd ducdkb-r && ./vendor.sh)
~ (cd duckdb-r && R CMD INSTALL .)
It helps if both the duckdb directory and duckdb-r directory are clean. If you encounter linker errors, merge both duckdb-r and duckdb with their respective main branches.
To build the R package, you first need to install the dependencies:
# install.packages("pak", repos = sprintf("https://r-lib.github.io/p/pak/stable/%s/%s/%s", .Platform$pkgType, R.Version()$os, R.Version()$arch))
pak::pak()
If you wish to build or add extensions to the R package you first need to build duckdb with the extension_static_build
flag.
The following commands allow you to add the httpfs
extension to a DuckDB R build.
See the extension ReadMe for more information about extensions
cd duckdb/
EXTENSION_STATIC_BUILD=1 make
Then in R, run:
library(duckdb)
con <- DBI::dbConnect(duckdb(config=list('allow_unsigned_extensions'='true')))
dbExecute(con, "LOAD '{{path_to_duckdb}}/build/release/extension/httpfs/httpfs.duckdb_extension'")
For more information about using extensions, see the documentation on extensions. For instructions on building them, see extension README.
Any scripts or data that you put into this service are public.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.