dittodb: A Test Environment for Database Requests (original) (raw)

Testing and documenting code that communicates with remote databases can be painful. Although the interaction with R is usually relatively simple (e.g. data(frames) passed to and from a database), because they rely on a separate service and the data there, testing them can be difficult to set up, unsustainable in a continuous integration environment, or impossible without replicating an entire production cluster. This package addresses that by allowing you to make recordings from your database interactions and then play them back while testing (or in other contexts) all without needing to spin up or have access to the database your code would typically connect to.

Version: 0.1.9
Depends: R (≥ 3.3.0), DBI
Imports: digest, glue, methods, rlang, utils, lifecycle
Suggests: bit64, callr, covr, dplyr, dbplyr, knitr, nycflights13, odbc, RMariaDB, RPostgres, RPostgreSQL, RSQLite, spelling, testthat, withr, rmarkdown
Published: 2025-08-18
DOI: 10.32614/CRAN.package.dittodb
Author: Jonathan Keane ORCID iD [aut, cre], Mauricio Vargas ORCID iD [aut], Helen Miller [rev] (reviewed the package for rOpenSci, see https://github.com/ropensci/software-review/issues/366), Etienne Racine [rev] (reviewed the package for rOpenSci, see https://github.com/ropensci/software-review/issues/366)
Maintainer: Jonathan Keane
BugReports: https://github.com/ropensci/dittodb/issues
License: Apache License (≥ 2.0)
URL: https://dittodb.jonkeane.com/, https://github.com/ropensci/dittodb
NeedsCompilation: no
Language: en-US
Materials: README, NEWS
In views: Databases
CRAN checks: dittodb results

Documentation:

Downloads:

Reverse dependencies:

Linking:

Please use the canonical formhttps://CRAN.R-project.org/package=dittodbto link to this page.