DOI: 10.18129/B9.bioc.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 (from within R, enter citation("SQLDataFrame")):


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

if (!require("BiocManager", quietly = TRUE))


For older versions of R, please refer to the appropriate Bioconductor release.


To view documentation for the version of this package installed in your system, start R and enter:



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


biocViews DataRepresentation, Infrastructure, Software
Version 1.12.0
In Bioconductor since BioC 3.10 (R-3.6) (3.5 years)
License GPL-3
Depends R (>= 3.6), dplyr (>=, dbplyr (>= 1.4.0), S4Vectors(>= 0.33.3)
Imports DBI, lazyeval, methods, tools, stats, BiocGenerics, RSQLite, tibble
Suggests RMySQL, bigrquery, testthat, knitr, rmarkdown, DelayedArray
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.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

Documentation »


R / CRAN packages and documentation

Support »

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