Relational Data Models
Overview
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.
Bug fixes
- Fix for upcoming dbplyr 2.6.0 release (@hadley, #2454).
From NEWS.md in the release
Install
Health
- OK13 OK2026-08-05
- NOTE12 OK, 1 NOTE2026-08-01
- OK14 OK2026-03-10
Documentation
- 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())
- First read: Getting started with dm HTML
- How to: Copy data to and from a database HTML
- How to: Create a dm object from a database
- How to: Create a dm object from data frames HTML
- How to: Insert, update or remove rows in a database HTML
- How to: Understand relational data models HTML
- Techincal: Visualizing dm objects HTML
- Technical: Class dm and basic operations HTML
- Technical: Filtering in relational data models HTML
- Technical: Function naming logic HTML
Downloads
Repository
- 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
Forks over time
Releases over time
Issues over time
PRs over time
Commits over time
Commit identities over time
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.
The R CMD check workflow runs on Linux and Windows
GitHub Pages site last deployed 2026-09-27 · The repository has a site deploy workflow
pkgdown site last built 2026-05-17
Show all practicesHide 4 practices
This repository shows signs of AI coding tools.
- Claude Codefirst seen 2025-07-01Seen in the repository: .claudeNamed in .Rbuildignore: .claude, CLAUDE.mdPull request it wrote: opened by a project memberCommits: 4 by its own account · at least 61 crediting it in the message
- GitHub Copilotfirst seen 2025-07-31Seen in the repository: .github/copilot-instructions.mdPull request: opened by its own accountCommits: 19 by its own account · at least 21 crediting it in the message
- Claude Opus 513 commits · Aug to Sep 2026
- Claude Opus 5.53 commits · Sep 2026
- Claude Fable 52 commits · Jul to Aug 2026
Dependencies
Installing dm adds 24 packages (15 with compiled code, 18 MB of source tarballs). Heaviest: stringi 11 MB, vctrs 1.0 MB, dplyr 902 KB.
Code & Tests
Datasets
People & History
Pick two releases to compare their code metrics.
- 1.1.2Latest
- RR 4.6.0 released · 2026-04-24
- 1.1.12026-03-05 · diff ↗
- 1.1.0
- 1.0.122025-07-02 · diff ↗
- RR 4.5.0 released · 2025-04-11
- 1.0.112024-11-25 · diff ↗
- RR 4.4.0 released · 2024-04-24
- 1.0.102024-01-21 · diff ↗
- 1.0.92024-01-08 · diff ↗
- 1.0.82023-11-02 · diff ↗
- 1.0.72023-10-24 · diff ↗ ·
added 6 exports
dm_ddl_post, dm_ddl_pre, dm_dml_load, dm_sql, json_unnest, json_unpack - 1.0.62023-07-21 · diff ↗ ·
added 3 exports
dm_get_table_description, dm_reset_table_description, dm_set_table_description - RR 4.3.0 released · 2023-04-21
- 1.0.52023-03-16 · diff ↗
- 1.0.4
Show 33 earlier eventsHide 33 earlier events
- 1.0.32022-10-12 · diff ↗
- 1.0.22022-09-20 · diff ↗
- 1.0.1
- 1.0.0
- 0.3.02022-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_updateadded 8 exports
dm_from_con, dm_rows_append, dm_validate, json_nest, json_nest_join, json_pack, json_pack_join, rows_append - RR 4.2.0 released · 2022-04-22
- 0.2.82022-04-08 · diff ↗
- 0.2.72022-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.62021-11-21 · diff ↗
- 0.2.52021-10-15 · diff ↗ ·
added 4 exports
db_schema_create, db_schema_drop, db_schema_exists, db_schema_list - 0.2.42021-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
- 0.2.22021-06-14 · diff ↗
- RR 4.1.0 released · 2021-05-18
- 0.2.12021-05-11 · diff ↗
- 0.2.02021-05-03 · diff ↗
- 0.1.132021-04-26 · diff ↗ ·
added 4 exports
sql_schema_create, sql_schema_drop, sql_schema_exists, sql_schema_list - 0.1.122021-02-15 · diff ↗
- 0.1.102021-01-07 · diff ↗
- 0.1.9
- 0.1.72020-09-02 · diff ↗
- 0.1.6
- unarchivedReturned to CRAN2020-07-03
- 0.1.5
- archivedRemoved from CRAN2020-06-30check issues were not corrected in time Does not use Suggests packages conditionally
- 0.1.42020-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.32020-05-25 · diff ↗
- unarchivedReturned to CRAN2020-05-04
- archivedRemoved from CRAN2020-05-04check problems were not corrected in time
- 0.1.2
- RR 4.0.0 released · 2020-04-24
- 0.1.12020-03-12
- RR 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")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.
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.