Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Schema and data comparison tools #62

Open
davenquinn opened this issue Jul 17, 2024 · 0 comments
Open

Schema and data comparison tools #62

davenquinn opened this issue Jul 17, 2024 · 0 comments
Assignees

Comments

@davenquinn
Copy link
Member

davenquinn commented Jul 17, 2024

As shown in #60, it'd be useful to have a few tools at our fingertips that allow us to compare both schema and data within tables, with the goal of quickly assessing whether/what changes exist between database versions (especially versions of the Macrostrat database in different environments).

We've already got some integration with schema-diffing capabilities (e.g., migra) but it would be nice to integrate a data-comparison tool such as PGDataDiff. This would potentially help us quickly evaluate whether foreign keys, etc. are retained between environments.

Perhaps this could be somehow integrated into #61? We might be able to make this happen in a more general way as well.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants