Show HN: Data Diff – compare tables of any size across databases

Re:Show HN: Data Diff – compare tables of any size across da... by higeorge13 on Wednesday June 22, 2022 @04:22PM (#31841404)

Awesome tool, we will definitely give it a try! 2 questions:

- how do you handle the data replication lag in the comparison?

- i assume that this works in identical tables between 2 databases, right? Any support for “similar” tables based on a column set? Imagine that we have a use case where we have a table X in one db, and another table Y in another db, with some columns from X and enhanced attributes.

[ Parent | on HN ]

Re:Show HN: Data Diff – compare tables of any size across da... by Sirupsen on Wednesday June 22, 2022 @04:26PM (#31841450)

(1) You can specify `--min-age` to exclude records in the replication lag window

(2) We can do that, as long as they have the same name and compatible-ish types. There isn't support for differently named columns yet (but it's on the list)

Cheers. Open an issue if you run into trouble!

[ Parent | on HN ]