dbMatrix: Database-Backed Matrix Classes and Operations

Provides S4 classes and methods for storing dense and sparse matrices in 'DuckDB' databases. The package supports constructing database-backed matrices from base R and 'Matrix' objects, extracting slices and summaries, performing arithmetic and selected linear algebra operations, and materializing results for larger-than-memory workflows. It integrates with 'dbProject' to keep database paths, live connections, and lazy matrix tables synchronized across interactive analyses.

Version: 0.1.0
Depends: R (≥ 4.1.0)
Imports: Matrix (≥ 1.6-5), MatrixGenerics (≥ 1.12.3), methods, DBI, dplyr, dbplyr, duckdb (≥ 1.4.0), data.table (≥ 1.12.2), glue, bit64, cli, Rcpp, arrow, nanoarrow, dbProject, rlang
LinkingTo: Rcpp, RcppEigen, RSpectra, nanoarrow
Suggests: knitr, rmarkdown, testthat (≥ 3.0.0), irlba, crayon, R.utils, checkmate, reticulate, sparseMatrixStats, RSpectra
Published: 2026-05-19
DOI: 10.32614/CRAN.package.dbMatrix (may not be active yet)
Author: Edward C. Ruiz ORCID iD [aut, cre], Jiaji George Chen [aut], Ruben Dries [aut]
Maintainer: Edward C. Ruiz <ecr7407 at gmail.com>
BugReports: https://github.com/dbverse-org/dbmatrix-r/issues
License: GPL-3
URL: https://github.com/dbverse-org/dbmatrix-r, https://dbverse-org.github.io/dbmatrix-r/
NeedsCompilation: yes
Materials: README, NEWS
CRAN checks: dbMatrix results

Documentation:

Reference manual: dbMatrix.html , dbMatrix.pdf
Vignettes: Arithmetic (source, R code)
Operations (source, R code)
Overview (source, R code)

Downloads:

Package source: dbMatrix_0.1.0.tar.gz
Windows binaries: r-devel: not available, r-release: not available, r-oldrel: not available
macOS binaries: r-release (arm64): not available, r-oldrel (arm64): not available, r-release (x86_64): not available, r-oldrel (x86_64): not available

Linking:

Please use the canonical form https://CRAN.R-project.org/package=dbMatrix to link to this page.