News for hackers. Stuff that matters.

A comment on Show HN: Safe Data Changes in PostgreSQL. Parent comment

Re:Show HN: Safe Data Changes in PostgreSQL by ciminelli on Thursday March 09, 2023 @02:43PM (#35085650)
We were looking at tooling for snapshotting production data for testing purposes, that use case is interesting to have the diff view based on changes happening from application actions. Would you use it for testing changes or more for debugging production issues?
[ Parent | on HN ]
Re:Show HN: Safe Data Changes in PostgreSQL by pawelduda on Thursday March 09, 2023 @03:36PM (#35086318)
Well, my main use case would be to speed up project onboarding where I can play around with the app from user perspective and checking how my actions impact database... Could help cutting through a lot of frontend/backend layers...

If you have multiple DB snapshots and WAL enabled, theoretically you could inspect the log to see what happened inbetween. There's pg_xlogdump for that but I think it will output very raw data...

[ Parent | on HN ]
Re:Show HN: Safe Data Changes in PostgreSQL by ciminelli on Friday March 10, 2023 @12:47PM (#35098073)
How would you want to actually look at the database diff? Just a summary view of rows that were changed given a certain time period?
[ Parent | on HN ]