LoginSign Up
← Back to all sparks
D

dittodb

INFRA · APIS
Velocity0.0

Test environment for database requests in R that records and replays queries

github.com/ropensci/dittodb ↗

dittodb has spent four years on CRAN link fixes and one DBI bump.

database mockingtestingdbidbplyrmaintenance mode
◆Current state
dittodb records and replays database interactions so tests can run without a live database, sitting behind DBI and dbplyr. The visible history splits cleanly in two: functional work through 0.1.8 broadening which databases and situations can be captured, then three consecutive maintenance releases. The most recent adds DBI 1.3.0 compatibility and nothing else.
◆Where it's heading
The functional direction was always coverage: more databases, more situations that can be mocked, better failure messages when the recording setup is wrong. That work stopped after 0.1.8 in 2024, and the package has since only answered CRAN link checks and a DBI release. Full transaction support with separate mock directories was flagged as planned back in 0.1.4 and has not appeared.
◆Prediction
The last three releases are pure upkeep, so the next most likely tracks another DBI or dbplyr change rather than delivering the transaction support still outstanding.

◆Recent moves

  1. 5mo ago

    Compatibility with DBI 1.3.0

    A single-line compatibility release for DBI 1.3.0. The only recent entry that responds to anything other than CRAN's link checker.

    View source ↗
  2. 6mo ago

    Documentation links updated for CRAN checks

    Link updates to satisfy CRAN checks, the second such release in a row. No functional change.

    View source ↗
  3. 11mo ago

    Documentation links updated for new CRAN checks

    Documentation link repairs for a new round of CRAN checks. Marks the start of the maintenance-only stretch.

    View source ↗
  4. 2y ago

    Clearer errors for early connections; dbplyr table names handled

    Improves the error when a connection is opened before start_db_capture(), a common setup mistake, and extends the ignored-table-name list to cover newer dbplyr naming. The last release with functional content.

    View source ↗
  5. 3y ago

    Capture support broadened to unknown databases and Teradata

    Adds contributed capture support for databases the package does not know specifically, with Teradata called out. Directly extends the coverage that determines whether dittodb is usable at a given shop.

    View source ↗
  6. 4y ago

    Mocking works with transactions on; Postgres quoting added

    Allows mocking while transactions are enabled and adds Postgres quoting support. The release notes flag full transaction support across separate mock directories as future work, which has not since arrived.

    View source ↗