{ "_id": "6ae76b3c1e2c7b3a4f53043f", "Package": "MsBackendSql", "Title": "SQL-based Mass Spectrometry Data Backend", "Version": "1.13.0", "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://bioc.r-universe.dev", "Date/Publication": "2026-04-28 12:59:36 UTC", "RemoteUrl": "https://github.com/bioc/MsBackendSql", "RemoteRef": "HEAD", "RemoteSha": "596d363d1650e7750c49fd32d1c027f5e843d94b", "NeedsCompilation": "no", "Packaged": { "Date": "2026-11-01 14:02:28 UTC", "User": "root" }, "Author": "Johannes Rainer [aut, cre] (ORCID:\n),\nChong Tang [ctb],\nLaurent Gatto [ctb] (ORCID: )", "Maintainer": "Johannes Rainer ", "_user": "bioc", "_type": "src", "_file": "MsBackendSql_1.13.0.tar.gz", "_fileid": "https://r2.ropensci.org/89af356ee56fbeed5d6e62d2d8136e7a0c3f69423e1eb6ab6d857eb265045db4", "_filesize": 183053, "_sha256": "89af356ee56fbeed5d6e62d2d8136e7a0c3f69423e1eb6ab6d857eb265045db4", "_expires": "2027-02-09T16:39:22.000Z", "_created": "2026-11-01T14:02:28.000Z", "_published": "2026-11-01T16:39:24.354Z", "_upstream": "https://github.com/bioc/MsBackendSql", "_status": "failure", "_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 }, "_jobs": [ { "job": 124870717317, "time": 147, "config": "bioc-checks", "r": "4.6.2", "check": "ERROR", "artifact": "13087531201" }, { "job": 124870717333, "time": 291, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "ERROR", "artifact": "13086839367" }, { "job": 124870717328, "time": 298, "config": "linux-release-x86_64", "r": "4.6.2", "check": "ERROR", "artifact": "13087067358" }, { "job": 124870717360, "time": 168, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "ERROR", "artifact": "13092245670" }, { "job": 124870717295, "time": 103, "config": "macos-release-arm64", "r": "4.6.2", "check": "ERROR", "artifact": "13091408703" }, { "job": 124862632194, "time": 235, "config": "source", "r": "4.6.2", "check": "ERROR", "artifact": "13086598166" }, { "job": 124870717353, "time": 132, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "13086778994" }, { "job": 124870717473, "time": 164, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "ERROR", "artifact": "13085978813" }, { "job": 124870717394, "time": 166, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "ERROR", "artifact": "13086434295" }, { "job": 124870717392, "time": 163, "config": "windows-release-x86_64", "r": "4.6.2", "check": "ERROR", "artifact": "13085604550" } ], "_bioccheck": { "error": 1, "warning": 1, "note": 7 }, "_buildurl": "https://github.com/r-universe/bioc/actions/runs/41310267179", "_commit": { "id": "596d363d1650e7750c49fd32d1c027f5e843d94b", "author": "A Wokaty ", "committer": "A Wokaty ", "message": "bump x.y.z version to odd y following creation of RELEASE_3_23 branch\n", "time": 1777381176 }, "_distro": "resolute", "_host": "GitHub-Actions", "_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": "bioc", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2025-45", "n": 2 }, { "week": "2025-49", "n": 1 }, { "week": "2026-06", "n": 1 }, { "week": "2026-18", "n": 2 } ], "_tags": [], "_bioc": [ { "branch": "devel", "version": "1.13.0", "bioc": "3.24", "repository": "bioc" }, { "branch": "release", "version": "1.12.0", "bioc": "3.23", "repository": "bioc" } ], "_topics": [ "infrastructure", "massspectrometry", "metabolomics", "dataimport", "proteomics" ], "_stars": 4, "_contributors": [ { "user": "jorainer", "count": 133, "uuid": 5506112 }, { "user": "jwokaty", "count": 12, "uuid": 1744257 } ], "_userbio": { "uuid": 2286807, "type": "organization", "name": "Bioconductor", "followers": 482, "description": "Software for the analysis and comprehension of high-throughput genomic data" }, "_downloads": { "count": 478, "source": "https://www.bioconductor.org/packages/stats/bioc/MsBackendSql" }, "_devurl": "https://github.com/rformassspectrometry/msbackendsql", "_searchresults": 40, "_abi": { "exports": [ { "key": "MsBackendSql::DBIConnectionOrNULL", "hash": "03f3ccb5fa7de36a" }, { "key": "MsBackendSql::DBIDriverOrNULL", "hash": "2b104033688df370" }, { "key": "MsBackendSql::MsBackendOfflineSql", "hash": "39bd4cd3d8ba7e23" }, { "key": "MsBackendSql::MsBackendSql", "hash": "95ebb505bb7276f1" } ], "imports": [ { "key": "BiocGenerics::generic:dbconn", "hash": "d11436b189efe324" }, { "key": "BiocGenerics::generic:longForm", "hash": "643bc954f7786374" }, { "key": "ProtGenerics::generic:backendBpparam", "hash": "42e79fb5d98efa40" }, { "key": "ProtGenerics::generic:backendInitialize", "hash": "bfc89c8a6990d0ce" }, { "key": "ProtGenerics::generic:backendMerge", "hash": "9b20d104bd93dd10" }, { "key": "ProtGenerics::generic:centroided", "hash": "79b9a0ecc40b23f4" }, { "key": "ProtGenerics::generic:dataStorage", "hash": "e0f310d99253bf4a" }, { "key": "ProtGenerics::generic:extractByIndex", "hash": "4a6240668bd8e916" }, { "key": "ProtGenerics::generic:filterDataOrigin", "hash": "2d927fe15f62893c" }, { "key": "ProtGenerics::generic:filterMsLevel", "hash": "4410856c23dbeebe" }, { "key": "ProtGenerics::generic:filterPrecursorMzRange", "hash": "1e9d7d9d671f3d12" }, { "key": "ProtGenerics::generic:filterPrecursorMzValues", "hash": "43ac596172b08239" }, { "key": "ProtGenerics::generic:filterRt", "hash": "603144ddd4ccf402" }, { "key": "ProtGenerics::generic:intensity", "hash": "5490d2abccdf9667" }, { "key": "ProtGenerics::generic:intensity<-", "hash": "a9f9f16ede19ff8c" }, { "key": "ProtGenerics::generic:mz", "hash": "f925d5e4c0c571d3" }, { "key": "ProtGenerics::generic:mz<-", "hash": "9d17a2894d528a92" }, { "key": "ProtGenerics::generic:peaksData", "hash": "e49026384cce82a1" }, { "key": "ProtGenerics::generic:peaksVariables", "hash": "fa8a37a534eac553" }, { "key": "ProtGenerics::generic:precScanNum", "hash": "cbbcda6646054469" }, { "key": "ProtGenerics::generic:setBackend", "hash": "d76b08666632924b" }, { "key": "ProtGenerics::generic:smoothed", "hash": "75b29ef25b9cf515" }, { "key": "ProtGenerics::generic:spectraData", "hash": "9309e875845317bf" }, { "key": "ProtGenerics::generic:spectraNames", "hash": "88f2b2fdf194b967" }, { "key": "ProtGenerics::generic:spectraNames<-", "hash": "8567acfcabfa13de" }, { "key": "ProtGenerics::generic:supportsSetBackend", "hash": "9773c362aac0070c" }, { "key": "ProtGenerics::generic:tic", "hash": "7e0ee9e3414c182d" }, { "key": "ProtGenerics::generic:uniqueMsLevels", "hash": "7d6eb4823a51123f" }, { "key": "Spectra::MsBackend", "hash": "f0934da3d81a3802" }, { "key": "Spectra::MsBackendCached", "hash": "6ec80a5eba03c577" }, { "key": "Spectra::generic:reset", "hash": "e436f5bf29f95a59" } ] }, "_rbuild": "4.6.2", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/manual.pdf", "extra/MsBackendSql.html", "extra/readme.html", "extra/readme.md" ], "_homeurl": "https://github.com/rformassspectrometry/msbackendsql", "_realowner": "bioc", "_cranurl": false, "_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/bioc/MsBackendSql/raw/HEAD/logo.png", "_readme": "https://github.com/bioc/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" ], "_score": 4.505149978319906, "_indexed": true, "_nocasepkg": "msbackendsql", "_universes": [ "bioc", "jorainer", "rformassspectrometry" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.13.0", "date": "2026-11-01T14:27:12.000Z", "distro": "resolute", "commit": "596d363d1650e7750c49fd32d1c027f5e843d94b", "fileid": "https://r2.ropensci.org/96f0fd81951e6f0c42f44f7f78d773ebd11e24fa4d5792152f05dac1acc6b854", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/bioc/actions/runs/41310267179" }, { "r": "4.6.2", "os": "linux", "version": "1.13.0", "date": "2026-11-01T14:27:07.000Z", "distro": "resolute", "commit": "596d363d1650e7750c49fd32d1c027f5e843d94b", "fileid": "https://r2.ropensci.org/708cb49cf978f0b9f66862b9a1c9375119a23642fd973354917fc2f94d53afc7", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/bioc/actions/runs/41310267179" }, { "r": "4.5.3", "os": "mac", "version": "1.13.0", "date": "2026-11-01T16:37:48.000Z", "commit": "596d363d1650e7750c49fd32d1c027f5e843d94b", "fileid": "https://r2.ropensci.org/b89caa450f114b378b8e2c6bb060b533686891c54baba25898a47f323330d97a", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/bioc/actions/runs/41310267179" }, { "r": "4.6.2", "os": "mac", "version": "1.13.0", "date": "2026-11-01T16:37:12.000Z", "commit": "596d363d1650e7750c49fd32d1c027f5e843d94b", "fileid": "https://r2.ropensci.org/dcc2244737fa1ec9939302889895a6e6ba4f3ffb5c7eca4ce58d33f8d802d7cc", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/bioc/actions/runs/41310267179" }, { "r": "4.6.0", "os": "wasm", "version": "1.13.0", "date": "2026-11-01T14:25:41.000Z", "commit": "596d363d1650e7750c49fd32d1c027f5e843d94b", "fileid": "https://r2.ropensci.org/90d1d07c06e1c64bce2413e8a67e1b0b0034e6b1991e5ee321521bc3620e1a3e", "status": "success", "buildurl": "https://github.com/r-universe/bioc/actions/runs/41310267179" }, { "r": "4.7.0", "os": "win", "version": "1.13.0", "date": "2026-11-01T14:04:21.000Z", "commit": "596d363d1650e7750c49fd32d1c027f5e843d94b", "fileid": "https://r2.ropensci.org/5db09136030424fceb2ee91fe3bd40bc48ed28693259aed6066e3e0754e90f43", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/bioc/actions/runs/41310267179" }, { "r": "4.5.3", "os": "win", "version": "1.13.0", "date": "2026-11-01T14:04:22.000Z", "commit": "596d363d1650e7750c49fd32d1c027f5e843d94b", "fileid": "https://r2.ropensci.org/c101e9a0a0dbda846402cca4a9c2856f2cec9c2a44f91f89484f11b425d2ad6f", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/bioc/actions/runs/41310267179" }, { "r": "4.6.2", "os": "win", "version": "1.13.0", "date": "2026-11-01T14:04:19.000Z", "commit": "596d363d1650e7750c49fd32d1c027f5e843d94b", "fileid": "https://r2.ropensci.org/a5022d5afc50e62b5e5814804a5434acdba746f254ff0e57fb43babf0e7f20c5", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/bioc/actions/runs/41310267179" } ] }