R Observatory: Metrics for dittodb version 0.1.11

Balamuta, James Joseph

doi:10.5281/zenodo.21843040

dittodb

0.1.11Package record

A Test Environment for Database Requests

0packages dependsuggested by 1

12.6Kdownloads / year

82.9%test coverage

13/13flavors OK

Overview

About

Maintained by Jonathan KeaneCRAN page ↗GitHub ↗Website ↗Issues ↗rOpenSci review: issue 366 ↗

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.

Changes in 0.1.11

Established compatibility with DBI 1.3.0 (#197)

From NEWS.md in the release

Install

R (CRAN)pak (dev)Ubuntu (r2u)Fedora (COPR)openSUSE (OBS)

install.packages("dittodb", repos = "https://cloud.r-project.org/")

Installs the current CRAN release. Prebuilt binaries on Windows and macOS.

if (!requireNamespace("pak", quietly = TRUE))
  install.packages("pak", repos = "https://cloud.r-project.org/")
pak::pak("ropensci/dittodb")

Development version from ropensci/dittodb. Installs pak first if it is not already available.

Release

# enable cranapt (r2u) if it is not already set up, then install
grep -rqs r2u.stat.illinois.edu /etc/apt/sources.list /etc/apt/sources.list.d/ \
  || curl -fsSL https://raw.githubusercontent.com/eddelbuettel/r2u/master/inst/scripts/add_cranapt_noble.sh | sudo bash
sudo apt install -y r-cran-dittodb

Fast Ubuntu binaries via r2u (no compilation). The cranapt setup runs once and is skipped when it is already enabled. We list this channel from recorded r2u download activity rather than from a live index of the repository, so treat it as last known rather than guaranteed.

bspm (used by r2u) also needs make: sudo apt install make

# enable the iucar/cran COPR if it is not already present, then install
ls /etc/yum.repos.d/*iucar*cran*.repo >/dev/null 2>&1 \
  || sudo dnf copr enable -y iucar/cran
sudo dnf install -y R-CRAN-dittodb

RPMs from the iucar/cran COPR, rebuilt from CRAN.

For install.packages() integration in R, also: sudo dnf install R-CoprManager

# add the autoCRAN OBS repo (Tumbleweed) if it is missing, then install
zypper -q lr | grep -qi autoCRAN \
  || sudo zypper addrepo https://download.opensuse.org/repositories/devel:/languages:/R:/autoCRAN/openSUSE_Tumbleweed/devel:languages:R:autoCRAN.repo
sudo zypper install -y R-dittodb

RPMs auto-built from CRAN on openSUSE OBS (Tumbleweed). We list this channel from recorded autoCRAN download activity rather than from a live index of the repository, so treat it as last known rather than guaranteed.

Health

CRAN checks

13OK

CRAN check page ↗

Slowest check: 3.2 min · r-oldrel-macos-x86_64

Status changes

OK13 OK2026-08-05
NOTE12 OK, 1 NOTE2026-08-01
OK13 OK2026-06-09
ERROR12 OK, 1 ERROR2026-06-08
OK14 OK2026-03-10

Advisories

none known

How this is measured·How advisories are found

Documentation

In release 0.1.11

READMEYes · 582 wordsVignettesYes · 3 · dynamicNEWSYes · 100% structured · mentions 0.1.11Citation fileNoWebsiteYes · pkgdown

Help pages: 27 (16 internal)
Examples that run: 71%10 run in a plain check · 3 only when donttest examples are enabled (R CMD check --as-cran) · 1 never run
Exported functions with examples: 54%
Documented parameters: 100%
Return-value docs: 88%
Help pages citing references: 0%

Vignettes (3)

How these are measured

Downloads

12.6K

CRAN downloads in the past year

Rank #4,859 · ~35/day · ~1.1K/mo

Releases R versions

Daily download trend is not available in this view yet.

61830 days

1.7K90 days

12.6K1 year

Compare downloads with other packages →

Also on193 r2u6 autocran62 c2d4u

How downloads are counted

Repository

ropensci/dittodb ↗Organization: ropensci

85Stars

15Forks

19Open issues

4Open PRs

12Releases

481Commits

18Commit identities

481 commits · Last activity 2026-02-24 · 0% stars, 30d · Default branch at 0.1.11.9000, ahead of CRAN 0.1.11 (checked 2026-10-21)

Responsiveness

How these are sampled

PRs merged (all time): 97%
Median days to close, 50 most recently updated closed issues: 8
Median days to close, 50 most recently updated closed PRs: 1

Stars over time

2024-12-18 · 792026-07-07 · 85

How these are measured

PracticesBeta

15 development-tooling and community-health practices detected across 8 families in the upstream repository

Checks run against github.com/ropensci/dittodb on 2026-10-21.

Continuous integration (2)

GitHub ActionsR CMD check workflow

The R CMD check workflow runs on Linux, macOS and Windows, and on R-devel

Governance and community (3)

Code of conductContributing guideIssue templates

Docs source (3)

pkgdown

GitHub Pages site last deployed 2026-02-24 · The repository has a site deploy workflow

pkgdown site last built 2026-02-24

Coverage (1)

Coverage reporting (Codecov)

Show all practicesHide 4 practices

CRAN release process (1)

cran-comments.md

Research and citation (1)

codemeta.json

Lint, format, editor (3)

lintrLint workflowRStudio project

Git structural (1)

.gitattributes

How this is detected·Detection ruleset v4 (2026-10-20)

Dependencies

Declared dependencies

21 external dependencies (excludes base and recommended)

Installing dittodb adds 6 packages (4 with compiled code, 2.5 MB of source tarballs). Heaviest: rlang 766 KB, DBI 727 KB, cli 629 KB.

Depends (2)

R >= 3.3.0DBI

Imports (6)

digest gluemethodsrlangutilslifecycle

LinkingTo (0)

none

Suggests (16)

bit64 callr covr dplyr dbplyr knitr nycflights13 odbc RMariaDB RPostgres RPostgreSQL RSQLite spelling testthat withr rmarkdown

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

0direct

0indirect

Suggested by 1

Suggests, most downloaded first

pointblank

How these are counted

Code & Tests

People & History

People (4)

Jonathan Keane

Author, Maintainer since 0.1.0 (2020)

Mauricio Vargas

Author

Helen Miller

Reviewer

reviewed the package for rOpenSci, see https://github.com/ropensci/software-review/issues/366

Etienne Racine

Reviewer

reviewed the package for rOpenSci, see https://github.com/ropensci/software-review/issues/366

Releases (12)

Pick two releases to compare their code metrics.

R
R 4.6.0 released · 2026-04-24
0.1.11Latest
record
2026-02-24 · current release · diff ↗
0.1.10
record
2026-01-11 · diff ↗
0.1.9
record
2025-08-18 · diff ↗
R
R 4.5.0 released · 2025-04-11
R
R 4.4.0 released · 2024-04-24
0.1.8
record
2024-04-09 · diff ↗ ·
added 1 export
check_db_path
0.1.7
record
2023-08-13 · diff ↗ ·
added 1 export
hash_db_object
R
R 4.3.0 released · 2023-04-21
0.1.6
record
2023-04-17 · diff ↗ ·
added 1 export
serialize_bit64
0.1.5
record
2023-04-13 · diff ↗ ·
added 1 export
dbMockConnect
0.1.4
record
2022-06-17 · diff ↗ ·
added 1 export
clean_statement
R
R 4.2.0 released · 2022-04-22
R
R 4.1.0 released · 2021-05-18
0.1.3
record
2020-10-10 · diff ↗
0.1.2
record
2020-10-08 · diff ↗ ·
added 1 export
expect_sql

Show 3 earlier eventsHide 3 earlier events

0.1.1
record
2020-07-29 · diff ↗ ·
added 1 export
check_for_pkg
0.1.0
record
2020-07-24
R
R 4.0.0 released · 2020-04-24

Package metadata

First published: 2020-07-24
Total releases: 12 / 6 yrs
License: Apache License (>= 2.0)
Minimum R: ≥ 3.3.0
Download size: 193 KB

Appears in task views

Databases with R

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("dittodb")

Format

Keane, J., Miller, H., Racine, E., & Vargas, M. (2026). dittodb: A Test Environment for Database Requests (Version 0.1.11) [Computer software]. https://doi.org/10.32614/CRAN.package.dittodb

This package has no citation file, so citation() returns this entry built from DESCRIPTION.

Cite the R Observatory

For a number measured here: a download total, a coverage figure, an archival date.

Format

APA

Balamuta, J. J. (2026). R Observatory: Metrics for dittodb version 0.1.11 [Data set]. HJJB, LLC. Data release v2026-10-24. https://doi.org/10.5281/zenodo.21843040

From data release v2026-10-24, which the citation names so these numbers can be found later. More on citing and the projects behind them.

Report a problem with this page →