Dolt

Dolt

Dolt is a SQL database that you can fork, clone, branch, merge, push and pull just like a Git repository - like Git and MySQL had a baby.

Use it when

  • Database version control needed: When you need full Git-like version control for database schema and data.
  • Data collaboration: When multiple teams need to work on the same dataset with branching and merging capabilities.
  • Audit requirements: When you need complete audit trails of all database changes.
  • Data curation workflows: When doing manual data curation with review and approval processes.
  • Configuration management: When managing configuration data that needs version control.
  • Data sharing: When you need to share datasets with full history and provenance.
  • Application version control: When your application data itself needs to be versioned.

Watch out

  • Performance overhead: Dolt is about 10% slower than MySQL on standard queries.
  • Memory requirements: Requires minimum 2GB RAM for production use cases.
  • Storage overhead: Storing full historical versions can result in significant storage requirements.
  • MySQL compatibility gaps: While aiming for 100% MySQL compatibility, some features are missing.
  • Concurrent write behavior: Under concurrent writes to the same row, Dolt and MySQL produce different results.
  • Disk garbage creation: Creates disk garbage on write, which can become substantial.
  • PostgreSQL limitation: Currently only MySQL-compatible; PostgreSQL version is experimental.

Available in stages

Data Versioning

Example stacks

Example stacks coming soon...