- REFERENCE9 min read
So you want Database Versioning?
Here at DoltHub, we've had a lot of success with our "So you want..." series of blog posts helping people find Dolt when they are looking for it. Dolt is a lot of things. Dolt is a version controlled database, a Git database, Git for data, data…
Read More
- DOLTLABFEATURE RELEASE4 min read
Announcing DoltLab Enterprise Offline mode
Today we're excited to announce the release of DoltLab v2.3.5 which includes support for running DoltLab Enterprise in "offline" mode. Prior versions of DoltLab Enterprise, which support "online" mode only, required customers to allow egress acc...
Read More - WORKBENCHFEATURE RELEASE2 min read
Fetching and Syncing Remotes Using the Dolt Workbench
We're excited to roll out fetching and syncing with remote databases from the Dolt Workbench . For more detailed information about fetching, check out our documentation . Follow this step-by-step guide to see how you can use the Dolt Workbench ...
Read More - USE CASE16 min read
Using Rebase to Tidy up Dolt Commit History
Dolt is a relational database that provides Git-style version control for your data and schema. In addition to all the power of SQL, you can create branches to work on data changes in isolation, merge changes, quickly diff any two points in histo...
Read More - GOLANG4 min read
DebugString(): a handy pseudo-standard for Go libraries
We're using Go to write Dolt , the world's first and only version-controlled SQL database. As a database program, Dolt has to deal with lots of large data objects. Oftentimes, these large objects are deeply n...
Read More - REFERENCE4 min read
Dolt MySQL Differences
Here at DoltHub , we tell users " Dolt is a drop in replacement for MySQL". We're also quick to remind users that "There is no MySQL code in Dolt". Dolt is built from the storage engine up to be MySQL-compatible but also offer Git-style version...
Read More - 2 min read
Dolt Wrapped 2024: A Year in Review
Spotify Wrapped popularized a version of the "year in review" format. Now everything is "wrapped". Why can't Dolt be wrapped too? Turns out, Dolt can be wrapped! We're ripping off Spotify's gimmick (but not personalizing it) for Dolt's Year in...
Read More - REFERENCE2 min read
Dolphie Works with Dolt
Dolt is a drop in-replacement for MySQL, which means it can be used with any MySQL-compatible tool. One such tool is Dolphie , a real-time analytics tool for MySQL. Dolphie is an open source tool with a UI that works entirely in the terminal, and...
Read More - SQL3 min read
10% Slower Than MySQL
Four years ago DoltDB was about 15x slower than MySQL. At the time, we faced skepticism regarding Prolly-tree performance and scalability. Last year, the first production-grade DoltDB aspired to ~2x read latency compared to MySQL. This meant that a...
Read More - GOLANG5 min read
The new maps and slices packages in Go 1.23: tour and examples
We're using Go to write Dolt , the world's first and only version-controlled SQL database. Like any Go program that deals with data, we often find ourselves in need of high-level functions that transform data...
Read More - REFERENCE6 min read
We Have Google Drive at Home: Musings on Merkle-Tree Based File Sharing
Suppose you have a directory of files that you want to sync with your friends. When the files change, you want your friends to be able to download just the changes without needing to re-download the entire directory again. And you want this to scal...
Read More - REFERENCE7 min read
Advanced config.yaml
Last week, I wrote an article going over the basic configuration options in Dolt's main SQL Server configuration file, config.yaml . That article was already really long, clocking in at a 23 minute read according to Gatsby, our blog publish...
Read More - WORKBENCHFEATURE RELEASE2 min read
Announcing the Dolt Workbench Remotes Tab
We’re excited to announce a new feature in the Dolt Workbench : the Remotes tab! This allows you to set up remotes and sync your databases with them by pulling and pushing changes. The Dolt Workbench is available for download in the Mac and...
Read More - REFERENCE5 min read
Dolt Certs
In my last blog I talked about a lot of aspects of taking your Dolt database to production. One of the things I mentioned was the importance of securing your database, but didn't cover the acquisition and deployment of SSL certificates. In th...
Read More - REFERENCE4 min read
Mydumper Works with Dolt
Dolt is a drop in-replacement for MySQL, which means it can be used with any MySQL-compatible tool. One such tool is Mydumper and its counterpart Myloader. Mydumper is a MySQL Logical Backup tool that emphasizes parallelism and performance. I...
Read More - DOLTHUBFEATURE RELEASE13 min read
Pull Request CI on DoltHub
In November, we announced support for continuous integration (CI) testing on DoltHub , which lets users programmatically run checks on their databases. At the time of the announcement, these checks were limited to push events, but today we'...
Read More - REFERENCE6 min read
MySQL-9.0, Dolt, and Caching SHA-2 Auth Support
Lately, we've seen customers install the latest innovation release of MySQL (i.e. MySQL-9.0) and then have problems connecting to a Dolt SQL server due to MySQL-9.0 removing mysql_native_password auth support. In this post, we'll explain what...
Read More - REFERENCE23 min read
A Tour of config.yaml
Hot on the heels of my overview of Dolt configuration , I'm going to do a deep dive on config.yaml , the configuration file for a Dolt SQL Server. As I was writing the configuration overview, I realized our documentation on our main configurati...
Read More - USE CASE6 min read
Decentralized Wikipedia Update
Dolt is a decentralized database . In the past ten years or so decentralization has gone through a few hype cycles. I think we're in a pro-decentralization hype period right now. Decentralization hype tracks the price of Bitcoin and last I checke...
Read More - DOLTGRES8 min read
Doltgres System Tables Update
We've been hard at work getting Doltgres , a Postgres-flavored version of Dolt , ready for its beta release in Q1 . This includes making sure all the version control features you know and love from Dolt also work properly in a Postgres enviro...
Read More - GOLANG15 min read
What's Missing From Golang Generics?
Last time, I discussed a specific design problem that I encountered while writing generic code in Go, and how I eventually solved it. I was proud that I had found a solution, although less proud that it wasn't the cleanest. ...
Read More