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.5.1
Depends:	R (≥ 3.6.0)
Imports:	checkmate, DBI, dbplyr (≥ 2.4.0), dplyr, glue, methods, openssl, parallelly, purrr, rlang, R6, stringr, tidyr, tidyselect, utils, magrittr
Suggests:	callr, conflicted, devtools, duckdb (≥ 0.10.1), ggplot2, here, jsonlite, knitr, lintr, microbenchmark, odbc, pak, rmarkdown, roxygen2, pkgdown, RPostgres, RSQLite, spelling, testthat (≥ 3.0.0), tibble, tidyverse, withr
Published:	2025-02-27
DOI:	10.32614/CRAN.package.SCDB
Author:	Rasmus Skytte Randløv [aut, cre, rev], Marcus Munch Grünewald [aut], Lasse Engbo Christiansen [rev], Sofia Myrup Otero [rev], Kim Daniel Jacobsen [ctb], Statens Serum Institut [cph, fnd]
Maintainer:	Rasmus Skytte Randløv <rske at ssi.dk>
BugReports:	https://github.com/ssi-dk/SCDB/issues
License:	GPL-3
URL:	https://github.com/ssi-dk/SCDB, https://ssi-dk.github.io/SCDB/
NeedsCompilation:	no
Language:	en-US
Materials:	README, NEWS
CRAN checks:	SCDB results

Documentation:

Reference manual:	SCDB.html , SCDB.pdf
Vignettes:	SCDB: Basic principles (source, R code) SCDB: Benchmarks (source, R code) Slowly Changing Dimension methodology (source, R code)

Downloads:

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

Reverse dependencies:

Reverse imports:

diseasystore

Linking:

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