SQLDataFrame

This package is deprecated. It will probably be removed from Bioconductor. Please refer to the package end-of-life guidelines for more information.

This package is for version 3.23 of Bioconductor. This package has been removed from Bioconductor. For the last stable, up-to-date release version, see SQLDataFrame.

All versions

3.23 (release), 3.22, 3.21, 3.20, 3.19, 3.18, 3.17, 3.16, 3.15, 3.14, 3.13, 3.12, 3.11, 3.10

Representation of SQL tables in DataFrame metaphor

Bioconductor version: Release (3.23)

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.

Author: Qian Liu [aut, cre] ORCID: 0000-0003-1456-5099 , Aaron Lun [aut], Martin Morgan [aut]

Maintainer: Qian Liu <Qian.Liu at RoswellPark.org>

Citation (from within R, enter citation("SQLDataFrame")):

Qian Liu, Aaron Lun, Martin Morgan. SQLDataFrame: Representation of SQL tables in DataFrame metaphor. doi:10.18129/B9.bioc.SQLDataFrame, R package version 1.26.0, https://bioconductor.org/packages/SQLDataFrame.

Generated from the package metadata; it may differ from the package's own citation.

Installation

To install this package, start R (version "4.6") and enter:

if (!require("BiocManager", quietly = TRUE))
    install.packages("BiocManager")

BiocManager::install("SQLDataFrame")

For older versions of R, please refer to the appropriate Bioconductor release.

Documentation

No vignettes available
Reference Manual	PDF

Need some help? Ask on the Bioconductor Support site!

Details

biocViews	DataRepresentation, Infrastructure, Software
Version	1.26.0
In Bioconductor since	BioC 3.10 (R-3.6) (7 years)
License	LGPL (>= 3); File LICENSE
Depends	DelayedArray, S4Vectors
Imports	stats, utils, methods, BiocGenerics, RSQLite, duckdb, DBI
System Requirements
URL	https://github.com/Bioconductor/SQLDataFrame
Bug Reports	https://github.com/Bioconductor/SQLDataFrame/issues

Suggests	knitr, rmarkdown, BiocStyle, testthat
Linking To
Enhances
Depends On Me
Imports Me
Suggests Me
Links To Me
Build Report	Build Report, r-universe

Package Archives

Follow Installation instructions to use this package in your R session.

Source Package
Windows Binary (x86_64)
macOS Binary (big-sur-x86_64)
macOS Binary (sonoma-arm64)
Source Repository	git clone https://git.bioconductor.org/packages/SQLDataFrame
Source Repository (Developer Access)	git clone git@git.bioconductor.org:packages/SQLDataFrame
Package Short Url	https://bioconductor.org/packages/SQLDataFrame/
Package Downloads Report	Download Stats