Ask HN: Data diff tool for tabular data?


New top story on Hacker News: 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.