Skip to content

dm 0.1.2
Compare
Choose a tag to compare
@krlmlr krlmlr released this 04 May 15:22
v0.1.2
1d0ffe0

Features

  • dm_from_src() now works for databases other than Postgres and MSSQL (#288), gives a warning if tables cannot be accessed with table_name = NULL (#348), and gains learn_keys argument to control querying of primary and foreign keys from the database (#340).
  • dm_examine_constraints() now prints a different message if a dm has no constraints defined.
  • Disambiguation message now only lists column names for easier copy-pasting.
  • New methods for "zoomed_dm": head(), tail(), pull(), group_data(), group_indices(), group_vars(), group_keys() and groups() (#236, #203).
  • dm_paste() supports writing colors and the table definition via the new options argument. The definition can be written to a file via the new path argument. The select argument is soft-deprecated (#218, #302).
  • dm_add_tbl() uses rlang::list2() internally, now accepts := to specify table names.
  • New dm_ptype() (#301).
  • New dm_financial() and dm_financial_sqlite().
  • Printing dm objects from database sources with many tables is now faster (#308, @gadenbuie).
  • check_key() now also works on a zoomed dm.
  • Key columns are always selected in a join operation, with a message (#153).
  • Support alpha colors for the table colors (#279).

Bug fixes

  • Fix visualization of column that acts as a foreign key more than once (#37).
  • dm_add_pk(), dm_rm_pk(), dm_add_fk() and dm_rm_fk() are now stricter when keys exists or when attempting to remove keys that don't exist. A more relaxed mode of operation may be added later (#214).
  • examine_cardinality(), dm_examine_constraints() and enum_pk_candidates() now work for columns named n.
  • dm_set_key_constraints() (and by extension dm_copy_to(set_key_constraints = TRUE)) now quote identifiers for the SQL that creates foreign keys on the database.
  • collect() gives a better error message when called on a "zoomed_dm" (#294).
  • check_subset() gives a clean error message if the tables are complex expressions.
  • dm_from_src(schema = "...") works on Postgres if search_path is not set on the connection.
  • compute.zoomed_dm() no longer throws an error.
  • Remove unused DT import (#295).

Compatibility

  • Remove use of deprecated src_df() (#336).
  • Fix compatibility with dplyr 1.0.0 (#203).

Documentation

  • dm_draw() output is shown in examples (#251).
  • New article "{dm} and databases" (#309, @jawond).

Internal

  • Testing on local data frames (by default), optionally also SQLite, Postgres, RMariaDB, and SQL Server. Currently requires development versions and various pull requests (#334, #327, #312, #76).
  • dm_nycflights13(subset = TRUE) memoizes subset and also reduces the size of the weather table.
  • Expand definitions of deprecated functions (#204).
Assets 2
Loading