Ask HN: Data diff tool for tabular data?

Is there a tool you'd recommend to diff tabular data / TSV files?

Every day I have a snapshot of a database stored as TSV. Given two days of snapshots and that every item in the TSV has a unique ID, I'd like to get a list of which lines are new, changed, unchanged, and deleted between the two days. These lists will then be used to update an external service with an awkward database-like API.

I can kind of do this with normal diff but perhaps there's something better suited for the task? It reminds me of data joins in d3 but I'm not working with a UI or Javascript.

---

Comments URL: https://news.ycombinator.com/item?id=17924798

Points: 30

# Comments: 13

from Hacker News: Front Page https://ift.tt/2NTYbTc
via