dm: Relational Data Models

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.

Version: 0.2.7
Depends: R (≥ 3.3)
Imports: backports, cli (≥ 2.2.0), DBI, dplyr (≥ 1.0.3), ellipsis, glue, igraph, lifecycle, magrittr, memoise, methods, pillar (≥ 1.6.2), purrr, rlang (≥ 0.4.10), tibble, tidyr (≥ 1.0.0), tidyselect (≥ 1.0.1), vctrs (≥ 0.3.2)
Suggests: brio, covr, crayon, dbplyr, DiagrammeR, DiagrammeRsvg, digest, duckdb, fansi, keyring, knitr, mockr, nycflights13, odbc, pixarfilms, pool, progress, RMariaDB (≥ 1.0.10), rmarkdown, RPostgres, RSQLite (≥ 2.2.8), testthat (≥ 3.0.2), tidyverse, waldo, withr
Published: 2022-02-03
Author: Tobias Schieferdecker [aut], Kirill Müller ORCID iD [aut, cre], Antoine Fabri [ctb], Darko Bergant [aut], Katharina Brunner [ctb], James Wondrasek [ctb], energie360° AG [fnd], cynkra GmbH [fnd, cph]
Maintainer: Kirill Müller <krlmlr+r at>
License: MIT + file LICENSE
NeedsCompilation: no
Materials: README NEWS
CRAN checks: dm results


Reference manual: dm.pdf
Vignettes: First read: Getting started with dm
How to: Copy data to and from a database
How to: Create a dm object from a database
How to: Create a dm object from data frames
How to: Insert, update or remove rows in a database
How to: Understand relational data models
Technical: Migration guide: 'cdm' -> 'dm'
Technical: Class dm and basic operations
Techincal: Visualizing dm objects
Technical: Filtering in relational data models
Technical: Joining in relational data models
Technical: Model verification - keys, constraints and normalization
Technical: Function naming logic
Technical: Zooming and manipulating tables


Package source: dm_0.2.7.tar.gz
Windows binaries: r-devel:, r-release:, r-oldrel:
macOS binaries: r-release (arm64): dm_0.2.7.tgz, r-release (x86_64): dm_0.2.7.tgz, r-oldrel: dm_0.2.7.tgz
Old sources: dm archive

Reverse dependencies:

Reverse suggests: fishdata, profile, starwarsdb


Please use the canonical form to link to this page.