R Observatory: Metrics for SCDB version 0.6.2

Balamuta, James Joseph

doi:10.5281/zenodo.21843040

SCDB

0.6.2Package record

Easily Access and Maintain Time-Based Versioned Data (Slowly-Changing-Dimension)

1packages depend

4.9Kdownloads / year

0.0%test coverage

13/13flavors OK

Overview

About

Maintained by Rasmus Skytte RandløvCRAN page ↗GitHub ↗Website ↗Issues ↗Declared funder: Statens Serum Institut

A collection of functions that enable easy access and updating of a database of data over time. More specifically, the package facilitates type-2 history for data-warehouses and provides a number of Quality of life improvements for working on SQL databases with R. For reference see Ralph Kimball and Margy Ross (2013, ISBN 9781118530801).

Changes in 0.6.2

BREAKING CHANGE

SCDB has reduced backwards compatibility to R >= 4.2 (#248).

Improvements and Fixes

Compatibility with dbplyr 2.6.0 (#241).

From NEWS.md in the release

Install

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

install.packages("SCDB", 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("ssi-dk/SCDB")

Development version from ssi-dk/SCDB. 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-scdb

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-SCDB

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-SCDB

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: 6.2 min · r-oldrel-windows-x86_64

Status changes

OK13 OK2026-09-08
ERROR12 OK, 1 ERROR2026-09-07
OK13 OK2026-08-05
NOTE12 OK, 1 NOTE2026-08-01
OK13 OK2026-06-09

Show 2 earlier changesHide 2 earlier changes

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.6.2

READMEYes · 100 wordsVignettesYes · 4 · evaluation depends on the environmentNEWSYes · 100% structured · mentions 0.6.2Citation fileNoWebsiteYes · pkgdown

Help pages: 29 (2 internal)includes a package overview page
Examples that run: 100%28 run in a plain check (21 of them under a condition)
Exported functions with examples: 100%
Documented parameters: 98%
Return-value docs: 100%
Help pages citing references: 0%

Vignettes (4)

SCDB: Basic principles HTML
Batch migration and incremental backups HTML
SCDB: Benchmarks HTML
Slowly Changing Dimension methodology HTML

How these are measured

Downloads

4.9K

CRAN downloads in the past year

Rank #5,976 · ~13/day · ~407/mo

Releases R versions

Daily download trend is not available in this view yet.

58030 days

1.4K90 days

4.9K1 year

Compare downloads with other packages →

Also on110 r2u4 autocran

How downloads are counted

Repository

ssi-dk/scdb ↗Organization: ssi-dk

8Stars

4Forks

14Open issues

7Open PRs

12Releases

1,430Commits

11Commit identities

License file reads as GPL-3.0 · 1,430 commits · Last activity 2026-08-14 · 0% stars, 30d · Default branch at 0.6.2.9000, ahead of CRAN 0.6.2 (checked 2026-10-11)

Responsiveness

How these are sampled

PRs merged (all time): 89%
Median days to close, 50 most recently updated closed issues: 10
Median days to close, 50 most recently updated closed PRs: 2

Stars over time

2024-06-07 · 52026-07-07 · 8

How these are measured

PracticesBeta

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

Checks run against github.com/ssi-dk/scdb on 2026-10-11.

Continuous integration (1)

GitHub Actions

Governance and community (2)

Issue templatesPR template

Docs source (3)

README.Rmdpkgdown

GitHub Pages site last deployed 2025-02-27

pkgdown site last built 2025-02-27, before release 0.6.2 (2026-06-22)

Coverage (1)

Coverage reporting (Codecov)

Show all practicesHide 4 practices

Reproducibility and dev environment (1)

data-raw/

CRAN release process (1)

cran-comments.md

Lint, format, editor (2)

lintrRStudio project

Git structural (1)

.gitattributes

How this is detected·Detection ruleset v3 (2026-09-26)

Dependencies

Declared dependencies

37 external dependencies (excludes base and recommended)

Installing SCDB adds 31 packages (20 with compiled code, 21 MB of source tarballs). Heaviest: stringi 11 MB, openssl 1.1 MB, vctrs 1.0 MB.

Depends (1)

R >= 4.2.0

Imports (17)

checkmate DBI dbplyr dplyr glue lubridatemethodsopenssl parallelly purrr rlang R6 stringr tidyr tidyselectutilsmagrittr

LinkingTo (0)

none

Suggests (22)

callr conflicted devtools duckdb ggplot2 here jsonlite knitr lintr microbenchmark odbc pak rmarkdown roxygen2 pkgdown RPostgres RSQLite spelling testthat tibble tidyverse withr

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

1direct

0indirect

Imports 1

Depends, Imports or LinkingTo, most downloaded first

diseasystore

How these are counted

Code & Tests

Datasets

People & History

People (6)

Rasmus Skytte Randløv

Author, Maintainer since 0.3 (2024), Reviewer

Marcus Munch Grünewald

Author

Lasse Engbo Christiansen

Reviewer, Contributor · added in 0.4.0

Kim Daniel Jacobsen

Contributor · added in 0.5.1

Statens Serum Institut

Copyright holder, Funder · added in 0.3

Sofia Myrup Otero

Reviewer · added in 0.5.0

Previously maintained by Marcus Munch Grünewald (0.2.1) and Rasmus Skytte Randløv (0.1 to 0.2).

Releases (12)

Pick two releases to compare their code metrics.

0.6.2Latest
record
2026-06-22 · current release · diff ↗
0.6.1
record
2026-05-18 · diff ↗
R
R 4.6.0 released · 2026-04-24
0.6.0
record
2026-01-23 · diff ↗ ·
added 2 exports
delta_export, delta_load
0.5.2
record
2026-01-08 · diff ↗
R
R 4.5.0 released · 2025-04-11
0.5.1
record
2025-02-27 · diff ↗
0.5.0
record
2025-02-03 · diff ↗ ·
removed 1 export
interlace_sql

added 2 exports
%>%, create_index
0.4.1
record
2024-10-04 · diff ↗
R
R 4.4.0 released · 2024-04-24
0.4.0
record
2024-03-21 · diff ↗ ·
removed 1 export
%notin%

added 7 exports
LoggerNull, defer_db_cleanup, get_catalog, interlace, lock_table, unique_table_name, unlock_table
0.3
record
2024-01-13 · diff ↗ ·
removed 6 exports
anti_join, full_join, inner_join, left_join, right_join, semi_join
0.2.1
record
2023-11-30 · diff ↗
0.2
record
2023-09-26 · diff ↗
0.1
record
2023-08-28
R
R 4.3.0 released · 2023-04-21

Package metadata

First published: 2023-08-28
Total releases: 12 / 3 yrs
License: GPL-3 OSI
Minimum R: ≥ 4.2.0
Download size: 177 KB

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("SCDB")

Format

Randløv, R. S., Statens Serum Institut, Christiansen, L. E., Grünewald, M. M., Jacobsen, K. D., & Otero, S. M. (2026). SCDB: Easily Access and Maintain Time-Based Versioned Data (Slowly-Changing-Dimension) (Version 0.6.2) [Computer software]. https://doi.org/10.32614/CRAN.package.SCDB

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 SCDB version 0.6.2 [Data set]. HJJB, LLC. Data release v2026-10-18. https://doi.org/10.5281/zenodo.21843040

From data release v2026-10-18, 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 →