Registration Open for Bioc2024 July 24-26


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

SQL-based Mass Spectrometry Data Backend

Bioconductor version: Development (3.20)

SQL-based mass spectrometry (MS) data backend supporting also storange and handling of very large data sets. Objects from this package are supposed to be used with the Spectra Bioconductor package. Through the MsBackendSql with its minimal memory footprint, this package thus provides an alternative MS data representation for very large or remote MS data sets.

Author: Johannes Rainer [aut, cre] , Chong Tang [ctb], Laurent Gatto [ctb]

Maintainer: Johannes Rainer <Johannes.Rainer at>

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


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:

Storing Mass Spectrometry Data in SQL Databases HTML R Script
Reference Manual PDF


biocViews DataImport, Infrastructure, MassSpectrometry, Metabolomics, Proteomics, Software
Version 1.5.0
In Bioconductor since BioC 3.17 (R-4.3) (1 year)
License Artistic-2.0
Depends R (>= 4.2.0), Spectra(>= 1.9.12)
Imports BiocParallel, S4Vectors, methods, ProtGenerics(>= 1.35.3), DBI, MsCoreUtils, IRanges, data.table, progress, BiocGenerics
System Requirements
Bug Reports
See More
Suggests testthat, knitr (>= 1.1.0), roxygen2, BiocStyle(>= 2.5.19), RSQLite, msdata, rmarkdown, microbenchmark, mzR
Linking To
Depends On Me
Imports Me
Suggests Me MsExperiment
Links To Me
Build Report Build Report

Package Archives

Follow Installation instructions to use this package in your R session.

Source Package MsBackendSql_1.5.0.tar.gz
Windows Binary
macOS Binary (x86_64) MsBackendSql_1.5.0.tgz
macOS Binary (arm64) MsBackendSql_1.5.0.tgz
Source Repository git clone
Source Repository (Developer Access) git clone
Bioc Package Browser
Package Short Url
Package Downloads Report Download Stats