> I want to check out the state of the world at a specific commit, write a change, a week later write another change, revert the first change 3 weeks later. Th

> I want to check out the state of the world at a specific commit, write a change, a week later write another change, revert the first change 3 weeks later. This is sort of like temporal tables but with the ability to branch from a previous point of history. I'm not sure it would play well with foreign keys. You could branch the entire database with either point-in-time recovery or with the file-system using ZFS. Postgres.ai turned this into a product.