Introduction

Dolt is git for data, the world’s only SQL database that you can branch and merge, clone and fork, push and pull just like a git repository. It’s like Git and MySQL had a baby.

Being natively version controlled means Dolt can do things no other database can. In this video, we’re going to walk you through one of the most interesting: recovering from operational errors by reverting faulty commits.

Dolt Revert

In this demo, we show how the dolt_revert() procedure can back out a faulty transaction someone made in error. This isn’t like a rollback statement, or like restoring from a backup. It works on a commit you already made to the database, and undoes only that change, leaving the rest of the data alone. A couple weeks ago we proposed that this capability makes recovering from an outage like the one suffered by Atlassian much more tractable. There are no scripts to write: being able to undo your mistakes is a built-in capability of a Dolt database.

Like the video? Have a question? Leave a comment, or join us on our discord to talk to engineers.