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

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

Version: 0.2
Imports: checkmate, DBI, dbplyr, dplyr, glue, lubridate, methods, openssl, purrr, rlang, R6, RSQLite, stringr, tidyr, tidyselect, tidyverse, utils
Suggests: conflicted, knitr, rmarkdown, RPostgres, roxygen2, spelling, testthat (≥ 3.0.0), tibble
Published: 2023-09-26
Author: Rasmus Skytte Randløv ORCID iD [aut, cre], Marcus Munch Grünewald ORCID iD [aut]
Maintainer: Rasmus Skytte Randløv <rske at>
License: GPL-3
NeedsCompilation: no
Language: en-US
Materials: README NEWS
CRAN checks: SCDB results


Reference manual: SCDB.pdf
Vignettes: Basic principles


Package source: SCDB_0.2.tar.gz
Windows binaries: r-devel:, r-release:, r-oldrel:
macOS binaries: r-release (arm64): SCDB_0.2.tgz, r-oldrel (arm64): SCDB_0.2.tgz, r-release (x86_64): SCDB_0.2.tgz, r-oldrel (x86_64): SCDB_0.2.tgz
Old sources: SCDB archive


Please use the canonical form to link to this page.