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-any)SQLDataFrame_1.26.0.zip(r-4.6-any)SQLDataFrame_1.26.0.zip(r-4.5-any)
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✨
DESCRIPTION |NEWS
card.svg |card.png
SQLDataFrame/json (API)

# 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:

datarepresentation infrastructure software

3.38 score 2 stars 10 scripts 286 downloads 22 exports 29 dependencies

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

Target	Result	Time
bioc-checks	WARNING	150
linux-devel	ERROR	311
source / vignettes	OK	223
linux-release	ERROR	316
macos-release	ERROR	211
macos-oldrel	ERROR	2211
windows-devel	ERROR	179
windows-release	ERROR	167
windows-oldrel	ERROR	180
wasm-release	OK	95

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 rlang RSQLite S4Arrays S4Vectors SparseArray vctrs XVector

Using SQL-backed DataFrames

Rendered fromSQLDataFrame_userguide.Rmdusingknitr::rmarkdown

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