{ "_id": "6a212677cd65a98ecbd21004", "Package": "SQLDataFrame", "Title": "Representation of SQL tables in DataFrame metaphor", "Version": "1.26.0", "Description": "Implements bindings for SQL tables that are compatible\nwith Bioconductor S4 data structures, namely the DataFrame and\nDelayedArray. This allows SQL-derived data to be easily used\ninside other Bioconductor objects (e.g., SummarizedExperiments)\nwhile keeping everything on disk.", "Authors@R": "c(\nperson(\"Qian\", \"Liu\", , role = c(\"aut\", \"cre\"),\nemail=\"Qian.Liu@RoswellPark.org\",\ncomment = c(ORCID = \"0000-0003-1456-5099\")),\nperson(\"Aaron\", \"Lun\", role=c(\"aut\"),\nemail = \"infinite.monkeys.with.keyboards@gmail.com\"),\nperson(\"Martin\", \"Morgan\", role = c(\"aut\"),\nemail = \"martin.morgan@roswellpark.org\")\n)", "License": "LGPL (>= 3); File LICENSE", "biocViews": "DataRepresentation, Infrastructure, Software", "VignetteBuilder": "knitr", "URL": "https://github.com/Bioconductor/SQLDataFrame", "BugReports": "https://github.com/Bioconductor/SQLDataFrame/issues", "RoxygenNote": "7.2.3", "Encoding": "UTF-8", "PackageStatus": "Deprecated", "Config/pak/sysreqs": "xz-utils zlib1g-dev", "Repository": "https://bioc-release.r-universe.dev", "Date/Publication": "2026-04-28 12:50:21 UTC", "RemoteUrl": "https://github.com/bioc/SQLDataFrame", "RemoteRef": "RELEASE_3_23", "RemoteSha": "cea51320f40b8da387d118a02b25beaefd149f77", "NeedsCompilation": "no", "Packaged": { "Date": "2026-06-04 07:11:31 UTC", "User": "root" }, "Author": "Qian Liu [aut, cre] (ORCID: ),\nAaron Lun [aut],\nMartin Morgan [aut]", "Maintainer": "Qian Liu ", "MD5sum": "cc9dcffe4da234a420b971776e838319", "_user": "bioc-release", "_type": "src", "_file": "SQLDataFrame_1.26.0.tar.gz", "_fileid": "793e2effeaabfe24751ddf91d70a68e2aaf2598bf4c4076fd6c836085c190ad4", "_filesize": 126153, "_sha256": "793e2effeaabfe24751ddf91d70a68e2aaf2598bf4c4076fd6c836085c190ad4", "_created": "2026-06-04T07:11:31.000Z", "_published": "2026-06-04T07:17:11.909Z", "_jobs": [ { "job": 79468201968, "time": 162, "config": "bioc-checks", "r": "4.6.0", "check": "WARNING", "artifact": "7405264273" }, { "job": 79468201912, "time": 264, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "ERROR", "artifact": "7405292101" }, { "job": 79468201844, "time": 245, "config": "linux-release-x86_64", "r": "4.6.0", "check": "ERROR", "artifact": "7405287254" }, { "job": 79468201876, "time": 134, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "ERROR", "artifact": "7405265024" }, { "job": 79468201923, "time": 181, "config": "macos-release-arm64", "r": "4.6.0", "check": "ERROR", "artifact": "7405275622" }, { "job": 79467696897, "time": 221, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7405218150" }, { "job": 79468201957, "time": 119, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7405251804" }, { "job": 79468201904, "time": 226, "config": "windows-devel", "r": "4.7.0", "check": "ERROR", "artifact": "7405282865" }, { "job": 79468202076, "time": 291, "config": "windows-oldrel", "r": "4.5.3", "check": "ERROR", "artifact": "7405300245" }, { "job": 79468201837, "time": 183, "config": "windows-release", "r": "4.6.0", "check": "ERROR", "artifact": "7405270630" } ], "_bioccheck": { "error": 0, "warning": 1, "note": 6 }, "_buildurl": "https://github.com/r-universe/bioc-release/actions/runs/26936576786", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/bioc/SQLDataFrame", "_commit": { "id": "cea51320f40b8da387d118a02b25beaefd149f77", "author": "A Wokaty ", "committer": "A Wokaty ", "message": "bump x.y.z version to even y prior to creation of RELEASE_3_23 branch\n", "time": 1777380621 }, "_maintainer": { "name": "Qian Liu", "email": "qian.liu@roswellpark.org", "login": "liubuntu", "twitter": "@QianLiu28878838", "description": "Assistant Professor in Department of Biostats & Bioinfo\nAlumni @Bioconductor Core Team", "uuid": 12683977, "orcid": "0000-0003-1456-5099" }, "_distro": "noble", "_registered": true, "_dependencies": [ { "package": "DelayedArray", "role": "Depends" }, { "package": "S4Vectors", "role": "Depends" }, { "package": "stats", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "methods", "role": "Imports" }, { "package": "BiocGenerics", "role": "Imports" }, { "package": "RSQLite", "role": "Imports" }, { "package": "duckdb", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "BiocStyle", "role": "Suggests" }, { "package": "testthat", "role": "Suggests" } ], "_owner": "bioc", "_selfowned": false, "_usedby": 0, "_updates": [ { "week": "2025-44", "n": 2 }, { "week": "2026-11", "n": 1 }, { "week": "2026-18", "n": 1 } ], "_tags": [], "_topics": [ "datarepresentation", "infrastructure", "software" ], "_stars": 2, "_contributors": [ { "user": "liubuntu", "count": 232, "uuid": 12683977 }, { "user": "nturaga", "count": 12, "uuid": 2746443 }, { "user": "jwokaty", "count": 12, "uuid": 1744257 }, { "user": "hpages", "count": 1, "uuid": 8810451 }, { "user": "lshep", "count": 1, "uuid": 18724380 } ], "_userbio": { "uuid": 2286807, "type": "organization", "name": "Bioconductor", "description": "Software for the analysis and comprehension of high-throughput genomic data" }, "_downloads": { "count": 229, "source": "https://www.bioconductor.org/packages/stats/bioc/SQLDataFrame" }, "_devurl": "https://github.com/bioconductor/sqldataframe", "_searchresults": 11, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/NEWS.html", "extra/NEWS.txt", "extra/SQLDataFrame.html", "manual.pdf" ], "_cranurl": false, "_exports": [ "acquireConn", "dbtype", "DelayedArray", "DuckDBColumnSeed", "DuckDBColumnVector", "DuckDBDataFrame", "extract_array", "extractCOLS", "extractROWS", "normalizeSingleBracketReplacementValue", "path", "releaseConn", "replaceCOLS", "replaceROWS", "SQLColumnSeed", "SQLColumnVector", "SQLDataFrame", "SQLiteColumnSeed", "SQLiteColumnVector", "SQLiteDataFrame", "sqltable", "type" ], "_help": [ { "page": "acquireConn", "title": "Acquire the SQL file connection", "topics": [ "acquireConn", "releaseConn" ] }, { "page": "SQLColumnSeed", "title": "Column of a SQL table", "topics": [ "DelayedArray,SQLColumnSeed-method", "dim,SQLColumnSeed-method", "extract_array,SQLColumnSeed-method", "path,SQLColumnSeed-method", "SQLColumnSeed", "SQLColumnSeed-class", "SQLColumnVector", "SQLColumnVector-class", "sqltable,SQLColumnSeed-method", "type,SQLColumnSeed-method" ] }, { "page": "SQLDataFrame", "title": "SQL-backed DataFrame", "topics": [ "as.data.frame,SQLDataFrame-method", "cbind,SQLDataFrame-method", "cbind.SQLDataFrame", "coerce,SQLDataFrame,DFrame-method", "extractCOLS,SQLDataFrame-method", "extractROWS,SQLDataFrame,ANY-method", "length,SQLDataFrame-method", "names,SQLDataFrame-method", "names<-,SQLDataFrame-method", "ncol,SQLDataFrame-method", "normalizeSingleBracketReplacementValue,SQLDataFrame-method", "nrow,SQLDataFrame-method", "path,SQLDataFrame-method", "replaceCOLS,SQLDataFrame-method", "replaceROWS,SQLDataFrame-method", "rownames,SQLDataFrame-method", "rownames<-,SQLDataFrame-method", "SQLDataFrame", "SQLDataFrame-class", "[[,SQLDataFrame-method", "[[<-,SQLDataFrame-method" ] }, { "page": "SQL_extensions", "title": "SQL extensions", "topics": [ "DelayedArray,DuckDBColumnSeed-method", "DelayedArray,SQLiteColumnSeed-method", "DuckDBColumnSeed-class", "DuckDBColumnVector-class", "DuckDBDataFrame-class", "SQLiteColumnSeed-class", "SQLiteColumnVector-class", "SQLiteDataFrame-class" ] } ], "_rundeps": [ "abind", "BiocGenerics", "bit", "bit64", "blob", "cachem", "cli", "cpp11", "DBI", "DelayedArray", "duckdb", "fastmap", "generics", "glue", "IRanges", "lattice", "lifecycle", "Matrix", "MatrixGenerics", "matrixStats", "memoise", "pkgconfig", "rlang", "RSQLite", "S4Arrays", "S4Vectors", "SparseArray", "vctrs", "XVector" ], "_vignettes": [ { "source": "SQLDataFrame_userguide.Rmd", "filename": "SQLDataFrame_userguide.html", "title": "Using SQL-backed DataFrames", "author": "Qian Liu, Aaron Lun, Martin Morgan", "engine": "knitr::rmarkdown", "headings": [ "Overview", "Package installation", "Basic usage", "Collapsing to a DFrame", "Retrieving the SQL connection", "Session information" ], "created": "2024-03-28 15:20:42", "modified": "2024-03-28 15:20:42", "commits": 1 } ], "_score": 3.4216039268698317, "_indexed": false, "_nocasepkg": "sqldataframe", "_universes": [ "bioc-release" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.26.0", "date": "2026-06-04T07:14:39.000Z", "distro": "noble", "commit": "cea51320f40b8da387d118a02b25beaefd149f77", "fileid": "3293c817bf05f23bb1852a8dc4f1a819204ce35d6e9a20f7face6ec9d8e9280f", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/bioc-release/actions/runs/26936576786" }, { "r": "4.6.0", "os": "linux", "version": "1.26.0", "date": "2026-06-04T07:14:16.000Z", "distro": "noble", "commit": "cea51320f40b8da387d118a02b25beaefd149f77", "fileid": "afb7a07e19d42f95339611197bff474ecbaee6ae9434d421c6aab0e586e33634", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/bioc-release/actions/runs/26936576786" }, { "r": "4.5.3", "os": "mac", "version": "1.26.0", "date": "2026-06-04T07:13:39.000Z", "commit": "cea51320f40b8da387d118a02b25beaefd149f77", "fileid": "9cf8518d7b83f7f3784eaf84476b7ebc7782b99ff3684371a1f870b0ecc36f68", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/bioc-release/actions/runs/26936576786" }, { "r": "4.6.0", "os": "mac", "version": "1.26.0", "date": "2026-06-04T07:13:59.000Z", "commit": "cea51320f40b8da387d118a02b25beaefd149f77", "fileid": "7459c31237966d7ac5aaf48f2ebaa507ecf7980a3adbffb3ed8923c21ba5b428", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/bioc-release/actions/runs/26936576786" }, { "r": "4.6.0", "os": "wasm", "version": "1.26.0", "date": "2026-06-04T07:13:56.000Z", "commit": "cea51320f40b8da387d118a02b25beaefd149f77", "fileid": "281468cc8b6588d69ea2c4c473dd57a8cdad4c3ce545a20d61c091b72515506e", "status": "success", "buildurl": "https://github.com/r-universe/bioc-release/actions/runs/26936576786" }, { "r": "4.7.0", "os": "win", "version": "1.26.0", "date": "2026-06-04T07:13:42.000Z", "commit": "cea51320f40b8da387d118a02b25beaefd149f77", "fileid": "c65f253258824b11674727b9ea49deda37771a13a18e57b188d0dcd030808d34", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/bioc-release/actions/runs/26936576786" }, { "r": "4.5.3", "os": "win", "version": "1.26.0", "date": "2026-06-04T07:14:50.000Z", "commit": "cea51320f40b8da387d118a02b25beaefd149f77", "fileid": "20a9203a5e77be45449e9db75f91f93c9db34dcb081711e5f3c1317e83a81df7", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/bioc-release/actions/runs/26936576786" }, { "r": "4.6.0", "os": "win", "version": "1.26.0", "date": "2026-06-04T07:12:57.000Z", "commit": "cea51320f40b8da387d118a02b25beaefd149f77", "fileid": "d077aefb54fd94f94346a2f722a0f1f021eb54cb48dae110b11455f646236f7e", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/bioc-release/actions/runs/26936576786" } ] }