{ "_id": "6a1ee69fb401979e7341159c", "Package": "dbMatrix", "Title": "Database-Backed Matrix Classes and Operations", "Version": "0.1.0", "Authors@R": "c(person(\"Edward\", \"C. Ruiz\", , \"ecr7407@gmail.com\", role = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0002-9174-5387\")),\nperson(\"Jiaji\", \"George Chen\", email = \"jiajic@bu.edu\", role = c(\"aut\")),\nperson(\"Ruben\", \"Dries\", email = \"rubendries@gmail.com\",role = c(\"aut\")))", "Description": "Provides S4 classes and methods for storing dense and\nsparse matrices in 'DuckDB' databases. The package supports\nconstructing database-backed matrices from base R and 'Matrix'\nobjects, extracting slices and summaries, performing arithmetic\nand selected linear algebra operations, and materializing\nresults for larger-than-memory workflows. It integrates with\n'dbProject' to keep database paths, live connections, and lazy\nmatrix tables synchronized across interactive analyses.", "License": "GPL-3", "Encoding": "UTF-8", "URL": "https://github.com/dbverse-org/dbmatrix-r,\nhttps://dbverse-org.github.io/dbmatrix-r/", "BugReports": "https://github.com/dbverse-org/dbmatrix-r/issues", "RoxygenNote": "7.3.3", "VignetteBuilder": "knitr", "Config/testthat/edition": "3", "NeedsCompilation": "yes", "Packaged": { "Date": "2026-05-19 20:37:52 UTC", "User": "root" }, "Author": "Edward C. Ruiz [aut, cre] (ORCID:\n), Jiaji George Chen\n[aut], Ruben Dries [aut]", "Maintainer": "Edward C. Ruiz ", "Repository": "https://cran.r-universe.dev", "Date/Publication": "2026-05-19 08:30:02 UTC", "RemoteUrl": "https://github.com/cran/dbMatrix", "RemoteRef": "HEAD", "RemoteSha": "233ae9d484a6fccfeab67cc6b147fd3c8a05bce8", "MD5sum": "546c8bcf78448f1ad2a8060c4979aaa3", "_user": "cran", "_type": "src", "_file": "dbMatrix_0.1.0.tar.gz", "_fileid": "3f22332101069bf97f64c22615a2494f0768e98742644f2059af129f401c4a02", "_filesize": 776639, "_sha256": "3f22332101069bf97f64c22615a2494f0768e98742644f2059af129f401c4a02", "_created": "2026-05-19T20:37:52.000Z", "_published": "2026-06-02T14:20:15.844Z", "_distro": "noble", "_jobs": [ { "job": 79092762386, "time": 199, "config": "linux-devel-arm64", "r": "4.7.0", "check": "OK", "artifact": "7094870399" }, { "job": 79092761737, "time": 212, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7094875586" }, { "job": 79092763098, "time": 223, "config": "linux-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7094879464" }, { "job": 79092762720, "time": 217, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7094877411" }, { "job": 79092761040, "time": 257, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7094796882" }, { "job": 79092761157, "time": 139, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7360388080" } ], "_buildurl": "https://github.com/r-universe/cran/actions/runs/26123618910", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/cran/dbMatrix", "_commit": { "id": "233ae9d484a6fccfeab67cc6b147fd3c8a05bce8", "author": "Edward C. Ruiz ", "committer": "cran-robot ", "message": "version 0.1.0\n", "time": 1779179402 }, "_maintainer": { "name": "Edward C. Ruiz", "email": "ecr7407@gmail.com", "login": "ed2uiz", "bluesky": "@ed2uiz.bsky.social", "description": "Open source, spatial omics.", "uuid": 32622519, "orcid": "0000-0002-9174-5387" }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.1.0", "role": "Depends" }, { "package": "Rcpp", "role": "LinkingTo" }, { "package": "RcppEigen", "role": "LinkingTo" }, { "package": "RSpectra", "role": "LinkingTo" }, { "package": "nanoarrow", "role": "LinkingTo" }, { "package": "Matrix", "version": ">= 1.6-5", "role": "Imports" }, { "package": "MatrixGenerics", "version": ">= 1.12.3", "role": "Imports" }, { "package": "methods", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "dplyr", "role": "Imports" }, { "package": "dbplyr", "role": "Imports" }, { "package": "duckdb", "version": ">= 1.4.0", "role": "Imports" }, { "package": "data.table", "version": ">= 1.12.2", "role": "Imports" }, { "package": "glue", "role": "Imports" }, { "package": "bit64", "role": "Imports" }, { "package": "cli", "role": "Imports" }, { "package": "Rcpp", "role": "Imports" }, { "package": "arrow", "role": "Imports" }, { "package": "nanoarrow", "role": "Imports" }, { "package": "dbProject", "role": "Imports" }, { "package": "rlang", "role": "Imports" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" }, { "package": "irlba", "role": "Suggests" }, { "package": "crayon", "role": "Suggests" }, { "package": "R.utils", "role": "Suggests" }, { "package": "checkmate", "role": "Suggests" }, { "package": "reticulate", "role": "Suggests" }, { "package": "sparseMatrixStats", "role": "Suggests" }, { "package": "RSpectra", "role": "Suggests" } ], "_owner": "cran", "_selfowned": false, "_usedby": 0, "_updates": [ { "week": "2026-21", "n": 1 } ], "_tags": [ { "name": "0.1.0", "date": "2026-05-19" } ], "_stars": 0, "_contributors": [ { "user": "ed2uiz", "count": 1, "uuid": 32622519 } ], "_userbio": { "uuid": 6899542, "type": "organization", "name": "cran", "description": "Unofficial read-only mirror of all CRAN R packages" }, "_downloads": { "count": 0, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/dbMatrix" }, "_devurl": "https://github.com/dbverse-org/dbmatrix-r", "_pkgdown": "https://dbverse-org.github.io/dbmatrix-r/", "_searchresults": 6, "_topics": [ "cpp" ], "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/dbMatrix.html", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_cranurl": false, "_releases": [ { "version": "0.1.0", "date": "2026-05-19" } ], "_exports": [ "%in%", "Arith", "as.dbMatrix", "colMeans", "colnames.dbMatrix", "colnames<-.dbMatrix", "colSds", "colSums", "colVars", "db_svd", "dbDenseMatrix", "dbLoad", "dbMatrix", "dbMatrix_from_tbl", "dbSparseMatrix", "head", "Math", "mean", "ncol.dbMatrix", "nrow.dbMatrix", "Ops", "rowMeans", "rownames.dbMatrix", "rownames<-.dbMatrix", "rowSds", "rowSums", "rowVars", "sim_dbDenseMatrix", "sim_dbSparseMatrix", "Summary", "t", "tail", "to_named_ijx_tbl", "writeMM" ], "_help": [ { "page": "extract-dbMatrix", "title": "Extract or replace values in database-backed matrices", "concept": [ "dbMatrix" ], "topics": [ "[,dbMatrix,dbDenseMatrix,dbDenseMatrix,ANY-method", "[,dbMatrix,dbDenseMatrix,missing,ANY-method", "[,dbMatrix,dbIndex,dbIndex,ANY-method", "[,dbMatrix,dbIndex,missing,ANY-method", "[,dbMatrix,dbMatrix,missing,ANY-method", "[,dbMatrix,missing,dbDenseMatrix,ANY-method", "[,dbMatrix,missing,dbIndex,ANY-method", "[<-,dbMatrix,dbMatrix,missing,ANY-method" ] }, { "page": "percent-in", "title": "Value Matching", "concept": [ "transform" ], "topics": [ "%in%,ANY,dbDenseMatrix-method", "%in%,dbDenseMatrix,ANY-method", "%in%,dbSparseMatrix,ANY-method" ] }, { "page": "dbMatrix-methods", "title": "Arith dbMatrix, e2", "topics": [ "Arith,ANY,dbMatrix-method", "Arith,dbMatrix,ANY-method", "Arith,dbMatrix,dbMatrix-method", "dbLoad,DBIConnection-method", "Ops,ANY,dbMatrix-method", "Ops,dbMatrix,ANY-method", "Ops,dbMatrix,dbMatrix-method", "writeMM,dbMatrix-method" ] }, { "page": "as.dbMatrix", "title": "Convert 'Matrix::Matrix' to 'dbMatrix'", "concept": [ "dbMatrix" ], "topics": [ "as.dbMatrix" ] }, { "page": "as.matrix.dbMatrix", "title": "Convert 'dbMatrix' to in-memory matrix", "concept": [ "dbMatrix" ], "topics": [ "as.matrix.dbMatrix" ] }, { "page": "coerce-dbMatrix-dgCMatrix", "title": "Coerce dbMatrix to dgCMatrix", "topics": [ "coerce-dbDenseMatrix-dgCMatrix", "coerce-dbMatrix-dgCMatrix", "coerce-dbSparseMatrix-dgCMatrix" ] }, { "page": "coerce-dbMatrix-matrix", "title": "Coerce dbMatrix to matrix", "topics": [ "coerce-dbDenseMatrix-matrix", "coerce-dbMatrix-matrix", "coerce-dbSparseMatrix-matrix" ] }, { "page": "coerce-matrix-dbMatrix", "title": "Coerce matrix to dbMatrix", "topics": [ "coerce-dgCMatrix-dbMatrix", "coerce-matrix-dbMatrix" ] }, { "page": "row_col_sds", "title": "Row (column) standard deviations for 'dbMatrix' objects", "concept": [ "summary" ], "topics": [ "colSds,dbDenseMatrix-method", "colSds,dbSparseMatrix-method", "rowSds,dbDenseMatrix-method", "rowSds,dbSparseMatrix-method" ] }, { "page": "compute.dbMatrix", "title": "Force computation of a dbMatrix", "topics": [ "compute.dbMatrix" ] }, { "page": "db_svd", "title": "Perform Streaming SVD on a dbMatrix", "topics": [ "db_svd" ] }, { "page": "dbDenseMatrix-class", "title": "S4 Class for 'dbDenseMatrix'", "topics": [ "dbDenseMatrix", "dbDenseMatrix-class" ] }, { "page": "dbMatrix_from_tbl", "title": "dbMatrix_from_tbl", "concept": [ "dbMatrix" ], "topics": [ "dbMatrix_from_tbl" ] }, { "page": "dbMatrix_options", "title": "dbMatrix Package Global Options", "topics": [ "dbMatrix-options", "dbMatrix_options" ] }, { "page": "dbSparseMatrix-class", "title": "S4 Class for dbSparseMatrix", "topics": [ "dbSparseMatrix", "dbSparseMatrix-class" ] }, { "page": "dim-dbMatrix-method", "title": "Dimensions of an Object", "concept": [ "matrix_props" ], "topics": [ "dim,dbMatrix-method" ] }, { "page": "head_tail", "title": "Return the First or Last Parts of an Object", "concept": [ "matrix_props" ], "topics": [ "head,dbMatrix-method", "tail,dbMatrix-method" ] }, { "page": "is.na-dbMatrix-method", "title": "Element-wise is.na for dbMatrix", "concept": [ "transform" ], "topics": [ "is.na,dbMatrix-method" ] }, { "page": "length", "title": "Length of a 'dbMatrix' Object", "concept": [ "matrix_props" ], "topics": [ "length,dbMatrix-method" ] }, { "page": "Math-dbMatrix-method", "title": "Math Operations for 'dbMatrix' Objects", "concept": [ "transform" ], "topics": [ "Math,dbMatrix-method" ] }, { "page": "mean", "title": "Arithmetic Mean for 'dbMatrix' objects", "concept": [ "summary" ], "topics": [ "mean,dbDenseMatrix-method", "mean,dbSparseMatrix-method" ] }, { "page": "names-dbDenseMatrix-method", "title": "The names of a dbMatrix Object", "concept": [ "matrix_props" ], "topics": [ "names,dbDenseMatrix-method" ] }, { "page": "nrow_ncol", "title": "The Number of Rows/Columns of a dbMatrix Object", "concept": [ "matrix_props" ], "topics": [ "ncol.dbMatrix", "nrow.dbMatrix" ] }, { "page": "row_col_means", "title": "Row (column) means for 'dbMatrix' objects", "concept": [ "summary" ], "topics": [ "colMeans,dbMatrix-method", "rowMeans,dbMatrix-method" ] }, { "page": "matrix_props", "title": "Retrieve and Set Row (Column) Dimension Names of dbMatrix Objects", "concept": [ "matrix_props" ], "topics": [ "colnames.dbMatrix", "colnames<-.dbMatrix", "dimnames,dbMatrix-method", "dimnames<-,dbMatrix,list-method", "rownames.dbMatrix", "rownames<-.dbMatrix" ] }, { "page": "row_col_sums", "title": "Row (column) sums for 'dbMatrix' objects", "concept": [ "summary" ], "topics": [ "colSums,dbDenseMatrix-method", "colSums,dbSparseMatrix-method", "rowSums,dbDenseMatrix-method", "rowSums,dbSparseMatrix-method" ] }, { "page": "row_col_vars", "title": "Row (column) variances for 'dbMatrix' objects", "concept": [ "summary" ], "topics": [ "colVars,dbDenseMatrix-method", "colVars,dbSparseMatrix-method", "rowVars,dbDenseMatrix-method", "rowVars,dbSparseMatrix-method" ] }, { "page": "Summary-dbMatrix-method", "title": "Summary Methods for 'dbMatrix' Objects", "concept": [ "summary" ], "topics": [ "Summary,dbMatrix-method" ] }, { "page": "t-dbMatrix", "title": "Matrix Transpose", "concept": [ "transform" ], "topics": [ "t,dbMatrix-method" ] }, { "page": "to_named_ijx_tbl", "title": "Convert dbMatrix to named ijx table", "concept": [ "dbMatrix" ], "topics": [ "to_named_ijx_tbl" ] } ], "_readme": "https://github.com/cran/dbMatrix/raw/HEAD/README.md", "_rundeps": [ "arrow", "askpass", "assertthat", "bit", "bit64", "blob", "cli", "connections", "cpp11", "curl", "data.table", "DBI", "dbplyr", "dbProject", "digest", "dplyr", "duckdb", "fs", "generics", "glue", "httr", "jsonlite", "lattice", "lifecycle", "magrittr", "Matrix", "MatrixGenerics", "matrixStats", "mime", "nanoarrow", "openssl", "pillar", "pins", "pkgconfig", "purrr", "R6", "rappdirs", "Rcpp", "RcppEigen", "rlang", "rscontract", "RSpectra", "stringi", "stringr", "sys", "tibble", "tidyr", "tidyselect", "utf8", "uuid", "vctrs", "whisker", "withr", "yaml" ], "_sysdeps": [ { "shlib": "libstdc++", "package": "libstdc++6", "source": "gcc", "version": "14.2.0-4ubuntu2~24.04.1", "name": "c++", "homepage": "http://gcc.gnu.org/", "description": "GNU Standard C++ Library v3" } ], "_vignettes": [ { "source": "arithmetic.Rmd", "filename": "arithmetic.html", "title": "Arithmetic", "engine": "knitr::rmarkdown", "headings": [ "dbMatrix arithmetic", "Create test data", "Create a dbMatrix object", "Scalar Arithmetic", "Matrix Arithmetic", "Matrix Multiplication", "Hadamard product", "Matrix product", "Cleanup", "Session Info" ], "created": "2026-05-19 08:30:02", "modified": "2026-05-19 08:30:02", "commits": 1 }, { "source": "operations.Rmd", "filename": "operations.html", "title": "Operations", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Loading library", "dbMatrix generics", "dbSparse Matrix Operations", "Create test data", "transpose", "colMeans", "colSums", "rowMeans", "rowSums", "dim", "Check results are equivalent", "dbDenseMatrix Operations", "mean", "Cleanup", "Session Info" ], "created": "2026-05-19 08:30:02", "modified": "2026-05-19 08:30:02", "commits": 1 }, { "source": "overview.Rmd", "filename": "overview.html", "title": "Overview", "engine": "knitr::rmarkdown", "headings": [ "dbMatrix", "Minimal example", "dbSparseMatrix", "dbDenseMatrix" ], "created": "2026-05-19 08:30:02", "modified": "2026-05-19 08:30:02", "commits": 1 } ], "_score": 3.1760912590556813, "_indexed": true, "_nocasepkg": "dbmatrix", "_universes": [ "cran", "ed2uiz", "dbverse-org" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.0", "date": "2026-05-19T20:40:32.000Z", "distro": "noble", "arch": "aarch64", "commit": "233ae9d484a6fccfeab67cc6b147fd3c8a05bce8", "fileid": "f59b5d97a49cb23df33aefd55a70bb42f3f2ca9ad578422f25c5490e4c9f1fcd", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/26123618910" }, { "r": "4.7.0", "os": "linux", "version": "0.1.0", "date": "2026-05-19T20:40:38.000Z", "distro": "noble", "arch": "x86_64", "commit": "233ae9d484a6fccfeab67cc6b147fd3c8a05bce8", "fileid": "86e896818bd0c4b762f4f14b64c6446b916215dbdd2d9dd1fc4c0a1d15800c15", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/26123618910" }, { "r": "4.6.0", "os": "linux", "version": "0.1.0", "date": "2026-05-19T20:40:55.000Z", "distro": "noble", "arch": "aarch64", "commit": "233ae9d484a6fccfeab67cc6b147fd3c8a05bce8", "fileid": "d9c6f6d7a96f4034cbd97945dd9ee5e3c656adb4114fc998d7b4cd5218f07d31", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/26123618910" }, { "r": "4.6.0", "os": "linux", "version": "0.1.0", "date": "2026-05-19T20:40:42.000Z", "distro": "noble", "arch": "x86_64", "commit": "233ae9d484a6fccfeab67cc6b147fd3c8a05bce8", "fileid": "ae76ecb5ff286a699eb72a7dd0166ee6ee4e522d3f091b7a09f96ae34a489b98", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/26123618910" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.0", "date": "2026-06-02T14:19:42.000Z", "arch": "emscripten", "commit": "233ae9d484a6fccfeab67cc6b147fd3c8a05bce8", "fileid": "d7f01b6ebb09141db734657b796ef44c5fe8e1bcdf02f50ba6866b63e0244106", "status": "success", "buildurl": "https://github.com/r-universe/cran/actions/runs/26123618910" } ] }