overriding the automatic resolution.One of: Cannot be combined with home.Applied only when the database instance is created;see the ‘Database instances and driver reuse’ section. allow_extensions Whether this driver may load DuckDB extensions (INSTALL / LOAD).One of: NULL (the default) – decide automatically.Extensions are enabled， geometry columns are returned as a list of raw vectors containing WKB data.If "wk" is selected， arrays are returned as a column matrix. Each array is one row in the matrix. geometry How geometry columns should be returned. There are two options: "blob" and "wk".If "blob" is selected，except on an affected Linux build (one not compiled with libstdc++)， MAP columns are returned as a vctrs::list_of() whose ptype is adata.frame(key = K， MAP columns are returned as a list of data frames withkey and value columns.If "list_of" is selected， this is only applied when the database file is opened for the first time.Subsequent connections (via the same drv object or a drv object pointing to the same path)cannot apply it， see for the possible options.These flags are only applied when the database object is instantiated.Subsequent connections cannot apply them， and fail rather than ignoring it. bigint How 64-bit integers should be returned. There are two options: "numeric" and "integer64".If "numeric" is selected。
creating it if needed.Cannot be combined with shared_home.Applied only when the database instance is created;see the ‘Database instances and driver reuse’ section. shared_home Opt in or out of the shared ~/.duckdb location。
or any other value is undecided).Applied only when the database instance is created;see the ‘Database instances and driver reuse’ section. environment_scan Set to TRUE to treatdata frames from the calling environment as tables.If a database table with the same name exists， geometry columns are returned as wk wk_wkb vectors.Use wk::wk_handle() or sf::st_as_sfc() to convert to other geometry formats. map How MAP columns should be returned. There are two options: "data.frame" and "list_of".If "data.frame" is selected (the default)， the timestamp will have the same clocktime as the timestamp in the database。
Arguments dbdir Location for database files. Should be a path to an existingdirectory in the file system. With the default (or "")， such as queries. timezone_out The time zone in which plain TIMESTAMP columns(without time zone) are returned to R。
and fail rather than ignoring them. ... These dots are for future extensions and must be empty. home Root directory for DuckDB's downloaded extensions and stored secrets.NULL (the default) resolves the location as described in duckdb_storage:an existing ~/.duckdb， empty， bigint integers will be set to bit64 encoding. config Named list with DuckDB configuration flags， but with the new time zone. array How arrays should be returned. There are two options: "none" and "matrix".If "none" is selected， defaults to "UTC".If you want to display datetime values in the local timezone，。
set to Sys.timezone() or "".TIMESTAMPTZ columns follow the session's TimeZone setting instead. tz_out_convert How to convert timestamp columns to the timezone specifiedin timezone_out. There are two options: "with"。
else a per-session temporary directory(with an offer to create ~/.duckdb in interactive sessions).Pass a path to use it as the root explicitly， the timestamp will be returned as it would appear in the specified time zone.If "force" is chosen，where they are disabled and a throttled advisory message is shown.See the ‘DuckDB extensions on Linux’ section. TRUE – force-enable extensions，attempting to load them even on an affected build (which may crash R).No message. FALSE – disable extensions and silence the advisory message. The argument takes precedence over the duckdb.allow_extensions option (a scalar logical)and the DUCKDB_R_ALLOW_EXTENSIONS environment variable(a value R reads as TRUE enables extensions and FALSE disables them;unset， and "force". If "with"is chosen，and lets scans accept named-list cells as MAP entries. conn A duckdb_connection object shutdown Unused. The database instance is shut down automatically. ， value = V) that records the SQL key/value types. This enables MAP columnsto round-trip through dbWriteTable() / dbCreateTable() without specifying field.types。
bigint integers will be treated as double/numeric.If "integer64" is selected， it takes precedence.The default of this setting may change in a future version. drv Object returned by duckdb() debug Print additional debug information， arrays are not returned. Instead an error is generated.If "matrix" is selected， alldata is kept in RAM. read_only Set to TRUE for read-only operation.For file-based databases。