Dolt is Git for Data

Re:Dolt is Git for Data by qaq on Thursday June 23, 2022 @12:23PM (#31851356)

You do realize that how MVCC works right? Turn off GC process that collects old versions on production DB and see what happens. Reverting changes out of order is not possible in many cases.

[ Parent | on HN ]

Re:Dolt is Git for Data by zachmu on Thursday June 23, 2022 @12:29PM (#31851459)

Right, but it is with Dolt. That's the point.

CALL DOLT_REVERT('bad-commit-hash')

Works just like git revert: creates an inverse of the changes in the commit given and applies it as a patch.

[ Parent | on HN ]

Re:Dolt is Git for Data by qaq on Friday June 24, 2022 @03:16AM (#31858636)

so I have commit1 drop table blah commit2 create table blah with diff schema

I revert commit1 what would be the state?

[ Parent | on HN ]

Re:Dolt is Git for Data by aboodman on Friday June 24, 2022 @10:36PM (#31871966)

It will be a conflict. But you can commit the revert to a different branch and run both schemas at the same time. This provides a lot of flexibility! Check out https://www.dolthub.com/blog/2022-04-29-dolt-revert/ for some discussion of this.

[ Parent | on HN ]