SQLDataFrame

DOI: 10.18129/B9.bioc.SQLDataFrame    

This is the development version of SQLDataFrame; to use it, please install the devel version of Bioconductor.

Representation of database tables in DataFrame metaphor

Bioconductor version: Development (3.10)

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 <qliu7 at buffalo.edu>

Citation (from within R, enter citation("SQLDataFrame")):

Installation

To install this package, start R (version "3.6") and enter:

if (!requireNamespace("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")

 

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

Details

biocViews DataRepresentation, Infrastructure, Software
Version 0.99.25
In Bioconductor since BioC 3.10 (R-3.6)
License GPL-3
Depends R (>= 3.6), dplyr (>= 0.8.0.1), dbplyr (>= 1.4.0), S4Vectors
Imports DBI, lazyeval, methods, tools, stats, BiocGenerics, RSQLite, tibble
LinkingTo
Suggests 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_0.99.25.tar.gz
Windows Binary SQLDataFrame_0.99.25.zip
Mac OS X 10.11 (El Capitan) SQLDataFrame_0.99.25.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

Documentation »

Bioconductor

R / CRAN packages and documentation

Support »

Please read the posting guide. Post questions about Bioconductor to one of the following locations: