[maltelau]

Using the hammer already in my hand, I would write a small R script to do the joins.

Example script:

  library(tidyverse)
  old = read_tsv("path/to/old/db.tsv")
  new = read_tsv("path/to/new/db.tsv")
  deleted   = anti_join(old, new)
  new       = anti_join(new, old, by = "id")
  unchanged = semi_join(old, new)
  changed   = semi_join(new, old, by = "id") %>%
                anti_join(unchanged)