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: 1.0.11
Depends: R (≥ 3.3)
Imports: backports, cli (≥ 2.2.0), dplyr (≥ 1.1.0), glue, igraph, lifecycle (≥ 1.0.3), memoise, methods, purrr (≥ 1.0.0), rlang (≥ 1.0.2), tibble (≥ 3.0.0), tidyr (≥ 1.0.0), tidyselect (≥ 1.2.0), vctrs (≥ 0.3.2)
Suggests: brio, colourpicker, covr, DBI (≥ 1.2.0), dbplyr (≥ 2.3.4), DiagrammeR, DiagrammeRsvg, digest, duckdb (≥ 0.4.0), fansi, forcats, htmltools, htmlwidgets, jsonlite, keyring, knitr, labelled (≥ 2.12.0), magrittr, nycflights13, odbc (≥ 1.4.2), pillar, pixarfilms, pool, progress, reactable, RMariaDB (≥ 1.3.3), rmarkdown, RPostgres, RSQLite (≥ 2.2.8), rstudioapi, shiny, shinyAce, shinydashboard, testthat (≥ 3.2.0), waldo, withr
Published: 2024-11-25
Author: Tobias Schieferdecker [aut], Kirill Müller ORCID iD [aut, cre], Antoine Fabri [ctb], Darko Bergant [aut], Katharina Brunner [ctb], James Wondrasek [ctb], Indrajeet Patil ORCID iD [ctb], Maëlle Salmon ORCID iD [ctb], energie360° AG [fnd], cynkra GmbH [fnd, cph]
Maintainer: Kirill Müller <kirill at cynkra.com>
BugReports: https://github.com/cynkra/dm/issues
License: MIT + file LICENSE
URL: https://dm.cynkra.com/, https://github.com/cynkra/dm
NeedsCompilation: no
Materials: README NEWS
CRAN checks: dm results [issues need fixing before 2024-11-26]

Documentation:

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

Downloads:

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

Reverse dependencies:

Reverse depends: srppp
Reverse imports: robotoolbox, rolap, when
Reverse suggests: constructive, editbl, fishdata, geogenr, inldata, mlms, profile, starwarsdb

Linking:

Please use the canonical form https://CRAN.R-project.org/package=dm to link to this page.