Skip to content

Relational Data Models

4packages dependsuggested by 5
47Kdownloads / year
75.7%test coverage
13/13flavors OK

Overview

About
Maintained by Kirill MüllerCRAN page ↗GitHub ↗Website ↗Issues ↗Declared funders: cynkra GmbH and energie360° AG

Provides tools for working with multiple related tables, stored as data frames or in a relational database. Multiple tables (data and metadata) are stored in a compound object, which can then be manipulated with a pipe-friendly syntax.

Changes in 1.1.2

Bug fixes

  • Fix for upcoming dbplyr 2.6.0 release (@hadley, #2454).

From NEWS.md in the release

Install

Health

CRAN checks
13OK
Slowest check: 9.0 min · r-oldrel-windows-x86_64
Status changes
  • OK13 OK2026-08-05
  • NOTE12 OK, 1 NOTE2026-08-01
  • OK14 OK2026-03-10
Advisories

none known

Documentation

In release 1.1.2
READMEYes · 493 wordsVignettesYes · 15 · dynamicNEWSYes · 100% structured · mentions 1.1.2Citation fileNoWebsiteYes · pkgdown
Help pages
79 (7 internal)includes a package overview page
Examples that run
99%66 run in a plain check (44 of them under a condition) · 1 never run
Exported functions with examples
85%
Documented parameters
90%
Return-value docs
76%
Help pages citing references
0%

Also includes 9 demo scripts (run with demo())

Downloads

47K
CRAN downloads in the past year
Rank #2,232 · ~129/day · ~3.9K/mo
Daily download trend is not available in this view yet.
2.3K30 days
7.6K90 days
47K1 year
Compare downloads with other packages →
Also on572 r2u4 autocran42 c2d4u

Repository

cynkra/dm ↗Organization: cynkra
529Stars
55Forks
196Open issues
15Open PRs
35Releases
8,528Commits
48Commit identities
rrelational-databasesdata-modeldbplyrdbidatawarehousingdata-warehousing
8,528 commits · Last activity 2026-10-10 · +0.4% stars, 30d · Default branch at 1.1.2.9020, ahead of CRAN 1.1.2 (checked 2026-10-18) · Discussions: 9 posts
Responsiveness
How these are sampled
PRs merged (all time)
53%
Median days to close, 50 most recently updated closed issues
265
Median days to close, 50 most recently updated closed PRs
0

Stars over time

2025-10-06 · 5222026-10-13 · 529
PracticesBeta

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

Checks run against github.com/cynkra/dm on 2026-10-18.

Continuous integration (2)
GitHub ActionsR CMD check workflow

The R CMD check workflow runs on Linux and Windows

Governance and community (2)
Code of conductContributing guide
Docs source (4)
README.Rmdpkgdown

GitHub Pages site last deployed 2026-09-27 · The repository has a site deploy workflow

pkgdown site last built 2026-05-17

Coverage (1)
Coverage reporting (Codecov)
Show all practicesHide 4 practices
Reproducibility and dev environment (5)
data-raw/MakefileDockerfileDev ContainerGitpod
CRAN release process (2)
cran-comments.mdrevdep/
Automation and maintenance (1)
Renovate
Lint, format, editor (2)
AirRStudio project
How this is detected·Detection ruleset v3 (2026-09-26)
AI coding toolsBeta

This repository shows signs of AI coding tools.

  • Claude Codefirst seen 2025-07-01
    Seen in the repository: .claude
    Named in .Rbuildignore: .claude, CLAUDE.md
    Pull request it wrote: opened by a project member
    Commits: 4 by its own account · at least 61 crediting it in the message
  • GitHub Copilotfirst seen 2025-07-31
    Seen in the repository: .github/copilot-instructions.md
    Pull request: opened by its own account
    Commits: 19 by its own account · at least 21 crediting it in the message
Shared conventions any agent may read, so they name no particular tool.
Seen in the repository: AGENTS.md
Models named in its commits
  • Claude Opus 513 commits · Aug to Sep 2026
  • Claude Opus 5.53 commits · Sep 2026
  • Claude Fable 52 commits · Jul to Aug 2026
Counts are commits, not lines of code. Commits by a tool's accounts count once across all of its accounts. Commits crediting it are the largest count among its credit lines, a minimum.How this is detected·Detection ruleset v4 (updated 2026-09-27)

Dependencies

Reverse dependencies
4direct
1indirect
Depends 1 · Imports 3
Suggested by 5
Depends, Imports or LinkingTo, most downloaded first
Suggests, most downloaded first

Datasets

People & History

People (10)
Author, Maintainer since 0.1.1 (2020)
Contributor · added in 0.2.6
Contributor · added in 0.3.0
Contributor · added in 0.3.0
Contributor · added in 0.1.4
Funder, Copyright holder
Releases (37)

Pick two releases to compare their code metrics.

  • 1.1.2Latest
    record
    2026-05-17 · current release · diff ↗
  • R
    R 4.6.0 released · 2026-04-24
  • 1.1.1
    record
    2026-03-05 · diff ↗
  • 1.1.0
    record
    2026-02-25 · diff ↗ ·
    added 1 export
    dm_flatten
  • 1.0.12
    record
    2025-07-02 · diff ↗
  • R
    R 4.5.0 released · 2025-04-11
  • 1.0.11
    record
    2024-11-25 · diff ↗
  • R
    R 4.4.0 released · 2024-04-24
  • 1.0.10
    record
    2024-01-21 · diff ↗
  • 1.0.9
    record
    2024-01-08 · diff ↗
  • 1.0.8
    record
    2023-11-02 · diff ↗
  • 1.0.7
    record
    2023-10-24 · diff ↗ ·
    added 6 exports
    dm_ddl_post, dm_ddl_pre, dm_dml_load, dm_sql, json_unnest, json_unpack
  • 1.0.6
    record
    2023-07-21 · diff ↗ ·
    added 3 exports
    dm_get_table_description, dm_reset_table_description, dm_set_table_description
  • R
    R 4.3.0 released · 2023-04-21
  • 1.0.5
    record
    2023-03-16 · diff ↗
  • 1.0.4
    record
    2023-02-11 · diff ↗ ·
    added 3 exports
    dm_add_uk, dm_get_all_uks, dm_rm_uk
Show 33 earlier eventsHide 33 earlier events
  • 1.0.3
    record
    2022-10-12 · diff ↗
  • 1.0.2
    record
    2022-09-20 · diff ↗
  • 1.0.1
    record
    2022-08-06 · diff ↗ ·
    added 1 export
    dm_deconstruct
  • 1.0.0
    record
    2022-07-21 · diff ↗ ·
    added 2 exports
    dm_gui, tibble
  • 0.3.0
    record
    2022-07-06 · diff ↗ ·
    removed 8 exports
    get_returned_rows, has_returned_rows, sql_output_cols, sql_returning_cols, sql_rows_delete, sql_rows_insert, sql_rows_patch, sql_rows_update
    added 8 exports
    dm_from_con, dm_rows_append, dm_validate, json_nest, json_nest_join, json_pack, json_pack_join, rows_append
  • R
    R 4.2.0 released · 2022-04-22
  • 0.2.8
    record
    2022-04-08 · diff ↗
  • 0.2.7
    record
    2022-02-03 · diff ↗ ·
    added 9 exports
    dm_examine_cardinalities, dm_nest_tbl, dm_pack_tbl, dm_pixarfilms, dm_unnest_tbl, dm_unpack_tbl, dm_unwrap_tbl, dm_wrap_tbl, pack_join
  • 0.2.6
    record
    2021-11-21 · diff ↗
  • 0.2.5
    record
    2021-10-15 · diff ↗ ·
    added 4 exports
    db_schema_create, db_schema_drop, db_schema_exists, db_schema_list
  • 0.2.4
    record
    2021-09-30 · diff ↗ ·
    added 6 exports
    get_returned_rows, glimpse, has_returned_rows, sql_output_cols, sql_returning_cols, sql_rows_patch
  • 0.2.3
    record
    2021-06-20 · diff ↗ ·
    added 1 export
    sql_rows_delete
  • 0.2.2
    record
    2021-06-14 · diff ↗
  • R
    R 4.1.0 released · 2021-05-18
  • 0.2.1
    record
    2021-05-11 · diff ↗
  • 0.2.0
    record
    2021-05-03 · diff ↗
  • 0.1.13
    record
    2021-04-26 · diff ↗ ·
    added 4 exports
    sql_schema_create, sql_schema_drop, sql_schema_exists, sql_schema_list
  • 0.1.12
    record
    2021-02-15 · diff ↗
  • 0.1.10
    record
    2021-01-07 · diff ↗
  • 0.1.9
    record
    2020-11-18 · diff ↗ ·
    added 1 export
    dm_mutate_tbl
  • 0.1.7
    record
    2020-09-02 · diff ↗
  • 0.1.6
    record
    2020-07-30 · diff ↗ ·
    added 1 export
    dm_bind
  • unarchivedReturned to CRAN
    2020-07-03
  • 0.1.5
    record
    2020-07-03 · diff ↗ ·
    added 1 export
    sql_rows_truncate
  • archivedRemoved from CRAN
    2020-06-30
    check issues were not corrected in time Does not use Suggests packages conditionally
  • 0.1.4
    record
    2020-06-07 · diff ↗ ·
    added 14 exports
    dm_rows_delete, dm_rows_insert, dm_rows_patch, dm_rows_truncate, dm_rows_update, dm_rows_upsert, rows_delete, rows_insert, rows_patch, rows_truncate, rows_update, rows_upsert, sql_rows_insert, sql_rows_update
  • 0.1.3
    record
    2020-05-25 · diff ↗
  • unarchivedReturned to CRAN
    2020-05-04
  • archivedRemoved from CRAN
    2020-05-04
    check problems were not corrected in time
  • 0.1.2
    record
    2020-05-04 · diff ↗ ·
    added 3 exports
    dm_financial, dm_financial_sqlite, dm_ptype
  • R
    R 4.0.0 released · 2020-04-24
  • 0.1.1
    record
    2020-03-12
  • R
    R 3.6.0 released · 2019-04-26

Package metadata

First published
2020-03-12
Total releases
37 / 6 yrs
License
MIT + file LICENSE OSI
Minimum R
≥ 4.0
Download size
2.7 MB

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("dm")
Müller, K., cynkra GmbH, energie360° AG, Bergant, D., Brunner, K., Fabri, A., Patil, I., Salmon, M., Schieferdecker, T., & Wondrasek, J. (2026). dm: Relational Data Models (Version 1.1.2) [Computer software]. https://doi.org/10.32614/CRAN.package.dm

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.

APA

Balamuta, J. J. (2026). R Observatory: Metrics for dm version 1.1.2 [Data set]. HJJB, LLC. Data release v2026-10-21. https://doi.org/10.5281/zenodo.21843040

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

Privacy choices

These apply to this browser and are stored on this device only. Nothing about your choice is sent to us.

Read the privacy policy