DOI: 10.18129/B9.bioc.MsBackendSql  

SQL-based Mass Spectrometry Data Backend

Bioconductor version: Release (3.17)

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.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:



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


biocViews DataImport, Infrastructure, MassSpectrometry, Metabolomics, Proteomics, Software
Version 1.0.1
In Bioconductor since BioC 3.17 (R-4.3) (< 6 months)
License Artistic-2.0
Depends R (>= 4.2.0), Spectra(>= 1.9.12)
Imports BiocParallel, S4Vectors, methods, ProtGenerics, DBI, MsCoreUtils, IRanges, data.table, progress
Suggests testthat, knitr (>= 1.1.0), roxygen2, BiocStyle(>= 2.5.19), RSQLite, msdata, rmarkdown, microbenchmark, mzR
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 MsBackendSql_1.0.1.tar.gz
Windows Binary
macOS Binary (x86_64) MsBackendSql_1.0.1.tgz
macOS Binary (arm64) MsBackendSql_1.0.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.17 Source Archive

Documentation »


R / CRAN packages and documentation

Support »

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