{ "_id": "6a61fcc935834fefe99ec1ec", "Package": "MsBackendSql", "Title": "SQL-based Mass Spectrometry Data Backend", "Version": "1.11.3", "Authors@R": "c(person(given = \"Johannes\", family = \"Rainer\",\nemail = \"Johannes.Rainer@eurac.edu\",\nrole = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0002-6977-7147\")),\nperson(given = \"Chong\", family = \"Tang\",\nemail = \"chong.tang@uclouvain.be\",\nrole = \"ctb\"),\nperson(given = \"Laurent\", family = \"Gatto\",\nemail = \"laurent.gatto@uclouvain.be\",\nrole = \"ctb\",\ncomment = c(ORCID = \"0000-0002-1520-2268\")))", "Description": "SQL-based mass spectrometry (MS) data backend supporting\nalso storange and handling of very large data sets. Objects\nfrom this package are supposed to be used with the Spectra\nBioconductor package. Through the MsBackendSql with its minimal\nmemory footprint, this package thus provides an alternative MS\ndata representation for very large or remote MS data sets.", "License": "Artistic-2.0", "Encoding": "UTF-8", "VignetteBuilder": "knitr", "BugReports": "https://github.com/RforMassSpectrometry/MsBackendSql/issues", "URL": "https://github.com/RforMassSpectrometry/MsBackendSql", "biocViews": "Infrastructure, MassSpectrometry, Metabolomics, DataImport,\nProteomics", "Roxygen": "list(markdown=TRUE)", "RoxygenNote": "7.3.3", "Collate": "'MsBackendSql-functions.R' 'MsBackendSql.R'\n'MsBackendOfflineSql.R'", "Config/pak/sysreqs": "cmake make libicu-dev libuv1-dev", "Repository": "https://rformassspectrometry.r-universe.dev", "Date/Publication": "2026-02-05 09:55:08 UTC", "RemoteUrl": "https://github.com/rformassspectrometry/msbackendsql", "RemoteRef": "HEAD", "RemoteSha": "9b5f2feb56547eb85ef4022d252107fd5a1f4175", "NeedsCompilation": "no", "Packaged": { "Date": "2026-07-23 11:09:08 UTC", "User": "root" }, "Author": "Johannes Rainer [aut, cre] (ORCID:\n),\nChong Tang [ctb],\nLaurent Gatto [ctb] (ORCID: )", "Maintainer": "Johannes Rainer ", "_user": "rformassspectrometry", "_type": "src", "_file": "MsBackendSql_1.11.3.tar.gz", "_fileid": "https://r2.ropensci.org/2b7fc0ca0550228922b6bfded63b1d331ee3ef942141a01a1422925fe8ba9404", "_filesize": 200297, "_sha256": "2b7fc0ca0550228922b6bfded63b1d331ee3ef942141a01a1422925fe8ba9404", "_expires": "2026-10-31T11:36:39.000Z", "_created": "2026-07-23T11:09:08.000Z", "_published": "2026-07-23T11:36:41.413Z", "_jobs": [ { "job": 89189333984, "time": 592, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "8561647566" }, { "job": 89189334026, "time": 955, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "8561802796" }, { "job": 89189334032, "time": 378, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "8561862912" }, { "job": 89189334028, "time": 836, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "8562078676" }, { "job": 89188341149, "time": 285, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "8561384556" }, { "job": 89189333958, "time": 147, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "8561450294" }, { "job": 89189333993, "time": 694, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "8561691446" }, { "job": 89189334018, "time": 670, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "8561681037" }, { "job": 89189334192, "time": 698, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "8561693679" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/rformassspectrometry/actions/runs/30001741594", "_status": "success", "_upstream": "https://github.com/rformassspectrometry/msbackendsql", "_commit": { "id": "9b5f2feb56547eb85ef4022d252107fd5a1f4175", "author": "Johannes Rainer <5506112+jorainer@users.noreply.github.com>", "committer": "GitHub ", "message": "Merge pull request #37 from rformassspectrometry/jomain\n\nReplace msdata by MsDataHub", "time": 1770285308 }, "_maintainer": { "name": "Johannes Rainer", "email": "johannes.rainer@eurac.edu", "login": "jorainer", "mastodon": "@jorainer@fediscience.org", "bluesky": "@jorainer.bsky.social", "linkedin": "in/jorainer", "orcid": "0000-0002-6977-7147", "description": "Computational Mass Spectrometry and Metabolomics, mostly; love R coding and Emacs; member of the Bioconductor Community Advisory Board.", "uuid": 5506112 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.2.0", "role": "Depends" }, { "package": "Spectra", "version": ">= 1.19.8", "role": "Depends" }, { "package": "BiocParallel", "role": "Imports" }, { "package": "S4Vectors", "role": "Imports" }, { "package": "methods", "role": "Imports" }, { "package": "ProtGenerics", "version": ">= 1.35.3", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "MsCoreUtils", "role": "Imports" }, { "package": "IRanges", "role": "Imports" }, { "package": "data.table", "role": "Imports" }, { "package": "progress", "role": "Imports" }, { "package": "stringi", "role": "Imports" }, { "package": "fastmatch", "role": "Imports" }, { "package": "BiocGenerics", "role": "Imports" }, { "package": "testthat", "role": "Suggests" }, { "package": "knitr", "version": ">= 1.1.0", "role": "Suggests" }, { "package": "roxygen2", "role": "Suggests" }, { "package": "BiocStyle", "version": ">= 2.5.19", "role": "Suggests" }, { "package": "RSQLite", "role": "Suggests" }, { "package": "MsDataHub", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "microbenchmark", "role": "Suggests" }, { "package": "mzR", "role": "Suggests" } ], "_owner": "rformassspectrometry", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2025-35", "n": 1 }, { "week": "2025-41", "n": 1 }, { "week": "2025-42", "n": 1 }, { "week": "2025-43", "n": 1 }, { "week": "2025-45", "n": 2 }, { "week": "2025-49", "n": 1 }, { "week": "2026-06", "n": 1 } ], "_tags": [], "_bioc": [ { "branch": "devel", "version": "1.13.0", "bioc": "3.24" }, { "branch": "release", "version": "1.12.0", "bioc": "3.23" } ], "_topics": [ "infrastructure", "massspectrometry", "metabolomics", "dataimport", "proteomics" ], "_stars": 4, "_contributors": [ { "user": "jorainer", "count": 133, "uuid": 5506112 }, { "user": "jwokaty", "count": 12, "uuid": 1744257 } ], "_userbio": { "uuid": 51361942, "type": "organization", "name": "RforMassSpectrometry", "followers": 105, "description": "R packages for mass spectrometry" }, "_downloads": { "count": 0, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/MsBackendSql" }, "_devurl": "https://github.com/rformassspectrometry/msbackendsql", "_searchresults": 33, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/MsBackendSql.html", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_homeurl": "https://github.com/rformassspectrometry/msbackendsql", "_realowner": "bioc", "_cranurl": true, "_exports": [ "backendInitialize", "backendMerge", "centroided", "createMsBackendSqlDatabase", "dataStorage", "extractByIndex", "filterDataOrigin", "filterMsLevel", "filterPrecursorMzRange", "filterPrecursorMzValues", "filterRt", "intensity", "intensity<-", "longForm", "MsBackendOfflineSql", "MsBackendSql", "mz", "mz<-", "peaksData", "peaksVariables", "precScanNum", "reset", "show", "smoothed", "spectraData", "spectraNames", "spectraNames<-", "supportsSetBackend", "tic", "uniqueMsLevels" ], "_help": [ { "page": "MsBackendOfflineSql", "title": "SQL-based MS backend without active database connection", "topics": [ "backendInitialize,MsBackendOfflineSql-method", "MsBackendOfflineSql", "MsBackendOfflineSql-class" ] }, { "page": "MsBackendSql", "title": "'Spectra' MS backend storing data in a SQL database", "topics": [ "$<-,MsBackendSql-method", "backendBpparam,MsBackendSql-method", "backendInitialize,MsBackendSql-method", "backendMerge,MsBackendOfflineSql-method", "backendMerge,MsBackendSql-method", "centroided,MsBackendSql-method", "createMsBackendSqlDatabase", "dataStorage,MsBackendOfflineSql-method", "dataStorage,MsBackendSql-method", "dbconn,MsBackendOfflineSql-method", "dbconn,MsBackendSql-method", "extractByIndex,MsBackendSql,ANY-method", "filterDataOrigin,MsBackendOfflineSql-method", "filterDataOrigin,MsBackendSql-method", "filterMsLevel,MsBackendOfflineSql-method", "filterMsLevel,MsBackendSql-method", "filterPrecursorMzRange,MsBackendOfflineSql-method", "filterPrecursorMzRange,MsBackendSql-method", "filterPrecursorMzValues,MsBackendOfflineSql-method", "filterPrecursorMzValues,MsBackendSql-method", "filterRt,MsBackendOfflineSql-method", "filterRt,MsBackendSql-method", "intensity,MsBackendOfflineSql-method", "intensity,MsBackendSql-method", "intensity<-,MsBackendSql-method", "longForm,MsBackendOfflineSql-method", "longForm,MsBackendSql-method", "MsBackendSql", "MsBackendSql-class", "mz,MsBackendOfflineSql-method", "mz,MsBackendSql-method", "mz<-,MsBackendSql-method", "peaksData,MsBackendOfflineSql-method", "peaksData,MsBackendSql-method", "peaksVariables,MsBackendOfflineSql-method", "peaksVariables,MsBackendSql-method", "precScanNum,MsBackendSql-method", "reset,MsBackendOfflineSql-method", "reset,MsBackendSql-method", "show,MsBackendOfflineSql-method", "show,MsBackendSql-method", "smoothed,MsBackendSql-method", "spectraData,MsBackendOfflineSql-method", "spectraData,MsBackendSql-method", "spectraNames,MsBackendSql-method", "spectraNames<-,MsBackendSql-method", "supportsSetBackend,MsBackendOfflineSql-method", "supportsSetBackend,MsBackendSql-method", "tic,MsBackendOfflineSql-method", "tic,MsBackendSql-method", "uniqueMsLevels,MsBackendOfflineSql-method", "uniqueMsLevels,MsBackendSql-method", "[,MsBackendSql-method" ] } ], "_pkglogo": "https://github.com/rformassspectrometry/msbackendsql/raw/HEAD/logo.png", "_readme": "https://github.com/rformassspectrometry/msbackendsql/raw/HEAD/README.md", "_rundeps": [ "BH", "BiocGenerics", "BiocParallel", "cli", "clue", "cluster", "codetools", "cpp11", "crayon", "data.table", "DBI", "fastmatch", "formatR", "fs", "futile.logger", "futile.options", "generics", "glue", "hms", "IRanges", "lambda.r", "lifecycle", "MASS", "MetaboCoreUtils", "MsCoreUtils", "pkgconfig", "prettyunits", "progress", "ProtGenerics", "R6", "Rcpp", "rlang", "S4Vectors", "snow", "Spectra", "stringi", "vctrs" ], "_vignettes": [ { "source": "MsBackendSql.Rmd", "filename": "MsBackendSql.html", "title": "Storing Mass Spectrometry Data in SQL Databases", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Installation", "Creating and using MsBackendSql SQL databases", "Performance considerations", "Database systems and data storage modes", "Database systems", "MsBackendSql database layouts/storage modes", "Performance comparison with other backends", "Considerations for database systems/servers", "Other properties of the MsBackendSql", "Summary", "Session information" ], "created": "2022-11-16 15:38:14", "modified": "2026-02-05 09:55:08", "commits": 15 } ], "_score": 5.664641975556126, "_indexed": false, "_nocasepkg": "msbackendsql", "_universes": [ "rformassspectrometry" ], "_indexurl": "https://bioc.r-universe.dev/MsBackendSql", "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.11.3", "date": "2026-07-23T11:12:06.000Z", "distro": "resolute", "commit": "9b5f2feb56547eb85ef4022d252107fd5a1f4175", "fileid": "https://r2.ropensci.org/40062a36f7c946a6c6f0ec210e95163ab61623d29f7260a8dc80db0f7017709c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/rformassspectrometry/actions/runs/30001741594" }, { "r": "4.6.1", "os": "linux", "version": "1.11.3", "date": "2026-07-23T11:12:10.000Z", "distro": "resolute", "commit": "9b5f2feb56547eb85ef4022d252107fd5a1f4175", "fileid": "https://r2.ropensci.org/0426c440e530041f198cbb76dee6577024c105a52cfa4180ffe9e3127e1dac01", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/rformassspectrometry/actions/runs/30001741594" }, { "r": "4.5.3", "os": "mac", "version": "1.11.3", "date": "2026-07-23T11:22:57.000Z", "commit": "9b5f2feb56547eb85ef4022d252107fd5a1f4175", "fileid": "https://r2.ropensci.org/611c643e46b8c4faeeca2ad5018b3e7f5cefb48baea7fbf0afb6fe3b627806a9", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/rformassspectrometry/actions/runs/30001741594" }, { "r": "4.6.1", "os": "mac", "version": "1.11.3", "date": "2026-07-23T11:23:46.000Z", "commit": "9b5f2feb56547eb85ef4022d252107fd5a1f4175", "fileid": "https://r2.ropensci.org/23b589247f5ddefd7fe19eb3e1d04607737fbf835d7c318699285b53555d4aa5", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/rformassspectrometry/actions/runs/30001741594" }, { "r": "4.6.0", "os": "wasm", "version": "1.11.3", "date": "2026-07-23T11:12:00.000Z", "commit": "9b5f2feb56547eb85ef4022d252107fd5a1f4175", "fileid": "https://r2.ropensci.org/88388d162b85abe78c54c0dcf979c8b911f330ac0efe58a94b95024e8e625696", "status": "success", "buildurl": "https://github.com/r-universe/rformassspectrometry/actions/runs/30001741594" }, { "r": "4.7.0", "os": "win", "version": "1.11.3", "date": "2026-07-23T11:11:04.000Z", "commit": "9b5f2feb56547eb85ef4022d252107fd5a1f4175", "fileid": "https://r2.ropensci.org/9d9f7e85b2ed0b9a7fe91fb276a2ca79fca0b422da732d55056aad8783c0b4ec", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/rformassspectrometry/actions/runs/30001741594" }, { "r": "4.5.3", "os": "win", "version": "1.11.3", "date": "2026-07-23T11:11:20.000Z", "commit": "9b5f2feb56547eb85ef4022d252107fd5a1f4175", "fileid": "https://r2.ropensci.org/5ff6f38bf0d3d1febf10a8fc7e0e369f6d2ecaf578b74911b9c4fc1b6eeb5381", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/rformassspectrometry/actions/runs/30001741594" }, { "r": "4.6.1", "os": "win", "version": "1.11.3", "date": "2026-07-23T11:10:57.000Z", "commit": "9b5f2feb56547eb85ef4022d252107fd5a1f4175", "fileid": "https://r2.ropensci.org/136c5bc54b1a9917b4c7031d090a3d652485656d42fea772d18fdfb152158042", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/rformassspectrometry/actions/runs/30001741594" } ] }