SQLDataFrame
This package is for version 3.18 of Bioconductor; for the stable, up-to-date release version, see SQLDataFrame.
Representation of SQL database in DataFrame metaphor
Bioconductor version: 3.18
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.3") 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.16.1 |
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, GenomicRanges |
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.16.1.tar.gz |
Windows Binary | SQLDataFrame_1.16.1.zip |
macOS Binary (x86_64) | SQLDataFrame_1.16.1.tgz |
macOS Binary (arm64) | SQLDataFrame_1.16.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 |
Old Source Packages for BioC 3.18 | Source Archive |