Registration and Call for Abstracts Open for Bioc2024

SQLDataFrame

Representation of SQL database in DataFrame metaphor


Bioconductor version: Release (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 (from within R, enter 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 PDF
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