Skip to content

MsBackendSql

Bioc current

SQL-based Mass Spectrometry Data Backend

v1.12.0 · Package record · software · Artistic-2.0

Release Lineage

Entered 3.17 · Apr 26, 2023

Current · Requires R 4.6

1.0 In 7 of 49 releases 3.23

Description

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.

Advisories

None published for Bioconductor

Test coverage

Line coverage

–

Expression

–

Tests / Examples

–

Functions

45 3 exported

Complexity

3.2 avg / 12 max

Call network

45 nodes / 62 edges

Test coverage is not measured for Bioconductor packages; nodes fall back to a neutral fill.

Loading call graph…

Lowest coverage

Per-function coverage is not measured for this package yet.

Code

Structure

Lines of code

5,577

Files

14

Compiled share

0%

Has compiled src

No

Language breakdown

R 2,323 (41.7%)Tests 2,172 (38.9%)Docs 628 (11.3%)Vignettes 454 (8.1%)

API

Exported functions

3

Internal functions

41

Testing

Has tests

Yes

Test-to-code ratio

0.93

testthat edition

–

Docs

Roxygen coverage

100%

Health & Security signals

Informational signals; not verdicts.

on.exit coverage

–

Unsafe pattern score

0

Dep constraint coverage

15.4%

Secret pattern count

0

Bundled 3rd-party code

2 items

Portability & License

Min R version

4.2.0

System requirements

–

C++ standard

–

License

Artistic-2.0

License flags

SPDX valid, OSI approved

History

Versions

7

First release

2023-04-27

Latest release

2026-04-28

Avg cadence

181 days

Cold removal rate

–

Dep drift

3

LOC over versions

v3.17: 3,588 LOCv3.18: 3,666 LOCv3.19: 3,895 LOCv3.20: 4,105 LOCv3.21: 4,650 LOCv3.22: 5,569 LOCv3.23: 5,577 LOC

Per-file churn detail lives in the source pipeline: https://github.com/r-observatory/bioc-code-metrics.

Documentation

In the Bioconductor 3.23 release
READMEYes · 242 wordsVignettesYes · 1 · dynamicNEWS· In the Bioconductor git repository, left out of the releaseCitation fileNo
Help pages
2
Examples that run
100%1 run in a plain check
Exported functions with examples
50%
Documented parameters
100%
Return-value docs
50%
Help pages citing references
0%

Repository practices

Upstream repositoryBeta

7 development-tooling and community-health practices detected across 4 families in the upstream repository

Checks run against github.com/rformassspectrometry/msbackendsql on 2026-10-18.

Continuous integration (2)
GitHub ActionsR CMD check workflow

The R CMD check workflow runs on Linux, macOS and Windows, and on R-devel

Docs source (3)
pkgdown

GitHub Pages site last deployed 2026-02-05 · The repository has a site deploy workflow

Coverage (1)
Coverage reporting
Lint, format, editor (1)
EditorConfig
How this is detected·Detection ruleset v3 (2026-09-26)

Topics

Maintainer
Johannes Rainer

Available on

CRANr2uBioconductorautoCRANCOPR

Suggested by (1)

People

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("MsBackendSql")
Rainer, J., Gatto, L., & Tang, C. (2026). MsBackendSql: SQL-based Mass Spectrometry Data Backend (Version 1.12.0) [Computer software]. https://bioconductor.org/packages/MsBackendSql

This package has no citation file, so citation() returns this entry built from DESCRIPTION.

Cite the R Observatory

For a number measured here: a download total, a coverage figure, an archival date.

APA

Balamuta, J. J. (2026). R Observatory: Metrics for MsBackendSql version 1.12.0 [Data set]. HJJB, LLC. Data release v2026-10-21. https://doi.org/10.5281/zenodo.21843040

From data release v2026-10-21, which the citation names so these numbers can be found later. More on citing and the projects behind them.

Report a problem with this page →

Privacy choices

These apply to this browser and are stored on this device only. Nothing about your choice is sent to us.

Read the privacy policy