Package: SQLDataFrame 1.19.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.19.0.tar.gz
SQLDataFrame_1.19.0.zip(r-4.5)SQLDataFrame_1.19.0.zip(r-4.4)SQLDataFrame_1.19.0.zip(r-4.3)
SQLDataFrame_1.19.0.tgz(r-4.4-any)SQLDataFrame_1.19.0.tgz(r-4.3-any)
SQLDataFrame_1.19.0.tar.gz(r-4.5-noble)SQLDataFrame_1.19.0.tar.gz(r-4.4-noble)
SQLDataFrame_1.19.0.tgz(r-4.4-emscripten)SQLDataFrame_1.19.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.19.0(bioc 3.20)SQLDataFrame-1.18.0(bioc 3.19)

bioconductor-package

22 exports 1.08 score 31 dependencies

Last updated 2 months agofrom:ee7374d822

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 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 Jun 30 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