Muhammad Aqeel: Undo for Postgres, without losing the rest of your day

Posted by hnisjafx40 3 days ago

Counter24Comment9OpenOriginal

Comments

Comment by agentdev001 1 day ago

I thought that the name of this undo implementation was Muhammad Aqeel. Its PgVolvra, which is arguably a worse name- phonetically.

Comment by redrove 1 day ago

Can’t unsee PgVulva

Comment by thunderbong 23 hours ago

PgMulva

Comment by SweetSoftPillow 1 day ago

Let's call it Muhammad Aqeel then.

Comment by a34729t 23 hours ago

Honestly a better name

Comment by gavinray 23 hours ago

  > pgVolvra records every row change on the tables you choose. For each change, it keeps the row as it was, and the row as it became, along with who made the change, when, and in which transaction. When something goes wrong, it uses that record to put the affected rows back, and it touches nothing else.
You've essentially replicated the WAL s functionality

I'd imagine you could actually build this reusing a lot of the existing WAL code if you were Inclined

Comment by forinti 23 hours ago

You might not even have the WAL from long ago.

I see this as an easier way to create a log table.

Comment by anonymous908213 1 day ago

Friendly reminder that database software is the literal last thing you want to entrust to vibe coders.

Comment by forinti 1 day ago

This is really cool.

My org uses log tables and triggers and I wish that databases would offer something like this in a declarative manner.