Package: SQLDataFrame 1.25.0

Qian Liu

SQLDataFrame: Representation of SQL tables in DataFrame metaphor

Implements bindings for SQL tables that are compatible with Bioconductor S4 data structures, namely the DataFrame and DelayedArray. This allows SQL-derived data to be easily used inside other Bioconductor objects (e.g., SummarizedExperiments) while keeping everything on disk.

Authors:Qian Liu [aut, cre], Aaron Lun [aut], Martin Morgan [aut]

SQLDataFrame_1.25.0.tar.gz
SQLDataFrame_1.25.0.zip(r-4.6)SQLDataFrame_1.25.0.zip(r-4.5)SQLDataFrame_1.25.0.zip(r-4.4)
SQLDataFrame_1.25.0.tgz(r-4.5-any)
SQLDataFrame_1.25.0.tar.gz(r-4.6-any)SQLDataFrame_1.25.0.tar.gz(r-4.5-any)
SQLDataFrame_1.25.0.tgz(r-4.5-emscripten)
SQLDataFrame.pdf |SQLDataFrame.html✨
SQLDataFrame/json (API)
NEWS

# Install 'SQLDataFrame' in R:

install.packages('SQLDataFrame', repos = c('https://bioc.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/bioconductor/sqldataframe/issues

On BioConductor:SQLDataFrame-1.25.0(bioc 3.23)SQLDataFrame-1.23.0(bioc 3.22)

datarepresentation infrastructure software

4.20 score 2 stars 5 scripts 266 downloads 22 exports 30 dependencies

Last updated from:bef96d3b5c. Checks:8 ERROR, 2 OK. Indexed: yes.

Target	Result	Total time
bioc-checks	ERROR	163
linux-devel-x86_64	ERROR	222
source / vignettes	OK	263
linux-release-x86_64	ERROR	226
macos-release-arm64	ERROR	170
macos-oldrel-arm64	ERROR	155
windows-devel	ERROR	2753
windows-release	ERROR	2768
windows-oldrel	ERROR	184
wasm-release	OK	122

Exports:acquireConn dbtype DelayedArray DuckDBColumnSeed DuckDBColumnVector DuckDBDataFrame extract_array extractCOLS extractROWS normalizeSingleBracketReplacementValue path releaseConn replaceCOLS replaceROWS SQLColumnSeed SQLColumnVector SQLDataFrame SQLiteColumnSeed SQLiteColumnVector SQLiteDataFrame sqltable type

Dependencies:abind BiocGenerics bit bit64 blob cachem cli cpp11 DBI DelayedArray duckdb fastmap generics glue IRanges lattice lifecycle Matrix MatrixGenerics matrixStats memoise pkgconfig plogr rlang RSQLite S4Arrays S4Vectors SparseArray vctrs XVector

Using SQL-backed DataFrames

Qian Liu, Aaron Lun, Martin Morgan

Rendered fromSQLDataFrame_userguide.Rmdusingknitr::rmarkdownon Nov 26 2025.

Last update: 2024-03-28
Started: 2024-03-28

Citation

Development and contributors

Readme and manuals

Help Manual

Help page	Topics
Acquire the SQL file connection	acquireConn releaseConn
Column of a SQL table	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
SQL-backed DataFrame	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
SQL extensions	DelayedArray,DuckDBColumnSeed-method DelayedArray,SQLiteColumnSeed-method DuckDBColumnSeed-class DuckDBColumnVector-class DuckDBDataFrame-class SQLiteColumnSeed-class SQLiteColumnVector-class SQLiteDataFrame-class