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 [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.