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.
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]
, Aaron Lun [aut], Martin Morgan [aut]
Maintainer: Qian Liu <Qian.Liu at RoswellPark.org>
citation("SQLDataFrame")):
Huber W, Carey VJ, Gentleman R, Anders S, Carlson M, Carvalho BS, Bravo HC, Davis S, Gatto L, Girke T, Gottardo R, Hahne F, Hansen KD, Irizarry RA, Lawrence M, Love MI, MacDonald J, Obenchain V, Oleś AK, Pagès H, Reyes A, Shannon P, Smyth GK, Tenenbaum D, Waldron L, Morgan M (2015). "Orchestrating high-throughput genomic analysis with Bioconductor." Nature Methods, 12(2), 115–121. doi:10.1038/nmeth.3252.
Gentleman RC, Carey VJ, Bates DM, Bolstad B, Dettling M, Dudoit S, Ellis B, Gautier L, Ge Y, Gentry J, Hornik K, Hothorn T, Huber W, Iacus S, Irizarry R, Leisch F, Li C, Maechler M, Rossini AJ, Sawitzki G, Smith C, Smyth G, Tierney L, Yang JYH, Zhang J (2004). "Bioconductor: open software development for computational biology and bioinformatics." Genome Biology, 5(10), R80. doi:10.1186/gb-2004-5-10-r80.
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
| Reference Manual |
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 |
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 | |
| 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 |