包索引 • duckdb - DuckDB 数据库

驱动

duckdb() duckdb_shutdown() duckdb_adbc() dbConnect(<duckdb_driver>) dbDisconnect(<duckdb_connection>): 连接到 DuckDB 数据库实例

dbDataType(<duckdb_driver>) dbGetInfo(<duckdb_driver>) dbIsValid(<duckdb_driver>) show(<duckdb_driver>): DuckDB 驱动类

连接

dbAppendTable(<duckdb_connection>) dbBegin(<duckdb_connection>) dbCommit(<duckdb_connection>) dbDataType(<duckdb_connection>) dbExistsTable(<duckdb_connection>,<ANY>) dbGetInfo(<duckdb_connection>) dbIsValid(<duckdb_connection>) dbListFields(<duckdb_connection>,<character>) dbListTables(<duckdb_connection>) dbQuoteIdentifier(<duckdb_connection>,<ANY>) dbQuoteLiteral(<duckdb_connection>) dbRemoveTable(<duckdb_connection>,<character>) dbRollback(<duckdb_connection>) dbSendQuery(<duckdb_connection>,<character>) dbWriteTable(<duckdb_connection>,<character>,<data.frame>) show(<duckdb_connection>): DuckDB 连接类

结果

duckdb_fetch_arrow() duckdb_fetch_record_batch() dbBind(<duckdb_result>) dbClearResult(<duckdb_result>) dbColumnInfo(<duckdb_result>) dbFetch(<duckdb_result>) dbGetInfo(<duckdb_result>) dbGetRowCount(<duckdb_result>) dbGetRowsAffected(<duckdb_result>) dbGetStatement(<duckdb_result>) dbHasCompleted(<duckdb_result>) dbIsValid(<duckdb_result>) show(<duckdb_result>): DuckDB 结果集

接口

tbl_file() tbl_function() tbl_query() simulate_duckdb(): dbplyr 的 DuckDB SQL 后端

duckdb_register() duckdb_unregister(): 将数据框注册为虚拟表

duckdb_register_arrow() duckdb_unregister_arrow() duckdb_list_arrow(): 将 Arrow 数据源注册为虚拟表

duckdb_read_csv(): 将 CSV 文件读入 DuckDB

duckdb_explain-class duckdb_explain print.duckdb_explain: DuckDB EXPLAIN 查询树