{ "_id": "6acce37fa14063b82c3aa474", "Package": "DuckDBDataFrame", "Version": "0.99.27", "Date": "2026-09-12", "Title": "DuckDB-Backed DataFrame and Table Structures", "Description": "Provides DuckDB-backed implementations of core tabular\ndata structures including DuckDBTable, DuckDBDataFrame, and\nDuckDBColumn. These classes extend Bioconductor's S4Vectors\nframework to enable efficient, out-of-memory operations on\nlarge tabular datasets using DuckDB's analytical database\nengine. The package includes SQL function discovery, connection\nmanagement, and support for list columns and embeddings stored\nin ARRAY[] columns.", "Authors@R": "c(\nperson(\"Patrick\", \"Aboyoun\", role=c(\"aut\", \"cre\"), email=\"aboyounp@gene.com\"),\nperson(\"Genentech, Inc.\", role=\"cph\")\n)", "License": "MIT + file LICENSE", "URL": "https://github.com/Genentech/DuckDBDataFrame", "BugReports": "https://github.com/Genentech/DuckDBDataFrame/issues", "biocViews": "DataImport, DataRepresentation, Infrastructure, Software", "VignetteBuilder": "knitr", "Encoding": "UTF-8", "Collate": "'sql_fun.R' 'sql_call.R' 'tblconn.R' 'keynames.R'\n'DuckDBConnection.R' 'DuckDBTable-class.R'\n'DuckDBTable-utils.R' 'DuckDBColumn-class.R'\n'DuckDBAtomicList-class.R' 'DuckDBColumn-utils.R'\n'DuckDBEmbeddings-class.R' 'DuckDBDataFrame-class.R'\n'DuckDBDataFrame-internals.R' 'DuckDBDataFrame-package.R'\n'DuckDBDataFrameList-class.R' 'DuckDBSelfHits-class.R'\n'DuckDBTransposedDataFrame-class.R' 'arrow-types.R'\n'parquet-io-cluster.R' 'parquet-io.R'", "Config/roxygen2/version": "8.1.0", "Config/pak/sysreqs": "cmake libicu-dev libssl-dev xz-utils zlib1g-dev", "Repository": "https://bioc.r-universe.dev", "Date/Publication": "2026-09-12 15:11:26 UTC", "RemoteUrl": "https://github.com/bioc/DuckDBDataFrame", "RemoteRef": "HEAD", "RemoteSha": "2fec690b923848868bd64d2809817731fa4ad98d", "NeedsCompilation": "no", "Packaged": { "Date": "2026-10-12 13:33:38 UTC", "User": "root" }, "Author": "Patrick Aboyoun [aut, cre],\nGenentech, Inc. [cph]", "Maintainer": "Patrick Aboyoun ", "_user": "bioc", "_type": "src", "_file": "DuckDBDataFrame_0.99.27.tar.gz", "_fileid": "https://r2.ropensci.org/78c36398a3c0fcb4a567ed606d3bb9ed9bc32dab393cf812ce52535e8319af25", "_filesize": 408020, "_sha256": "78c36398a3c0fcb4a567ed606d3bb9ed9bc32dab393cf812ce52535e8319af25", "_expires": "2027-01-20T13:41:17.000Z", "_created": "2026-10-12T13:33:38.000Z", "_published": "2026-10-12T13:41:18.890Z", "_buildurl": "https://github.com/r-universe/bioc/actions/runs/38256075326", "_status": "success", "_host": "GitHub-Actions", "_bioccheck": { "error": 0, "warning": 0, "note": 8 }, "_upstream": "https://github.com/bioc/DuckDBDataFrame", "_commit": { "id": "2fec690b923848868bd64d2809817731fa4ad98d", "author": "Patrick Aboyoun ", "committer": "Patrick Aboyoun ", "message": "fix: quote sql_fun() IN-list values via dbQuoteString (0.99.27)\n\nsql_fun,DuckDBTable-method built its return_type/function_type IN (...)\npredicates by pasting user-supplied strings between hardcoded quotes with\nno escaping, so a return_type containing a ' (e.g. \"x') OR 1=1 --\") broke\nout of the SQL literal before hitting dbGetQuery(). function_type wasn't\nactually exploitable (match.arg() constrains it to a fixed enum first),\nbut both now go through DBI::dbQuoteString(conn, ...), the same\nconnection object already used elsewhere in the method.\n", "time": 1789225886 }, "_maintainer": { "name": "Patrick Aboyoun", "email": "aboyounp@gene.com" }, "_distro": "resolute", "_jobs": [ { "job": 114836171331, "time": 176, "config": "bioc-checks", "r": "4.6.1", "check": "NOTE", "artifact": "11749929156" }, { "job": 114836171166, "time": 400, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "NOTE", "artifact": "11750937287" }, { "job": 114836171032, "time": 403, "config": "linux-release-x86_64", "r": "4.6.1", "check": "NOTE", "artifact": "11750608392" }, { "job": 114836171159, "time": 243, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "NOTE", "artifact": "11750912651" }, { "job": 114836171348, "time": 376, "config": "macos-release-arm64", "r": "4.6.1", "check": "NOTE", "artifact": "11750453506" }, { "job": 114834525735, "time": 243, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "11750383010" }, { "job": 114836171253, "time": 115, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "11749574392" }, { "job": 114836171107, "time": 321, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "NOTE", "artifact": "11750608143" }, { "job": 114836171325, "time": 253, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "NOTE", "artifact": "11750927422" }, { "job": 114836171157, "time": 316, "config": "windows-release-x86_64", "r": "4.6.1", "check": "NOTE", "artifact": "11750054298" } ], "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.5.0", "role": "Depends" }, { "package": "methods", "role": "Depends" }, { "package": "stats", "role": "Depends" }, { "package": "bit64", "role": "Depends" }, { "package": "S4Vectors", "role": "Depends" }, { "package": "IRanges", "role": "Depends" }, { "package": "tools", "role": "Imports" }, { "package": "BiocGenerics", "role": "Imports" }, { "package": "S4Arrays", "role": "Imports" }, { "package": "SparseArray", "role": "Imports" }, { "package": "DelayedArray", "role": "Imports" }, { "package": "Matrix", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "rlang", "role": "Imports" }, { "package": "dplyr", "role": "Imports" }, { "package": "dbplyr", "role": "Imports" }, { "package": "duckdb", "role": "Imports" }, { "package": "arrow", "role": "Imports" }, { "package": "tibble", "role": "Imports" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "BiocStyle", "role": "Suggests" }, { "package": "testthat", "role": "Suggests" } ], "_owner": "bioc", "_selfowned": true, "_usedby": 4, "_updates": [ { "week": "2026-04", "n": 2 }, { "week": "2026-07", "n": 1 }, { "week": "2026-09", "n": 1 }, { "week": "2026-10", "n": 4 }, { "week": "2026-11", "n": 2 }, { "week": "2026-13", "n": 1 }, { "week": "2026-16", "n": 2 }, { "week": "2026-17", "n": 5 }, { "week": "2026-19", "n": 4 }, { "week": "2026-21", "n": 3 }, { "week": "2026-22", "n": 1 }, { "week": "2026-24", "n": 2 }, { "week": "2026-25", "n": 1 }, { "week": "2026-27", "n": 1 }, { "week": "2026-28", "n": 7 }, { "week": "2026-29", "n": 7 }, { "week": "2026-30", "n": 20 }, { "week": "2026-31", "n": 5 }, { "week": "2026-32", "n": 2 }, { "week": "2026-34", "n": 5 }, { "week": "2026-35", "n": 9 }, { "week": "2026-37", "n": 1 } ], "_tags": [], "_bioc": [ { "branch": "devel", "version": "0.99.27", "bioc": "3.24", "repository": "bioc" } ], "_topics": [ "dataimport", "datarepresentation", "infrastructure", "software" ], "_stars": 1, "_contributors": [ { "user": "aboyounp-gne", "count": 95, "uuid": 171627243 } ], "_userbio": { "uuid": 2286807, "type": "organization", "name": "Bioconductor", "followers": 476, "description": "Software for the analysis and comprehension of high-throughput genomic data" }, "_downloads": { "count": 206, "source": "https://www.bioconductor.org/packages/stats/bioc/DuckDBDataFrame" }, "_devurl": "https://github.com/genentech/duckdbdataframe", "_searchresults": 14, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/DuckDBDataFrame.html", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "LICENSE" ], "_homeurl": "https://github.com/genentech/duckdbdataframe", "_realowner": "bioc", "_cranurl": false, "_exports": [ "%in%", "acquireDuckDBConn", "arrowIntType", "arrowType", "arrowTypeFromName", "arrowTypeToName", "as.data.frame", "as.env", "as.list", "as.matrix", "bindCOLS", "bindROWS", "buildParquetCopySQL", "cbind", "chartr", "checkAppendPart", "checkHiveAppendPartitions", "clusterOrderSQL", "clusterSort", "coerce", "colnames", "colnames<-", "coltypes", "coltypes<-", "columnExtents", "columnMetadata", "columnMetadata<-", "commonColnames", "configureCloud", "configureOutOfCore", "countLnodeHits", "countRnodeHits", "dbconn", "dimtbls", "dimtbls<-", "DuckDBDataFrame", "DuckDBSelfHits", "DuckDBTable", "elementMetadata", "elementMetadata<-", "elementNROWS", "endsWith", "escapeSQLPath", "extractCOLS", "extractNODES", "extractROWS", "from", "getListElement", "grepl", "gsub", "has_row_number", "head", "hilbert", "IQR", "is_nonzero", "is_sparse", "keycols", "keydimnames", "keydimnames<-", "keynames", "levels", "loadExtension", "mad", "makeNakedCharacterMatrixForDisplay", "makePrettyCharacterMatrixForDisplay", "Math", "mean", "nchar", "ncol", "ncols", "nkey", "nkeydim", "nlevels", "normalizeSingleBracketReplacementValue", "nrow", "nzcount", "Ops", "parquetPartPath", "paste", "paste2", "pmax", "pmin", "quoteSQLColumns", "readParquetSchema", "realize", "reconcileParquetSchema", "releaseDuckDBConn", "replaceCOLS", "replaceROWS", "rownames", "rownames<-", "sd", "set_row_number", "setupFlatParquetWrite", "show", "showAsCell", "split", "splitParquetPart", "sql_call", "sql_fun", "startsWith", "sub", "subset", "substr", "substring", "Summary", "t", "t.DuckDBDataFrame", "table", "tail", "tblconn", "to", "tolower", "toupper", "type", "type<-", "unique", "validateAppendOffset", "validateWriteParquetPart", "var", "writeDuckDBTableParquet", "zorder" ], "_help": [ { "page": "arrow-types", "title": "Arrow type helpers for the DuckDB package suite", "topics": [ "arrow-types", "arrowIntType", "arrowType", "arrowTypeFromName", "arrowTypeToName" ] }, { "page": "DuckDBAtomicList-class", "title": "DuckDBAtomicList objects", "topics": [ "as.list,DuckDBAtomicList-method", "DuckDBAtomicList-class", "DuckDBCharacterList-class", "DuckDBFactorList-class", "DuckDBInteger64List-class", "DuckDBIntegerList-class", "DuckDBLogicalList-class", "DuckDBNumericList-class", "elementNROWS,DuckDBAtomicList-method", "extractROWS,DuckDBAtomicList,ANY-method", "getListElement,DuckDBAtomicList-method", "head,DuckDBAtomicList-method", "realize,DuckDBAtomicList-method", "show,DuckDBAtomicList-method", "showAsCell,DuckDBAtomicList-method", "tail,DuckDBAtomicList-method" ] }, { "page": "DuckDBColumn-class", "title": "DuckDBColumn objects", "topics": [ "as.vector,DuckDBColumn-method", "dbconn,DuckDBColumn-method", "dimtbls,DuckDBColumn-method", "dimtbls<-,DuckDBColumn-method", "DuckDBColumn-class", "extractROWS,DuckDBColumn,ANY-method", "has_row_number,DuckDBColumn-method", "head,DuckDBColumn-method", "keycols,DuckDBColumn-method", "length,DuckDBColumn-method", "levels,DuckDBColumn-method", "names,DuckDBColumn-method", "names<-,DuckDBColumn-method", "nlevels,DuckDBColumn-method", "realize,DuckDBColumn-method", "show,DuckDBColumn-method", "showAsCell,DuckDBColumn-method", "tail,DuckDBColumn-method", "tblconn,DuckDBColumn-method", "type,DuckDBColumn-method", "type<-,DuckDBColumn-method" ] }, { "page": "DuckDBColumn-utils", "title": "Common operations on DuckDBColumn objects", "topics": [ "!,DuckDBColumn-method", "%in%,DuckDBColumn,ANY-method", "anyNA,DuckDBColumn-method", "chartr,ANY,ANY,DuckDBColumn-method", "DuckDBColumn-utils", "endsWith,DuckDBColumn-method", "grepl,ANY,DuckDBColumn-method", "gsub,ANY,ANY,DuckDBColumn-method", "IQR,DuckDBColumn-method", "is.finite,DuckDBColumn-method", "is.infinite,DuckDBColumn-method", "is.na,DuckDBColumn-method", "is.nan,DuckDBColumn-method", "is_nonzero,DuckDBColumn-method", "mad,DuckDBColumn-method", "Math,DuckDBColumn-method", "mean,DuckDBColumn-method", "median.DuckDBColumn", "nchar,DuckDBColumn-method", "nzcount,DuckDBColumn-method", "Ops,atomic,DuckDBColumn-method", "Ops,DuckDBColumn,atomic-method", "Ops,DuckDBColumn,DuckDBColumn-method", "Ops,DuckDBColumn,missing-method", "paste,DuckDBColumn-method", "paste2,character,DuckDBColumn-method", "paste2,DuckDBColumn,character-method", "paste2,DuckDBColumn,DuckDBColumn-method", "pmax,DuckDBColumn-method", "pmin,DuckDBColumn-method", "quantile.DuckDBColumn", "sd,DuckDBColumn-method", "sql_call,DuckDBColumn-method", "sql_fun,DuckDBColumn-method", "startsWith,DuckDBColumn-method", "sub,ANY,ANY,DuckDBColumn-method", "substr,DuckDBColumn-method", "substring,DuckDBColumn-method", "Summary,DuckDBColumn-method", "table,DuckDBColumn-method", "tolower,DuckDBColumn-method", "toupper,DuckDBColumn-method", "unique,DuckDBColumn-method", "var,DuckDBColumn,ANY-method" ] }, { "page": "DuckDBConnection", "title": "Acquire and Release the DuckDB Connection", "topics": [ "acquireDuckDBConn", "configureCloud", "configureOutOfCore", "DuckDBConnection", "loadExtension", "releaseDuckDBConn" ] }, { "page": "DuckDBDataFrame-class", "title": "DuckDBDataFrame objects", "topics": [ "as.data.frame,DuckDBDataFrame-method", "as.matrix,DuckDBDataFrame-method", "cbind,DuckDBDataFrame-method", "cbind.DuckDBDataFrame", "coerce,DuckDBDataFrame,DFrame-method", "colnames<-,DuckDBDataFrame-method", "DuckDBDataFrame", "DuckDBDataFrame-class", "length,DuckDBDataFrame-method", "makeNakedCharacterMatrixForDisplay,DuckDBDataFrame-method", "names,DuckDBDataFrame-method", "names<-,DuckDBDataFrame-method", "normalizeSingleBracketReplacementValue,DuckDBDataFrame-method", "realize,DuckDBDataFrame-method", "replaceCOLS,DuckDBDataFrame-method", "replaceROWS,DuckDBDataFrame-method", "rownames<-,DuckDBDataFrame-method", "show,DuckDBDataFrame-method", "subset,DuckDBDataFrame-method", "[,DuckDBDataFrame,ANY,ANY,ANY-method", "[[,DuckDBDataFrame-method", "[[<-,DuckDBDataFrame-method" ] }, { "page": "DuckDBDataFrameList-class", "title": "DuckDBDataFrameList objects", "topics": [ "coerce,DuckDBDataFrameList,DFrameList-method", "colnames<-,DuckDBDataFrameList-method", "columnMetadata,DuckDBDataFrameList-method", "columnMetadata<-,DuckDBDataFrameList-method", "commonColnames,DuckDBDataFrameList-method", "dbconn,DuckDBDataFrameList-method", "dimtbls,DuckDBDataFrameList-method", "dimtbls<-,DuckDBDataFrameList-method", "DuckDBDataFrameList-class", "elementNROWS,DuckDBDataFrameList-method", "extractROWS,DuckDBDataFrameList,ANY-method", "getListElement,DuckDBDataFrameList-method", "head,DuckDBDataFrameList-method", "length,DuckDBDataFrameList-method", "names,DuckDBDataFrameList-method", "names<-,DuckDBDataFrameList-method", "ncols,DuckDBDataFrameList-method", "realize,DuckDBDataFrameList-method", "rownames<-,DuckDBDataFrameList-method", "split,DuckDBDataFrame,DuckDBColumn-method", "tail,DuckDBDataFrameList-method", "tblconn,DuckDBDataFrameList-method", "unlist,DuckDBDataFrameList-method" ] }, { "page": "DuckDBEmbeddings-class", "title": "DuckDBEmbeddings objects", "topics": [ "as.list,DuckDBEmbeddings-method", "as.matrix,DuckDBEmbeddings-method", "colnames,DuckDBEmbeddings-method", "colnames<-,DuckDBEmbeddings-method", "DuckDBEmbeddings-class", "extractCOLS,DuckDBEmbeddings-method", "ncol,DuckDBEmbeddings-method", "nrow,DuckDBEmbeddings-method", "realize,DuckDBEmbeddings-method", "rownames,DuckDBEmbeddings-method", "rownames<-,DuckDBEmbeddings-method", "show,DuckDBEmbeddings-method", "showAsCell,DuckDBEmbeddings-method", "[,DuckDBEmbeddings,ANY,ANY,ANY-method" ] }, { "page": "DuckDBSelfHits-class", "title": "DuckDBSelfHits objects", "topics": [ "as.data.frame,DuckDBSelfHits-method", "coerce,DuckDBSelfHits,DFrame-method", "coerce,DuckDBSelfHits,dgCMatrix-method", "coerce,DuckDBSelfHits,DuckDBDataFrame-method", "coerce,DuckDBSelfHits,SelfHits-method", "countLnodeHits,DuckDBSelfHits-method", "countRnodeHits,DuckDBSelfHits-method", "dbconn,DuckDBSelfHits-method", "dimtbls,DuckDBSelfHits-method", "dimtbls<-,DuckDBSelfHits-method", "DuckDBSelfHits", "DuckDBSelfHits-class", "elementMetadata,DuckDBSelfHits-method", "elementMetadata<-,DuckDBSelfHits-method", "extractNODES", "extractNODES,DuckDBSelfHits-method", "extractROWS,DuckDBSelfHits,ANY-method", "from,DuckDBSelfHits-method", "has_row_number,DuckDBSelfHits-method", "head,DuckDBSelfHits-method", "keycols,DuckDBSelfHits-method", "length,DuckDBSelfHits-method", "realize,DuckDBSelfHits-method", "show,DuckDBSelfHits-method", "tail,DuckDBSelfHits-method", "tblconn,DuckDBSelfHits-method", "to,DuckDBSelfHits-method", "[,DuckDBSelfHits,ANY,ANY,ANY-method" ] }, { "page": "DuckDBTable-class", "title": "DuckDBTable objects", "topics": [ "all.equal.DuckDBTable", "as.data.frame,DuckDBTable-method", "as.env,DuckDBTable-method", "bindCOLS,DuckDBTable-method", "bindROWS,DuckDBTable-method", "colnames,DuckDBTable-method", "colnames<-,DuckDBTable-method", "coltypes", "coltypes,DuckDBTable-method", "coltypes<-", "coltypes<-,DuckDBTable-method", "dbconn,DuckDBTable-method", "dimtbls", "dimtbls,DuckDBTable-method", "dimtbls<-", "dimtbls<-,DuckDBTable-method", "DuckDBTable", "DuckDBTable-class", "extractCOLS,DuckDBTable-method", "extractROWS,DuckDBTable,ANY-method", "has_row_number,DuckDBTable-method", "head,DuckDBTable-method", "keycols,DuckDBTable-method", "ncol,DuckDBTable-method", "nrow,DuckDBTable-method", "rownames,DuckDBTable-method", "show,DuckDBTable-method", "subset,DuckDBTable-method", "tail,DuckDBTable-method", "tblconn,DuckDBTable-method", "[,DuckDBTable,ANY,ANY,ANY-method" ] }, { "page": "DuckDBTable-utils", "title": "Common operations on DuckDBTable objects", "topics": [ "!,DuckDBTable-method", "%in%,DuckDBTable,ANY-method", "anyNA,DuckDBTable-method", "chartr,ANY,ANY,DuckDBTable-method", "DuckDBTable-utils", "elementNROWS,DuckDBTable-method", "endsWith,DuckDBTable-method", "grepl,ANY,DuckDBTable-method", "gsub,ANY,ANY,DuckDBTable-method", "IQR,DuckDBTable-method", "is.finite,DuckDBTable-method", "is.infinite,DuckDBTable-method", "is.na,DuckDBTable-method", "is.nan,DuckDBTable-method", "is_nonzero,DuckDBTable-method", "is_sparse,DuckDBTable-method", "mad,DuckDBTable-method", "Math,DuckDBTable-method", "mean,DuckDBTable-method", "median.DuckDBTable", "nchar,DuckDBTable-method", "nzcount,DuckDBTable-method", "Ops,atomic,DuckDBTable-method", "Ops,DuckDBTable,atomic-method", "Ops,DuckDBTable,DuckDBTable-method", "Ops,DuckDBTable,missing-method", "paste,DuckDBTable-method", "paste2,character,DuckDBTable-method", "paste2,DuckDBTable,character-method", "paste2,DuckDBTable,DuckDBTable-method", "pmax,DuckDBTable-method", "pmin,DuckDBTable-method", "quantile.DuckDBTable", "sd,DuckDBTable-method", "sql_call,DuckDBTable-method", "sql_fun,DuckDBTable-method", "startsWith,DuckDBTable-method", "sub,ANY,ANY,DuckDBTable-method", "substr,DuckDBTable-method", "substring,DuckDBTable-method", "Summary,DuckDBTable-method", "table,DuckDBTable-method", "tolower,DuckDBTable-method", "toupper,DuckDBTable-method", "unique,DuckDBTable-method", "var,DuckDBTable,ANY-method" ] }, { "page": "DuckDBTransposedDataFrame-class", "title": "DuckDBTransposedDataFrame objects", "topics": [ "as.matrix,DuckDBTransposedDataFrame-method", "dbconn,DuckDBTransposedDataFrame-method", "dimtbls,DuckDBTransposedDataFrame-method", "dimtbls<-,DuckDBTransposedDataFrame-method", "DuckDBTransposedDataFrame-class", "realize,DuckDBTransposedDataFrame-method", "show,DuckDBTransposedDataFrame-method", "t,DuckDBDataFrame-method", "t.DuckDBDataFrame", "tblconn,DuckDBTransposedDataFrame-method" ] }, { "page": "keynames", "title": "Key Names and Key Count", "topics": [ "keydimnames", "keydimnames,DuckDBTable-method", "keydimnames<-", "keydimnames<-,DuckDBTable-method", "keynames", "keynames,DuckDBTable-method", "nkey", "nkey,DuckDBTable-method", "nkeydim", "nkeydim,DuckDBTable-method" ] }, { "page": "parquet-io-cluster", "title": "Cluster-on-write keys and helpers", "topics": [ "clusterOrderSQL", "clusterSort", "columnExtents", "hilbert", "parquet-io-cluster", "zorder" ] }, { "page": "sql_call", "title": "Call DuckDB SQL Functions on BiocDuckDB Objects", "topics": [ "sql_call" ] }, { "page": "sql_fun", "title": "Find Compatible DuckDB SQL Functions for BiocDuckDB Objects", "topics": [ "sql_fun" ] }, { "page": "tblconn", "title": "Accessing DB Table Information", "topics": [ "tblconn" ] } ], "_readme": "https://github.com/bioc/DuckDBDataFrame/raw/HEAD/README.md", "_rundeps": [ "abind", "arrow", "assertthat", "BiocGenerics", "bit", "bit64", "blob", "cli", "cpp11", "DBI", "dbplyr", "DelayedArray", "dplyr", "duckdb", "generics", "glue", "IRanges", "lattice", "lifecycle", "magrittr", "Matrix", "MatrixGenerics", "matrixStats", "pillar", "pkgconfig", "purrr", "R6", "rlang", "S4Arrays", "S4Vectors", "SparseArray", "stringi", "stringr", "tibble", "tidyr", "tidyselect", "utf8", "vctrs", "withr", "XVector" ], "_vignettes": [ { "source": "DuckDBDataFrame.Rmd", "filename": "DuckDBDataFrame.html", "title": "Introduction to DuckDBDataFrame", "author": "Patrick Aboyoun", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Relationship to arrow", "Installation", "Quick start", "Working with a DuckDBDataFrame", "Column access", "Row subsetting", "Computed columns", "Column metadata", "Columns come in three flavors", "Reaching for SQL directly", "When to use DuckDBDataFrame", "Session information" ], "created": "2026-07-06 21:16:03", "modified": "2026-08-05 15:40:44", "commits": 3 }, { "source": "DuckDBDataFrame-design.Rmd", "filename": "DuckDBDataFrame-design.html", "title": "Design and extension of DuckDBDataFrame", "author": "Patrick Aboyoun", "engine": "knitr::rmarkdown", "headings": [ "Scope", "The classes", "The DuckDBTable abstraction", "Construction", "The contract", "Key-dimension semantics", "From R to SQL", "Connection management", "Dimension tables", "Extending DuckDBDataFrame", "Session information" ], "created": "2026-07-06 21:16:03", "modified": "2026-08-05 15:40:44", "commits": 4 } ], "_score": 6.56773196254807, "_indexed": true, "_nocasepkg": "duckdbdataframe", "_universes": [ "bioc", "genentech" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.99.27", "date": "2026-10-12T13:36:56.000Z", "distro": "resolute", "commit": "2fec690b923848868bd64d2809817731fa4ad98d", "fileid": "https://r2.ropensci.org/a9fb6505777ecc443c3d8f906bb1dc2ade11ce28925d790c5451fad85edd217a", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/bioc/actions/runs/38256075326" }, { "r": "4.6.1", "os": "linux", "version": "0.99.27", "date": "2026-10-12T13:37:12.000Z", "distro": "resolute", "commit": "2fec690b923848868bd64d2809817731fa4ad98d", "fileid": "https://r2.ropensci.org/6dff77e9f3f8cb026a4a4e9e50e07597ff49025f5b9e0f2088ec3ca1e0c5d86a", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/bioc/actions/runs/38256075326" }, { "r": "4.5.3", "os": "mac", "version": "0.99.27", "date": "2026-10-12T13:35:27.000Z", "commit": "2fec690b923848868bd64d2809817731fa4ad98d", "fileid": "https://r2.ropensci.org/423346bec3e50c39f3836b119bca191ae6fdb884312a8b5a9361b545abe54f6e", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/bioc/actions/runs/38256075326" }, { "r": "4.6.1", "os": "mac", "version": "0.99.27", "date": "2026-10-12T13:36:16.000Z", "commit": "2fec690b923848868bd64d2809817731fa4ad98d", "fileid": "https://r2.ropensci.org/b192a582cb5a7a7e57fb1fbb902ef25e1a3cd06780f0eacfc25aab2519367ee3", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/bioc/actions/runs/38256075326" }, { "r": "4.6.0", "os": "wasm", "version": "0.99.27", "date": "2026-10-12T13:36:03.000Z", "commit": "2fec690b923848868bd64d2809817731fa4ad98d", "fileid": "https://r2.ropensci.org/98bf0899aa3958931503be3e9cbaf6dd75d59c9a83b17d98659db5d24fc145c6", "status": "success", "buildurl": "https://github.com/r-universe/bioc/actions/runs/38256075326" }, { "r": "4.7.0", "os": "win", "version": "0.99.27", "date": "2026-10-12T13:35:07.000Z", "commit": "2fec690b923848868bd64d2809817731fa4ad98d", "fileid": "https://r2.ropensci.org/7282e2e936cebe9e657eaffd47e2417e7558bf97c5cfece617256c20465bca67", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/bioc/actions/runs/38256075326" }, { "r": "4.5.3", "os": "win", "version": "0.99.27", "date": "2026-10-12T13:35:01.000Z", "commit": "2fec690b923848868bd64d2809817731fa4ad98d", "fileid": "https://r2.ropensci.org/3fb18b5e25a303efdf6763b037d33254e1b921ad2227d2198205e6ca51e9cd2f", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/bioc/actions/runs/38256075326" }, { "r": "4.6.1", "os": "win", "version": "0.99.27", "date": "2026-10-12T13:35:10.000Z", "commit": "2fec690b923848868bd64d2809817731fa4ad98d", "fileid": "https://r2.ropensci.org/fd226103835ab3d226c70b4716e76d379456034baec859f5d7ef8a583e08bdb4", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/bioc/actions/runs/38256075326" } ] }