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…
Script to compare Postgres data between two points in time launched on August 13, 2021 with 55 votes, #1,080 of 2,953 launches that month and more than 90% of that year's launches.
In plain words
A bash script that captures and compares PostgreSQL database changes between two points in time. Users run the script before and after interacting with an application to see what data changed, similar to how git diff works for code. It's designed to help developers understand new codebases by visualizing data modifications. The tool requires a key identifier for matching comparison snapshots.
written from the facts on this page · September 2026
From the sources
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…
Does a similar job
all alternatives →
Pgsh – branch Postgres like Git2019 · github.com · ▲66Branch your PostgreSQL Database like Git. Contribute to sastraxi/pgsh development by creating an account on GitHub.
- DDData Diff – compare tables of any size across databases2022 · ▲127
Gleb, Alex, Erez and Simon here – we are building an open-source tool for comparing data within and across databases at any scale. The repo is at https://github.com/datafold/data-diff, and our home page is https://datafold.com/. As a company, Datafold builds tools for data engineers to automate the most tedious and error-prone tasks falling through the cracks of the modern data stack, such as data testing and lineage. We launched two years ago with a tool for regression-testing changes to ETL code…
- PSPeerdb Streams – Simple, native Postgres change data capture2024 · ▲177
Hello HN, I am Sai Srirampur, one of the Co-founders of PeerDB. (https://github.com/PeerDB-io/peerdb). We spent the past 7 months building a solid experience to replicate data from Postgres to data warehouses. Now we're expanding to queues. PeerDB Streams provides a simple and native way to replicate changes as they happen in Postgres to Queues (Kafka, Redpanda, Google PubSub, etc). We use Postgres logical decoding to enable Change Data Capture (CDC). Blog post here: https://blog.peerdb.io/peerdb-streams-simple-native-postgres.... 10-min quickstart here:…
A syntax highlighter for Git and diff output, written in Rust2020 · github.com · ▲261A syntax-highlighting pager for git, diff, grep, rg --json, and blame output - dandavison/delta
- MDMultiplayer Demo Built with Elixir2022 · multiplayer.dev · ▲221
Hey HN, I’m an engineer at Supabase [0] and one of the creators of this demo. My team and I have been working hard to bring developers the next version of Supabase Realtime. The current version of Realtime [1] is a Change Data Capture (CDC) server for a PostgreSQL database that broadcasts changes via WebSockets to authorized subscribers. It’s written in Elixir/Phoenix. The server utilizes PostgreSQL’s logical replication functionality, which writes database changes to Write-Ahead Logging (WAL) segment files, and a replication slot, responsible for managing and retaining WAL files.…
- PAPgit – A Git-like CLI backed by PostgreSQLMar 2026 · oseifert.ch · ▲126
More dev tools this month
the category →
open-source IDE for thoughtful software design. Contribute to devdotfast/whiteboard development by creating an account on GitHub.
Dev tools · 27d ago · github.com
Contribute to reladraw/reladraw development by creating an account on GitHub.
Dev tools · 25d ago · github.com
OpenBot▲362Grok Bot alternative: free, local, open-source, multiplayer
Dev tools · 22d ago · openbot.run
Talanoa▲340Hi HN, I’m a fullstack developer, and honestly, I’ve lost count of how many side projects I’ve worked on over the years. But one idea kept coming back to me: a different kind of email client. It first came to me in 2014: “What if we could handle emails more like conversations?” Every year, I’d revisit this concept in my “Build Notes.” Ten years later, no one had built exactly what I had in mind — so I finally decided to do it myself. That’s how Talanoa was born. I wanted something focused on people, not timelines. I was tired of marking messages as unread just to remember to reply later, or…
Dev tools · 20d ago · talanoa.email
CoreSpeed▲332One MCP for everything your agents need: apps, memory, tools
Dev tools · 27d ago · corespeed.io
Source: Show HN post ↗ · launch text quoted in part
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
