Skip to content

SCDB

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

v0.6.2 · Jun 22, 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

640

Last 30 days

5457th

1.3K

Last 90 days

4.1K

Last year

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

CRAN Check Status

13 OK
Show all 13 flavors
Flavor Status
r-devel-linux-x86_64-debian-clang OK
r-devel-linux-x86_64-debian-gcc OK
r-devel-linux-x86_64-fedora-clang OK
r-devel-linux-x86_64-fedora-gcc OK
r-devel-windows-x86_64 OK
r-oldrel-macos-arm64 OK
r-oldrel-macos-x86_64 OK
r-oldrel-windows-x86_64 OK
r-patched-linux-x86_64 OK
r-release-linux-x86_64 OK
r-release-macos-arm64 OK
r-release-macos-x86_64 OK
r-release-windows-x86_64 OK

Check History

OK 13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Jun 9, 2026
ERROR 12 OK · 0 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE Jun 8, 2026
ERROR r-devel-linux-x86_64-debian-gcc

package dependencies

Package required but not available: ‘dbplyr’

Package suggested but not available for checking: ‘tidyverse’

See section ‘The DESCRIPTION file’ in the ‘Writing R Extensions’
manual.
OK 14 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Mar 10, 2026

Reverse Dependencies (1)

imports

Dependency Network

Dependencies Reverse dependencies checkmate DBI dbplyr dplyr glue lubridate openssl parallelly purrr rlang R6 stringr tidyr tidyselect magrittr diseasystore SCDB

Version History

13 tracked
updated 0.6.2 ← 0.6.1 diff Jun 22, 2026
updated 0.6.1 ← 0.6.0 diff May 18, 2026
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