Welcome to the new bioconductor.org!


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:

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


biocViews DataRepresentation, Infrastructure, Software
Version 1.17.1
In Bioconductor since BioC 3.10 (R-3.6) (4.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
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
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.17.1.tar.gz
Windows Binary SQLDataFrame_1.17.1.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