Git for Data, Version controls for our databases

shrey vijayvargiya - Oct 12 '22 - - Dev Community

Git for Data, Version controls for our databases, this is amazing.

shorts for introduction to Dolt

Dolt - Dolthub

  • Git for data the first version control SQL databases
  • Having all git features like clone, merge, pull and push the database-related changes either using GUI or command line.
  • Host the databases on Hosted dolt the cloud-based deployment server for database
  • Provide a hub called Dolt hub to share a database with web-based GUI to work together with teams
  • Provide a lab called Dolt lab to work with your SQL databases locally just like normal development and push, commit and merge the changes as we do in Git.

The most important thing is we don't need to care much about putting changes in the production database as we can revert those changes and all this is possible because of the Git-based Database or version control database.

The most important thing why and how dolt is able to execute all these features is because it's committed and tracks the changes in the SQL table of each cell and row.

Dolt produces cell-wise diffs and merges, making data debugging between versions tractable. Dolt is the only SQL database that has branches and merges.

Will cover a detailed story on it.
Stay tuned.

Keep developing
Shrey

iHateReading

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .