Package: duckdb 1.0.0

Kirill Müller

duckdb: DBI Package for the DuckDB Database Management System

The DuckDB project is an embedded analytical data management system with support for the Structured Query Language (SQL). This package includes all of DuckDB and a R Database Interface (DBI) connector.

Authors:Hannes Mühleisen [aut], Mark Raasveldt [aut], Kirill Müller [cre], Stichting DuckDB Foundation [cph], Apache Software Foundation [cph], PostgreSQL Global Development Group [cph], The Regents of the University of California [cph], Cameron Desrochers [cph], Victor Zverovich [cph], RAD Game Tools [cph], Valve Software [cph], Rich Geldreich [cph], Tenacious Software LLC [cph], The RE2 Authors [cph], Google Inc. [cph], Facebook Inc. [cph], Steven G. Johnson [cph], Jiahao Chen [cph], Tony Kelman [cph], Jonas Fonseca [cph], Lukas Fittl [cph], Salvatore Sanfilippo [cph], Art.sy, Inc. [cph], Oran Agra [cph], Redis Labs, Inc. [cph], Melissa O'Neill [cph], PCG Project contributors [cph]

duckdb_1.0.0.tar.gz
duckdb_1.0.0.zip(r-4.5)duckdb_1.0.0.zip(r-4.4)duckdb_1.0.0.zip(r-4.3)
duckdb_1.0.0.tgz(r-4.4-arm64)duckdb_1.0.0.tgz(r-4.4-x86_64)duckdb_1.0.0.tgz(r-4.3-arm64)duckdb_1.0.0.tgz(r-4.3-x86_64)
duckdb_1.0.0.tar.gz(r-4.5-noble)duckdb_1.0.0.tar.gz(r-4.4-noble)
duckdb_1.0.0.tgz(r-4.4-emscripten)duckdb_1.0.0.tgz(r-4.3-emscripten)
duckdb.pdf |duckdb.html✨
duckdb/json (API)
NEWS

# Install duckdb in R:

install.packages('duckdb', repos = c('https://r-multiverse.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/duckdb/duckdb-r/issues

Uses libs:

c++– GNU Standard C++ Library v3

On CRAN:

database duckdb olap

46 exports 103 stars 6.11 score 1 dependencies 40 dependents 14.9k downloads

Last updated 28 days agofrom:242b805ad4 (via v1.0.0)

Exports:dbAppendTable dbBegin dbBind dbClearResult dbColumnInfo dbCommit dbConnect dbDataType dbDisconnect dbExistsTable dbFetch dbGetInfo dbGetRowCount dbGetRowsAffected dbGetStatement dbHasCompleted dbIsValid dbListFields dbListTables dbQuoteIdentifier dbQuoteLiteral dbRemoveTable dbRollback dbSendQuery dbWriteTable duckdb duckdb_adbc duckdb_fetch_arrow duckdb_fetch_record_batch duckdb_get_substrait duckdb_get_substrait_json duckdb_list_arrow duckdb_prepare_substrait duckdb_prepare_substrait_json duckdb_read_csv duckdb_register duckdb_register_arrow duckdb_shutdown duckdb_unregister duckdb_unregister_arrow read_csv_duckdb show simulate_duckdb tbl_file tbl_query translate_duckdb

Dependencies:DBI

Help page	Topics
DuckDB SQL backend for dbplyr	simulate_duckdb tbl_file tbl_query translate_duckdb
Connect to a DuckDB database instance	dbConnect,duckdb_driver-method dbConnect__duckdb_driver dbDisconnect,duckdb_connection-method dbDisconnect__duckdb_connection duckdb duckdb_adbc duckdb_shutdown
DuckDB EXPLAIN query tree	duckdb_explain duckdb_explain-class print.duckdb_explain
Get the Substrait plan for a SQL query Transforms a SQL query into a raw vector containing the serialized Substrait query blob	duckdb_get_substrait
Get the Substrait plan for a SQL query in the JSON format Transforms a SQL query into a vector containing the serialized Substrait query JSON	duckdb_get_substrait_json
Query DuckDB using Substrait Method for interpreting a Substrait BLOB plan as a DuckDB Query Plan It interprets and executes the query.	duckdb_prepare_substrait
Query DuckDB using Substrait Method for interpreting a Substrait JSON plan as a DuckDB Query Plan It interprets and executes the query.	duckdb_prepare_substrait_json
Reads a CSV file into DuckDB	duckdb_read_csv
Register a data frame as a virtual table	duckdb_register duckdb_unregister
Register an Arrow data source as a virtual table	duckdb_list_arrow duckdb_register_arrow duckdb_unregister_arrow

Package: duckdb 1.0.0

duckdb: DBI Package for the DuckDB Database Management System

Citation

Development and contributors

Readme and manuals

Help Manual

Usage by other packages (reverse dependencies)