Show HN: Script to compare Postgres data between two points in time

55 points by denvaar ↗ HN
https://github.com/denvaar/pgdiff

I cobbled together various programs into a bash script to compare how data changes between two points in time. My idea was basically to have a `git diff` but for data inside postgres.

I wanted a util like this to help get to know a new code base: Interact with an app and watch how the data changes.

You run the script with a given key (anything) before interacting with an app, then run it again with the same key to see the data diff.

I'm not much of a bash scripter, as you can probably see from the script, but it was a fun and useful tool to make. Might make some more improvements in the future (eg. BYO diff command, etc.) but we'll see.

1 comment

[ 4.5 ms ] story [ 15.3 ms ] thread
When you post for “Show HN”, it would be wise to use the link option to direct the users to your repo [1] - otherwise readers can’t click through. It is a HN wierdness - you either get to write text or post a link, but not both

1. https://github.com/denvaar/pgdiff