SQLDataFrame
This package is for version 3.16 of Bioconductor; for the stable, up-to-date release version, see SQLDataFrame.
Representation of SQL database in DataFrame metaphor
Bioconductor version: 3.16
SQLDataFrame is developed to lazily represent and efficiently analyze SQL-based tables in _R_. SQLDataFrame supports common and familiar 'DataFrame' operations such as '[' subsetting, rbind, cbind, etc.. The internal implementation is based on the widely adopted dplyr grammar and SQL commands. In-memory datasets or plain text files (.txt, .csv, etc.) could also be easily converted into SQLDataFrames objects (which generates a new database on-disk).
Author: Qian Liu [aut, cre] 
, Martin Morgan [aut]
Maintainer: Qian Liu <qian.liu at roswellpark.org>
citation("SQLDataFrame")):
Installation
To install this package, start R (version "4.2") 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")| SQLDataFrame Internal Implementation | HTML | R Script |
| SQLDataFrame: Lazy representation of SQL database in DataFrame metaphor | HTML | R Script |
| Reference Manual | ||
| NEWS | Text |
Details
| biocViews | DataRepresentation, Infrastructure, Software |
| Version | 1.12.0 |
| In Bioconductor since | BioC 3.10 (R-3.6) (4.5 years) |
| License | GPL-3 |
| Depends | R (>= 3.6), dplyr (>= 0.8.0.1), dbplyr (>= 1.4.0), S4Vectors(>= 0.33.3) |
| Imports | DBI, lazyeval, methods, tools, stats, BiocGenerics, RSQLite, tibble |
| System Requirements | |
| URL | https://github.com/Bioconductor/SQLDataFrame |
| Bug Reports | https://github.com/Bioconductor/SQLDataFrame/issues |
See More
| Suggests | RMySQL, bigrquery, testthat, knitr, rmarkdown, DelayedArray |
| 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.12.0.tar.gz |
| Windows Binary | SQLDataFrame_1.12.0.zip |
| macOS Binary (x86_64) | SQLDataFrame_1.12.0.tgz |
| macOS Binary (arm64) | SQLDataFrame_1.12.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.16 | Source Archive |