SQLDataFrame

Representation of SQL tables in DataFrame metaphor


Bioconductor version: Release (3.20)

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

Details

biocViews DataRepresentation, Infrastructure, Software
Version 1.20.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
See More
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.20.0.tar.gz
Windows Binary (x86_64) SQLDataFrame_1.20.0.zip
macOS Binary (x86_64) SQLDataFrame_1.20.0.tgz
macOS Binary (arm64) SQLDataFrame_1.19.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