Package: SQLDataFrame 1.26.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.26.0.tar.gz
SQLDataFrame_1.26.0.zip(r-4.7)SQLDataFrame_1.26.0.zip(r-4.6)SQLDataFrame_1.26.0.zip(r-4.5)
SQLDataFrame_1.26.0.tgz(r-4.6-any)SQLDataFrame_1.26.0.tgz(r-4.5-any)
SQLDataFrame_1.26.0.tar.gz(r-4.7-any)SQLDataFrame_1.26.0.tar.gz(r-4.6-any)
SQLDataFrame_1.26.0.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
card.svg |card.png
SQLDataFrame/json (API)
NEWS

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

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

On CRAN:

Conda:

datarepresentationinfrastructuresoftware

3.42 score 2 stars 11 scripts 229 downloads 22 exports 29 dependencies

Last updated from:cea51320f4 (on RELEASE_3_23). Checks:1 WARNING, 7 ERROR, 2 OK. Indexed: no.

TargetResultTimeFilesSyslog
bioc-checksWARNING162
linux-devel-x86_64ERROR264
source / vignettesOK221
linux-release-x86_64ERROR245
macos-release-arm64ERROR181
macos-oldrel-arm64ERROR134
windows-develERROR226
windows-releaseERROR183
windows-oldrelERROR291
wasm-releaseOK119

Exports:acquireConndbtypeDelayedArrayDuckDBColumnSeedDuckDBColumnVectorDuckDBDataFrameextract_arrayextractCOLSextractROWSnormalizeSingleBracketReplacementValuepathreleaseConnreplaceCOLSreplaceROWSSQLColumnSeedSQLColumnVectorSQLDataFrameSQLiteColumnSeedSQLiteColumnVectorSQLiteDataFramesqltabletype

Dependencies:abindBiocGenericsbitbit64blobcachemclicpp11DBIDelayedArrayduckdbfastmapgenericsglueIRangeslatticelifecycleMatrixMatrixGenericsmatrixStatsmemoisepkgconfigrlangRSQLiteS4ArraysS4VectorsSparseArrayvctrsXVector

Using SQL-backed DataFrames

Qian Liu, Aaron Lun, Martin Morgan

Rendered fromSQLDataFrame_userguide.Rmdusingknitr::rmarkdownon Jun 04 2026.

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

Readme and manuals

Help Manual

Help pageTopics
Acquire the SQL file connectionacquireConn releaseConn
Column of a SQL tableDelayedArray,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 DataFrameas.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 extensionsDelayedArray,DuckDBColumnSeed-method DelayedArray,SQLiteColumnSeed-method DuckDBColumnSeed-class DuckDBColumnVector-class DuckDBDataFrame-class SQLiteColumnSeed-class SQLiteColumnVector-class SQLiteDataFrame-class