Package: SQLDataFrame 1.21.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.21.0.tar.gz
SQLDataFrame_1.21.0.zip(r-4.5)SQLDataFrame_1.21.0.zip(r-4.4)SQLDataFrame_1.21.0.zip(r-4.3)
SQLDataFrame_1.21.0.tgz(r-4.4-any)SQLDataFrame_1.21.0.tgz(r-4.3-any)
SQLDataFrame_1.21.0.tar.gz(r-4.5-noble)SQLDataFrame_1.21.0.tar.gz(r-4.4-noble)
SQLDataFrame_1.21.0.tgz(r-4.4-emscripten)SQLDataFrame_1.21.0.tgz(r-4.3-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.21.0(bioc 3.21)SQLDataFrame-1.20.0(bioc 3.20)

datarepresentation infrastructure software

4.51 score 2 stars 5 scripts 130 downloads 22 exports 32 dependencies

Last updated 2 months agofrom:909e7f6597. Checks:OK: 1 WARNING: 6. Indexed: yes.

Target	Result	Date
Doc / Vignettes	OK	Dec 19 2024
R-4.5-win	WARNING	Dec 19 2024
R-4.5-linux	WARNING	Dec 19 2024
R-4.4-win	WARNING	Dec 19 2024
R-4.4-mac	WARNING	Dec 19 2024
R-4.3-win	WARNING	Dec 19 2024
R-4.3-mac	WARNING	Dec 19 2024

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 crayon DBI DelayedArray duckdb fastmap generics glue IRanges lattice lifecycle Matrix MatrixGenerics matrixStats memoise pkgconfig plogr rlang RSQLite S4Arrays S4Vectors SparseArray vctrs XVector zlibbioc

Using SQL-backed DataFrames

Qian Liu, Aaron Lun, Martin Morgan

Rendered fromSQLDataFrame_userguide.Rmdusingknitr::rmarkdownon Dec 19 2024.

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