SCDB

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

v0.6.0 · Jan 23, 2026 · GPL-3

Description

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

Downloads

411

Last 30 days

9184th

1.4K

Last 90 days

3.5K

Last year

Trend: +25.7% (30d vs prior 30d)

CRAN Check Status

14 OK

Show all 14 flavors

Flavor	Status	Time
r-devel-linux-x86_64-debian-clang	OK	344.1s
r-devel-linux-x86_64-debian-gcc	OK	231.6s
r-devel-linux-x86_64-fedora-clang	OK	530.5s
r-devel-linux-x86_64-fedora-gcc	OK	643.1s
r-devel-macos-arm64	OK	77s
r-devel-windows-x86_64	OK	306s
r-oldrel-macos-arm64	OK	84s
r-oldrel-macos-x86_64	OK	458s
r-oldrel-windows-x86_64	OK	452s
r-patched-linux-x86_64	OK	328.9s
r-release-linux-x86_64	OK	327.2s
r-release-macos-arm64	OK	84s
r-release-macos-x86_64	OK	507s
r-release-windows-x86_64	OK	307s

Check History

OK 14 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Mar 10, 2026

Reverse Dependencies (1)

imports

diseasystore

Dependency Network

Version History

new 0.6.0 Mar 10, 2026

updated 0.6.0 ← 0.5.2 diff Jan 22, 2026

updated 0.5.2 ← 0.5.1 diff Jan 7, 2026

updated 0.5.1 ← 0.5.0 diff Feb 26, 2025

updated 0.5.0 ← 0.4.1 diff Feb 2, 2025

updated 0.4.1 ← 0.4.0 diff Oct 3, 2024

updated 0.4.0 ← 0.3 diff Mar 20, 2024

updated 0.3 ← 0.2.1 diff Jan 12, 2024

updated 0.2.1 ← 0.2 diff Nov 29, 2023

updated 0.2 ← 0.1 diff Sep 25, 2023

new 0.1 Aug 27, 2023