SQLDataFrame

This is the development version of SQLDataFrame; for the stable release version, see SQLDataFrame.

Representation of SQL tables in DataFrame metaphor

Bioconductor version: Development (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")

# The following initializes usage of Bioc devel
BiocManager::install(version='devel')

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.17.1
In Bioconductor since	BioC 3.10 (R-3.6) (4.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.17.1.tar.gz
Windows Binary	SQLDataFrame_1.17.1.zip
macOS Binary (x86_64)	SQLDataFrame_1.17.1.tgz
macOS Binary (arm64)	SQLDataFrame_1.17.1.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