SQLDataFrame

DOI: 10.18129/B9.bioc.SQLDataFrame    

Representation of SQL database in DataFrame metaphor

Bioconductor version: Release (3.15)

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>

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")

 

HTML	R Script	SQLDataFrame Internal Implementation
HTML	R Script	SQLDataFrame: Lazy representation of SQL database in DataFrame metaphor
PDF		Reference Manual
Text		NEWS

Details

biocViews	DataRepresentation, Infrastructure, Software
Version	1.10.3
In Bioconductor since	BioC 3.10 (R-3.6) (3 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
LinkingTo
Suggests	RMySQL, bigrquery, testthat, knitr, rmarkdown, DelayedArray
SystemRequirements
Enhances
URL	https://github.com/Bioconductor/SQLDataFrame
BugReports	https://github.com/Bioconductor/SQLDataFrame/issues
Depends On Me
Imports Me
Suggests Me
Links To Me
Build Report

Package Archives

Follow Installation instructions to use this package in your R session.

Source Package	SQLDataFrame_1.10.3.tar.gz
Windows Binary	SQLDataFrame_1.10.3.zip
macOS Binary (x86_64)	SQLDataFrame_1.10.3.tgz
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
Old Source Packages for BioC 3.15	Source Archive