Registration and Call for Abstracts Open for Bioc2024


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>

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


To install this package, start R (version "4.3") 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:

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.16.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
Bug Reports
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.16.1.tar.gz
Windows Binary
macOS Binary (x86_64) SQLDataFrame_1.16.1.tgz
macOS Binary (arm64) SQLDataFrame_1.16.1.tgz
Source Repository git clone
Source Repository (Developer Access) git clone
Bioc Package Browser
Package Short Url
Package Downloads Report Download Stats
Old Source Packages for BioC 3.18 Source Archive