{
  "_id": "6ae7ca91818c9e3ef6dbd052",
  "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": "zlib1g-dev",
  "Repository": "Bioconductor 3.23",
  "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-11-01 18:50:45 UTC",
    "User": "root"
  },
  "Author": "Qian Liu [aut, cre] (ORCID: <https://orcid.org/0000-0003-1456-5099>),\nAaron Lun [aut],\nMartin Morgan [aut]",
  "Maintainer": "Qian Liu <Qian.Liu@RoswellPark.org>",
  "_user": "bioc-release",
  "_type": "src",
  "_file": "SQLDataFrame_1.26.0.tar.gz",
  "_fileid": "https://r2.ropensci.org/a88a3ef3adb0200e4d9b1945c193eccb6c98c059343c99a1b02061eae856373c",
  "_filesize": 127306,
  "_sha256": "a88a3ef3adb0200e4d9b1945c193eccb6c98c059343c99a1b02061eae856373c",
  "_expires": "2027-02-09T23:26:07.000Z",
  "_created": "2026-11-01T18:50:45.000Z",
  "_published": "2026-11-01T23:26:08.981Z",
  "_upstream": "https://github.com/bioc/SQLDataFrame",
  "_status": "success",
  "_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"
  },
  "_jobs": [
    {
      "job": 124944014228,
      "time": 150,
      "config": "bioc-checks",
      "r": "4.6.2",
      "check": "WARNING",
      "artifact": "13096647270"
    },
    {
      "job": 124944014378,
      "time": 311,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "ERROR",
      "artifact": "13096368449"
    },
    {
      "job": 124944014328,
      "time": 316,
      "config": "linux-release-x86_64",
      "r": "4.6.2",
      "check": "ERROR",
      "artifact": "13096383401"
    },
    {
      "job": 124944014365,
      "time": 2211,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "ERROR",
      "artifact": "13105052787"
    },
    {
      "job": 124944014331,
      "time": 211,
      "config": "macos-release-arm64",
      "r": "4.6.2",
      "check": "ERROR",
      "artifact": "13104677122"
    },
    {
      "job": 124938032782,
      "time": 223,
      "config": "source",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13096880183"
    },
    {
      "job": 124944014452,
      "time": 95,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "13097046875"
    },
    {
      "job": 124944014221,
      "time": 179,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "ERROR",
      "artifact": "13096945471"
    },
    {
      "job": 124944014351,
      "time": 180,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "ERROR",
      "artifact": "13096257021"
    },
    {
      "job": 124944014234,
      "time": 167,
      "config": "windows-release-x86_64",
      "r": "4.6.2",
      "check": "ERROR",
      "artifact": "13097055207"
    }
  ],
  "_bioccheck": {
    "error": 0,
    "warning": 1,
    "note": 6
  },
  "_buildurl": "https://github.com/r-universe/bioc-release/actions/runs/41333205610",
  "_commit": {
    "id": "cea51320f40b8da387d118a02b25beaefd149f77",
    "author": "A Wokaty <andres.wokaty@sph.cuny.edu>",
    "committer": "A Wokaty <andres.wokaty@sph.cuny.edu>",
    "message": "bump x.y.z version to even y prior to creation of RELEASE_3_23 branch\n",
    "time": 1777380621
  },
  "_distro": "resolute",
  "_host": "GitHub-Actions",
  "_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",
    "followers": 482,
    "description": "Software for the analysis and comprehension of high-throughput genomic data"
  },
  "_downloads": {
    "count": 286,
    "source": "https://www.bioconductor.org/packages/stats/bioc/SQLDataFrame"
  },
  "_devurl": "https://github.com/bioconductor/sqldataframe",
  "_searchresults": 10,
  "_abi": {
    "exports": [
      {
        "key": "SQLDataFrame::DuckDBColumnSeed",
        "hash": "386af04cf9eda61a"
      },
      {
        "key": "SQLDataFrame::DuckDBColumnVector",
        "hash": "475a1325ee1a04b5"
      },
      {
        "key": "SQLDataFrame::DuckDBDataFrame",
        "hash": "77415de64e95f10c"
      },
      {
        "key": "SQLDataFrame::SQLColumnSeed",
        "hash": "57b943081d1578d9"
      },
      {
        "key": "SQLDataFrame::SQLColumnVector",
        "hash": "9433e2578b99c33e"
      },
      {
        "key": "SQLDataFrame::SQLDataFrame",
        "hash": "37a9a91423e0f808"
      },
      {
        "key": "SQLDataFrame::SQLiteColumnSeed",
        "hash": "5549f46065f96d5d"
      },
      {
        "key": "SQLDataFrame::SQLiteColumnVector",
        "hash": "4f879eca28679d19"
      },
      {
        "key": "SQLDataFrame::SQLiteDataFrame",
        "hash": "21b9b206a80a62e8"
      },
      {
        "key": "SQLDataFrame::generic:dbtype",
        "hash": "fb349e270381a47e"
      },
      {
        "key": "SQLDataFrame::generic:sqltable",
        "hash": "9951a4846934fc14"
      }
    ],
    "imports": [
      {
        "key": "BiocGenerics::generic:as.data.frame",
        "hash": "bbe06a14e0191ef5"
      },
      {
        "key": "BiocGenerics::generic:cbind",
        "hash": "24fd9eb44785137b"
      },
      {
        "key": "BiocGenerics::generic:path",
        "hash": "0812ecdc10020428"
      },
      {
        "key": "BiocGenerics::generic:rownames",
        "hash": "daad082a6ceaaee0"
      },
      {
        "key": "BiocGenerics::generic:type",
        "hash": "8a513486f398f054"
      },
      {
        "key": "DelayedArray::DelayedArray",
        "hash": "5c4ba6006d92cc2c"
      },
      {
        "key": "DelayedArray::DelayedOp",
        "hash": "959c97d4541a9ac0"
      },
      {
        "key": "DelayedArray::DelayedUnaryIsoOp",
        "hash": "f59692a927d0b94a"
      },
      {
        "key": "DelayedArray::DelayedUnaryOp",
        "hash": "692bde9f2d873893"
      },
      {
        "key": "DelayedArray::generic:DelayedArray",
        "hash": "5fd6a2d0f540c19e"
      },
      {
        "key": "S4Arrays::Array",
        "hash": "44e3db83d6a4f33f"
      },
      {
        "key": "S4Arrays::generic:extract_array",
        "hash": "adbc2aea8ccb7fa5"
      },
      {
        "key": "S4Vectors::Annotated",
        "hash": "9b5b8ee6ad9969f8"
      },
      {
        "key": "S4Vectors::DataFrame",
        "hash": "3b243fae76ac8fcf"
      },
      {
        "key": "S4Vectors::DataFrame_OR_NULL",
        "hash": "89b5479ea6c0bd52"
      },
      {
        "key": "S4Vectors::List",
        "hash": "90a253151dc8db9b"
      },
      {
        "key": "S4Vectors::RectangularData",
        "hash": "d414a10823a4aada"
      },
      {
        "key": "S4Vectors::Vector",
        "hash": "09cab0bd77ae353b"
      },
      {
        "key": "S4Vectors::generic:extractCOLS",
        "hash": "1edc700fe29b167e"
      },
      {
        "key": "S4Vectors::generic:extractROWS",
        "hash": "f13b9aced5b29924"
      },
      {
        "key": "S4Vectors::generic:normalizeSingleBracketReplacementValue",
        "hash": "4d94aae08d61dcb5"
      },
      {
        "key": "S4Vectors::generic:replaceCOLS",
        "hash": "9d89f6091c4d5c40"
      },
      {
        "key": "S4Vectors::generic:replaceROWS",
        "hash": "a40feea23c8faf1e"
      },
      {
        "key": "S4Vectors::list_OR_List",
        "hash": "fcd6e1f6a8d39f9c"
      },
      {
        "key": "S4Vectors::vector_OR_Vector",
        "hash": "f3fc18c9f8ff2633"
      }
    ]
  },
  "_rbuild": "4.6.2",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/manual.pdf",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/SQLDataFrame.html",
    "LICENSE"
  ],
  "_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.3802112417116064,
  "_indexed": false,
  "_nocasepkg": "sqldataframe",
  "_universes": [
    "bioc-release"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.26.0",
      "date": "2026-11-01T19:07:48.000Z",
      "distro": "resolute",
      "commit": "cea51320f40b8da387d118a02b25beaefd149f77",
      "fileid": "https://r2.ropensci.org/06b9915d3dc721cfa76493ae9e654271281a4189836159b117be9098a6422249",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/bioc-release/actions/runs/41333205610"
    },
    {
      "r": "4.6.2",
      "os": "linux",
      "version": "1.26.0",
      "date": "2026-11-01T19:07:49.000Z",
      "distro": "resolute",
      "commit": "cea51320f40b8da387d118a02b25beaefd149f77",
      "fileid": "https://r2.ropensci.org/a71f27c09803f8bcc65acb108a726c038f7aa9de8006dd16d4efd68f8a76b349",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/bioc-release/actions/runs/41333205610"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.26.0",
      "date": "2026-11-01T23:24:02.000Z",
      "commit": "cea51320f40b8da387d118a02b25beaefd149f77",
      "fileid": "https://r2.ropensci.org/33a71cf004e1e9b11e8c84a56c664f2d8395ec786ca6991987274c94eea7b567",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/bioc-release/actions/runs/41333205610"
    },
    {
      "r": "4.6.2",
      "os": "mac",
      "version": "1.26.0",
      "date": "2026-11-01T22:50:38.000Z",
      "commit": "cea51320f40b8da387d118a02b25beaefd149f77",
      "fileid": "https://r2.ropensci.org/ea402c69dcdeb8e7f23947fb920d1646538deaac463677a95e1be38ded1aed1d",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/bioc-release/actions/runs/41333205610"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "1.26.0",
      "date": "2026-11-01T19:05:52.000Z",
      "commit": "cea51320f40b8da387d118a02b25beaefd149f77",
      "fileid": "https://r2.ropensci.org/e69d7b0fea9c6411a6a809ce34d601ad8dbda8079f2bed07478e11b1a7c50afb",
      "status": "success",
      "buildurl": "https://github.com/r-universe/bioc-release/actions/runs/41333205610"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.26.0",
      "date": "2026-11-01T18:52:26.000Z",
      "commit": "cea51320f40b8da387d118a02b25beaefd149f77",
      "fileid": "https://r2.ropensci.org/c3783040a5345d83366c9e0d2741758f4ca335c4c5fabd352c2d6facc20c8171",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/bioc-release/actions/runs/41333205610"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "1.26.0",
      "date": "2026-11-01T18:52:37.000Z",
      "commit": "cea51320f40b8da387d118a02b25beaefd149f77",
      "fileid": "https://r2.ropensci.org/abc7d2231817ddbeb9e4225eb6025f392d9e9be030c380af6ed9166743f06fcc",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/bioc-release/actions/runs/41333205610"
    },
    {
      "r": "4.6.2",
      "os": "win",
      "version": "1.26.0",
      "date": "2026-11-01T18:52:32.000Z",
      "commit": "cea51320f40b8da387d118a02b25beaefd149f77",
      "fileid": "https://r2.ropensci.org/792317650a0a7edb92c5f3bd8af8cc4b31869c366a3c595e76ffaab517708b96",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/bioc-release/actions/runs/41333205610"
    }
  ]
}