SQLDataFrame

This package is for version 3.19 of Bioconductor; for the stable, up-to-date release version, see SQLDataFrame.

Representation of SQL tables in DataFrame metaphor

Bioconductor version: 3.19

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] , Aaron Lun [aut], Martin Morgan [aut]

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

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

Installation

To install this package, start R (version "4.4") 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

To view documentation for the version of this package installed in your system, start R and enter:

browseVignettes("SQLDataFrame")

User guide HTML R Script

Reference Manual PDF

NEWS Text

LICENSE Text

Need some help? Ask on the Bioconductor Support site!

Details

biocViews DataRepresentation, Infrastructure, Software

Version 1.18.0

In Bioconductor since BioC 3.10 (R-3.6) (5 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

Package Archives

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

Source Package SQLDataFrame_1.18.0.tar.gz

Windows Binary (x86_64) SQLDataFrame_1.18.0.zip

macOS Binary (x86_64) SQLDataFrame_1.18.0.tgz

macOS Binary (arm64) SQLDataFrame_1.18.0.tgz

Source Repository git clone https://git.bioconductor.org/packages/SQLDataFrame

Source Repository (Developer Access) git clone git@git.bioconductor.org:packages/SQLDataFrame

Bioc Package Browser https://code.bioconductor.org/browse/SQLDataFrame/

Package Short Url https://bioconductor.org/packages/SQLDataFrame/

Package Downloads Report Download Stats

Old Source Packages for BioC 3.19 Source Archive