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.2
Depends: R (≥ 3.3)
Imports: backports, cli (≥ 2.2.0), DBI, dplyr (≥ 1.0.9), glue, igraph, lifecycle, magrittr, memoise, methods, pillar (≥ 1.7.0), purrr, rlang (≥ 1.0.2), tibble (≥ 3.0.0), tidyr (≥ 1.0.0), tidyselect (≥ 1.0.1), vctrs (≥ 0.3.2)
Suggests: brio, colourpicker, covr, crayon, dbplyr (≥ 2.2.0), DiagrammeR, DiagrammeRsvg, digest, duckdb (≥ 0.4.0), fansi, forcats, htmltools, htmlwidgets, jsonlite, keyring, knitr, mockr, nycflights13, odbc, pixarfilms, pool, progress, reactable, RMariaDB (≥ 1.2.2), rmarkdown, RPostgres, RSQLite (≥ 2.2.8), rstudioapi, shiny, shinyAce, shinydashboard, testthat (≥ 3.1.2), tidyverse, waldo, withr
Published: 2022-09-20
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://cynkra.github.io/dm/, https://github.com/cynkra/dm
NeedsCompilation: no
Materials: README NEWS
CRAN checks: dm results

Documentation:

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: Manipulating individual tables
Technical: Model verification - keys, constraints and normalization
Technical: Function naming logic
Technical: Zooming and manipulating tables

Downloads:

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

Reverse dependencies:

Reverse suggests: fishdata, profile, starwarsdb

Linking:

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