dittodb: A Test Environment for Database Requests

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.8
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: 2024-04-09
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 <jkeane at gmail.com>
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:

Reference manual: dittodb.pdf
Vignettes: Developing 'dittodb'
Getting Started with 'dittodb'
nycflights13 data

Downloads:

Package source: dittodb_0.1.8.tar.gz
Windows binaries: r-devel: dittodb_0.1.8.zip, r-release: dittodb_0.1.8.zip, r-oldrel: dittodb_0.1.8.zip
macOS binaries: r-release (arm64): dittodb_0.1.8.tgz, r-oldrel (arm64): dittodb_0.1.8.tgz, r-release (x86_64): dittodb_0.1.8.tgz, r-oldrel (x86_64): dittodb_0.1.8.tgz
Old sources: dittodb archive

Reverse dependencies:

Reverse suggests: pointblank

Linking:

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