DOI: 10.18129/B9.bioc.SQLDataFrame  

This is the development version of SQLDataFrame; for the stable release version, see SQLDataFrame.

Representation of SQL database in DataFrame metaphor

Bioconductor version: Development (3.19)

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.4") and enter:

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

# The following initializes usage of Bioc devel


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.17.0
In Bioconductor since BioC 3.10 (R-3.6) (4 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, GenomicRanges
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.17.0.tar.gz
Windows Binary SQLDataFrame_1.17.0.zip
macOS Binary (x86_64)
macOS Binary (arm64)
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: