Package: dbMatrix 0.1.0
Edward C. Ruiz
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.
Authors:
dbMatrix_0.1.0.tar.gz
dbMatrix_0.1.0.tar.gz(r-4.7-arm64)dbMatrix_0.1.0.tar.gz(r-4.7-x86_64)dbMatrix_0.1.0.tar.gz(r-4.6-arm64)dbMatrix_0.1.0.tar.gz(r-4.6-x86_64)
dbMatrix_0.1.0.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
card.svg |card.png
dbMatrix/json (API)
NEWS
| # Install 'dbMatrix' in R: |
| install.packages('dbMatrix', repos = c('https://cran.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/dbverse-org/dbmatrix-r/issues
Pkgdown/docs site:https://dbverse-org.github.io
Last updated from:233ae9d484. Checks:6 OK. Indexed: yes.
| Target | Result | Time | Files | Syslog |
|---|---|---|---|---|
| linux-devel-arm64 | OK | 199 | ||
| linux-devel-x86_64 | OK | 212 | ||
| source / vignettes | OK | 257 | ||
| linux-release-arm64 | OK | 223 | ||
| linux-release-x86_64 | OK | 217 | ||
| wasm-release | OK | 139 |
Exports:%in%Arithas.dbMatrixcolMeanscolnames.dbMatrixcolnames<-.dbMatrixcolSdscolSumscolVarsdb_svddbDenseMatrixdbLoaddbMatrixdbMatrix_from_tbldbSparseMatrixheadMathmeanncol.dbMatrixnrow.dbMatrixOpsrowMeansrownames.dbMatrixrownames<-.dbMatrixrowSdsrowSumsrowVarssim_dbDenseMatrixsim_dbSparseMatrixSummaryttailto_named_ijx_tblwriteMM
Dependencies:arrowaskpassassertthatbitbit64blobcliconnectionscpp11curldata.tableDBIdbplyrdbProjectdigestdplyrduckdbfsgenericsgluehttrjsonlitelatticelifecyclemagrittrMatrixMatrixGenericsmatrixStatsmimenanoarrowopensslpillarpinspkgconfigpurrrR6rappdirsRcppRcppEigenrlangrscontractRSpectrastringistringrsystibbletidyrtidyselectutf8uuidvctrswhiskerwithryaml
Arithmetic
Rendered fromarithmetic.Rmdusingknitr::rmarkdownon May 19 2026.Last update: 2026-05-19
Started: 2026-05-19
Operations
Rendered fromoperations.Rmdusingknitr::rmarkdownon May 19 2026.Last update: 2026-05-19
Started: 2026-05-19
Overview
Rendered fromoverview.Rmdusingknitr::rmarkdownon May 19 2026.Last update: 2026-05-19
Started: 2026-05-19
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| Extract or replace values in database-backed matrices | [,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 |
| Value Matching | %in%,ANY,dbDenseMatrix-method %in%,dbDenseMatrix,ANY-method %in%,dbSparseMatrix,ANY-method |
| Arith dbMatrix, e2 | 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 |
| Convert 'Matrix::Matrix' to 'dbMatrix' | as.dbMatrix |
| Convert 'dbMatrix' to in-memory matrix | as.matrix.dbMatrix |
| Coerce dbMatrix to dgCMatrix | coerce-dbDenseMatrix-dgCMatrix coerce-dbMatrix-dgCMatrix coerce-dbSparseMatrix-dgCMatrix |
| Coerce dbMatrix to matrix | coerce-dbDenseMatrix-matrix coerce-dbMatrix-matrix coerce-dbSparseMatrix-matrix |
| Coerce matrix to dbMatrix | coerce-dgCMatrix-dbMatrix coerce-matrix-dbMatrix |
| Row (column) standard deviations for 'dbMatrix' objects | colSds,dbDenseMatrix-method colSds,dbSparseMatrix-method rowSds,dbDenseMatrix-method rowSds,dbSparseMatrix-method |
| Force computation of a dbMatrix | compute.dbMatrix |
| Perform Streaming SVD on a dbMatrix | db_svd |
| S4 Class for 'dbDenseMatrix' | dbDenseMatrix dbDenseMatrix-class |
| dbMatrix_from_tbl | dbMatrix_from_tbl |
| dbMatrix Package Global Options | dbMatrix-options dbMatrix_options |
| S4 Class for dbSparseMatrix | dbSparseMatrix dbSparseMatrix-class |
| Dimensions of an Object | dim,dbMatrix-method |
| Return the First or Last Parts of an Object | head,dbMatrix-method tail,dbMatrix-method |
| Element-wise is.na for dbMatrix | is.na,dbMatrix-method |
| Length of a 'dbMatrix' Object | length,dbMatrix-method |
| Math Operations for 'dbMatrix' Objects | Math,dbMatrix-method |
| Arithmetic Mean for 'dbMatrix' objects | mean,dbDenseMatrix-method mean,dbSparseMatrix-method |
| The names of a dbMatrix Object | names,dbDenseMatrix-method |
| The Number of Rows/Columns of a dbMatrix Object | ncol.dbMatrix nrow.dbMatrix |
| Row (column) means for 'dbMatrix' objects | colMeans,dbMatrix-method rowMeans,dbMatrix-method |
| Retrieve and Set Row (Column) Dimension Names of dbMatrix Objects | colnames.dbMatrix colnames<-.dbMatrix dimnames,dbMatrix-method dimnames<-,dbMatrix,list-method rownames.dbMatrix rownames<-.dbMatrix |
| Row (column) sums for 'dbMatrix' objects | colSums,dbDenseMatrix-method colSums,dbSparseMatrix-method rowSums,dbDenseMatrix-method rowSums,dbSparseMatrix-method |
| Row (column) variances for 'dbMatrix' objects | colVars,dbDenseMatrix-method colVars,dbSparseMatrix-method rowVars,dbDenseMatrix-method rowVars,dbSparseMatrix-method |
| Summary Methods for 'dbMatrix' Objects | Summary,dbMatrix-method |
| Matrix Transpose | t,dbMatrix-method |
| Convert dbMatrix to named ijx table | to_named_ijx_tbl |
