{ "_id": "6a61f56435834fefe99ebce3", "Package": "DuckDBDataFrame", "Version": "0.99.6", "Date": "2026-07-22", "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", "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'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.0.0", "Config/pak/sysreqs": "cmake libicu-dev libssl-dev xz-utils zlib1g-dev", "Repository": "https://biocstaging.r-universe.dev", "Date/Publication": "2026-07-23 05:18:31 UTC", "RemoteUrl": "https://github.com/BiocStaging/DuckDBDataFrame", "RemoteRef": "HEAD", "RemoteSha": "62ef6ff1b48b2847496cea63201aa3a02f89ac45", "NeedsCompilation": "no", "Packaged": { "Date": "2026-07-23 10:58:11 UTC", "User": "root" }, "Author": "Patrick Aboyoun [aut, cre],\nGenentech, Inc. [cph]", "Maintainer": "Patrick Aboyoun ", "_user": "biocstaging", "_type": "src", "_file": "DuckDBDataFrame_0.99.6.tar.gz", "_fileid": "https://r2.ropensci.org/84b7b0f1934acc14af545a6365e80c445a5bbda1b7f3ce70c7333bce9bb7b027", "_filesize": 352062, "_sha256": "84b7b0f1934acc14af545a6365e80c445a5bbda1b7f3ce70c7333bce9bb7b027", "_expires": "2026-10-31T11:05:06.000Z", "_created": "2026-07-23T10:58:11.000Z", "_published": "2026-07-23T11:05:08.581Z", "_bioccheck": { "error": 0, "warning": 1, "note": 6 }, "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/biocstaging/actions/runs/30001064600", "_status": "success", "_upstream": "https://github.com/BiocStaging/DuckDBDataFrame", "_commit": { "id": "62ef6ff1b48b2847496cea63201aa3a02f89ac45", "author": "Patrick Aboyoun ", "committer": "Patrick Aboyoun ", "message": "Add an APPEND option to buildParquetCopySQL\n\nbuildParquetCopySQL() gains an `append` argument that emits the DuckDB `APPEND`\ncopy option. A `COPY ... PARTITION_BY` into a non-empty target otherwise fails\nwith \"Directory ... is not empty\"; `APPEND` writes new files into the existing\nhive-partitioned directory (with unique names, preserving the files earlier\nparts wrote), which is what a coord-array append needs. Default is FALSE, so the\nflat/lazy and fresh-write paths are unchanged; DuckDBArray's partitioned writer\npasses append = TRUE for the append case.\n\nBump version to 0.99.6; update NEWS.\n", "time": 1784783911 }, "_maintainer": { "name": "Patrick Aboyoun", "email": "aboyounp@gene.com" }, "_distro": "resolute", "_jobs": [ { "job": 89187095307, "time": 192, "config": "bioc-checks", "r": "4.6.1", "check": "WARNING", "artifact": "8561191056" }, { "job": 89187095198, "time": 355, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "NOTE", "artifact": "8561258863" }, { "job": 89187095125, "time": 311, "config": "linux-release-x86_64", "r": "4.6.1", "check": "NOTE", "artifact": "8561239645" }, { "job": 89187095206, "time": 213, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "NOTE", "artifact": "8561199189" }, { "job": 89187095139, "time": 261, "config": "macos-release-arm64", "r": "4.6.1", "check": "NOTE", "artifact": "8561219186" }, { "job": 89186175597, "time": 267, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "8561107393" }, { "job": 89187095135, "time": 126, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "8561162430" }, { "job": 89187095168, "time": 306, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "NOTE", "artifact": "8561237583" }, { "job": 89187095141, "time": 286, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "NOTE", "artifact": "8561229628" }, { "job": 89187095126, "time": 304, "config": "windows-release-x86_64", "r": "4.6.1", "check": "NOTE", "artifact": "8561237070" } ], "_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": "biocstaging", "_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": 11 } ], "_tags": [], "_topics": [ "dataimport", "datarepresentation", "infrastructure", "software" ], "_stars": 0, "_contributors": [ { "user": "aboyounp-gne", "count": 64, "uuid": 171627243 } ], "_userbio": { "uuid": 278472782, "type": "organization", "name": "BiocStaging", "followers": 1 }, "_downloads": { "count": 0, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/DuckDBDataFrame" }, "_devurl": "https://github.com/biocstaging/duckdbdataframe", "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/DuckDBDataFrame.html", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "LICENSE", "manual.pdf" ], "_cranurl": false, "_exports": [ ".has_row_number", ".keycols", ".makePrettyCharacterMatrixForDisplay", ".set_row_number", "%in%", "acquireDuckDBConn", "arrowIntType", "arrowType", "arrowTypeFromName", "arrowTypeToName", "as.data.frame", "as.env", "as.list", "bindCOLS", "bindROWS", "buildParquetCopySQL", "cbind", "chartr", "checkAppendPart", "checkHiveAppendPartitions", "clusterSort", "colnames", "colnames<-", "coltypes", "coltypes<-", "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", "head", "hilbert", "IQR", "is_nonzero", "is_sparse", "keydimnames", "keydimnames<-", "keynames", "loadExtension", "mad", "makeNakedCharacterMatrixForDisplay", "Math", "mean", "nchar", "ncol", "ncols", "nkey", "nkeydim", "normalizeSingleBracketReplacementValue", "nrow", "nzcount", "Ops", "parquetPartPath", "paste", "paste2", "pmax", "pmin", "quoteSQLColumns", "readParquetSchema", "realize", "reconcileParquetSchema", "releaseDuckDBConn", "replaceCOLS", "replaceROWS", "rownames", "rownames<-", "sd", "setupFlatParquetWrite", "show", "showAsCell", "split", "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": [ ".has_row_number,DuckDBColumn-method", ".keycols,DuckDBColumn-method", "as.vector,DuckDBColumn-method", "dbconn,DuckDBColumn-method", "dimtbls,DuckDBColumn-method", "dimtbls<-,DuckDBColumn-method", "DuckDBColumn-class", "extractROWS,DuckDBColumn,ANY-method", "head,DuckDBColumn-method", "length,DuckDBColumn-method", "names,DuckDBColumn-method", "names<-,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", "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.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": [ ".makePrettyCharacterMatrixForDisplay", "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": [ ".has_row_number,DuckDBSelfHits-method", ".keycols,DuckDBSelfHits-method", "as.data.frame,DuckDBSelfHits-method", "coerce,DuckDBSelfHits,DFrame-method", "coerce,DuckDBSelfHits,dgCMatrix-method", "coerce,DuckDBSelfHits,DuckDBDataFrame-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", "head,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": [ ".has_row_number", ".has_row_number,DuckDBTable-method", ".keycols", ".keycols,DuckDBTable-method", ".set_row_number", "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", "head,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", "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.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": [ "clusterSort", "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/BiocStaging/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", "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-07-06 21:16:03", "commits": 1 }, { "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-07-06 21:16:03", "commits": 1 } ], "_score": 5.309630167425899, "_indexed": true, "_nocasepkg": "duckdbdataframe", "_universes": [ "biocstaging" ], "_previous": "0.99.5", "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.99.6", "date": "2026-07-23T11:01:05.000Z", "distro": "resolute", "commit": "62ef6ff1b48b2847496cea63201aa3a02f89ac45", "fileid": "https://r2.ropensci.org/ebf297febf01321adbb8a65bc2a2851b104107d5e6f38a3484a3d8544324b77d", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/biocstaging/actions/runs/30001064600" }, { "r": "4.6.1", "os": "linux", "version": "0.99.6", "date": "2026-07-23T11:00:47.000Z", "distro": "resolute", "commit": "62ef6ff1b48b2847496cea63201aa3a02f89ac45", "fileid": "https://r2.ropensci.org/95c3c7d4ee4e9f96728bada12af7200625d794383b50fe8d896f86c083a6f297", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/biocstaging/actions/runs/30001064600" }, { "r": "4.5.3", "os": "mac", "version": "0.99.6", "date": "2026-07-23T11:00:15.000Z", "commit": "62ef6ff1b48b2847496cea63201aa3a02f89ac45", "fileid": "https://r2.ropensci.org/500db521b41ab9047096dd63b79d6419d01b582ef8100147cad559a1d3107ca3", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/biocstaging/actions/runs/30001064600" }, { "r": "4.6.1", "os": "mac", "version": "0.99.6", "date": "2026-07-23T11:00:11.000Z", "commit": "62ef6ff1b48b2847496cea63201aa3a02f89ac45", "fileid": "https://r2.ropensci.org/95dc307ee17171445432298392eca66966c7d52863f77d06219b92f6a7b34266", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/biocstaging/actions/runs/30001064600" }, { "r": "4.6.0", "os": "wasm", "version": "0.99.6", "date": "2026-07-23T11:00:53.000Z", "commit": "62ef6ff1b48b2847496cea63201aa3a02f89ac45", "fileid": "https://r2.ropensci.org/1f1296a79604369946e33bb8d07bf52d5e022ccd59aa31d2da8dee928a70a6fb", "status": "success", "buildurl": "https://github.com/r-universe/biocstaging/actions/runs/30001064600" }, { "r": "4.7.0", "os": "win", "version": "0.99.6", "date": "2026-07-23T10:59:48.000Z", "commit": "62ef6ff1b48b2847496cea63201aa3a02f89ac45", "fileid": "https://r2.ropensci.org/d5fb9603a46fddb7ebaaf15c937793dcbaeb1b60eb07fb806428021f7cfa6f05", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/biocstaging/actions/runs/30001064600" }, { "r": "4.5.3", "os": "win", "version": "0.99.6", "date": "2026-07-23T10:59:42.000Z", "commit": "62ef6ff1b48b2847496cea63201aa3a02f89ac45", "fileid": "https://r2.ropensci.org/2e90f0ca09cfd5701c580e03d51ba0236b151ad52ba3ea2e659639d0961ca2d4", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/biocstaging/actions/runs/30001064600" }, { "r": "4.6.1", "os": "win", "version": "0.99.6", "date": "2026-07-23T10:59:48.000Z", "commit": "62ef6ff1b48b2847496cea63201aa3a02f89ac45", "fileid": "https://r2.ropensci.org/2a7c172996717b16e3fbe30fe3bbb0d4c7feb00594beecddcab2321eb7d5d228", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/biocstaging/actions/runs/30001064600" } ] }