Script to compare Postgres data between two points in time
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…
What it does
In the maker’s words, at launch
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.
Does the same job
all alternatives →- PA
- AUA user interface for Postgres EXPLAIN that also gives tips2019 · pgmustard.com · ▲50
- PAPgcli – A CLI for Postgres with auto-completion and syntax highlighting2015 · pgcli.com · ▲227
- PBPgsh – branch Postgres like Git2019 · github.com · ▲66
More dev tools this month
the category →
Open-source GTM skills for technical founders
Dev tools · 29d ago · gtmcofounder.com
OpenTrailPaper is open-source bike computer firmware for the LilyGO T5S3 4.7" E-Paper PRO. It supports offline maps, GPX routes, FIT recording and Bluetooth sensors.
Dev tools · 1d ago · opentrailpaper.com
Launched alongside, August 2021
the whole month →- II
Hey all My name is Sindre, and I am the CTO of Scrimba (YC S20). For the last 7 years, I have written all my web apps in a full-stack programming language called Imba. It compiles to JavaScript and its main goal is to make web developers more productive. I just launched a major overhaul of Imba, so I wanted to share it here on HN, in case anyone are interested in learning more about it. It is very opinionated, so some of you might not like it, but I would love to hear anyones feedback regardless. Constructive criticism appreciated! The backstory: Imba initially started in 2012 as an effort…
Life & fun · 2021
- WB
Hello HN, Over the last year we've been building ente[1], a privacy-friendly, easy-to-use alternative to Google Photos. We've so far built Android[2][3], iOS[4], web[5] apps that encrypt your files and back them up in the background. You can access these across your devices, and share them with other ente users, end-to-end encrypted. You can also use our electron app[6] to maintain a local copy of your backed up files. We've built a fault-tolerant data replication layer that replicates your data to two different storage providers in the EU. We will be providing additional replicas as an…
Life & fun · 2021
