dolt
SQL database with Git-like version control
TLDR
SYNOPSIS
dolt command [options]
DESCRIPTION
Dolt is a SQL database with Git-like version control. It combines a fully-functional relational database with branch, merge, diff, and clone operations familiar from Git.
Data is stored in tables queryable via standard SQL (MySQL-compatible). Changes can be staged, committed, and pushed to remotes like DoltHub. Branches allow parallel development with merge capabilities including conflict resolution.
Dolt enables use cases like data versioning, collaborative data editing, reproducible data pipelines, and auditable data changes with complete history.
PARAMETERS
COMMAND
Git-like command: init, clone, add, commit, push, sql, etc.init
Initialize new repository.clone REPO
Clone remote repository.status
Show working tree status.add TABLE
Stage table changes.commit -m MSG
Commit staged changes.sql -q QUERY
Execute SQL query.sql-server
Start MySQL-compatible server.push REMOTE BRANCH
Push to remote.--help
Display help information.
CONFIGURATION
~/.dolt/config_global.json
Global configuration for user name, email, and default remotes..dolt/config.json
Repository-specific configuration for remotes and branch settings.
CAVEATS
Performance differs from traditional databases for some workloads. Some MySQL features not fully supported. Large repositories may have performance implications. Merge conflicts require resolution.
HISTORY
Dolt was created by DoltHub (formerly Liquidata) and released in 2019. It was designed to bring Git's version control model to databases, addressing the lack of data versioning in traditional database systems.
