- 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
- REFERENCE6 min read
Dolt for Beginners: Dolt Basics
Dolt is like Git and MySQL had a baby. What does that mean in practice? We've been building Dolt for over six years now. We've been writing three blog articles a week for five years and five blog articles a week for almost a year. As we've produ...
Read More - 4 min read
Fetching Tags: Faster than Ever!
Dolt, the world's first SQL database which supports branching and merging , is an open source product built by a startup. As with all startups, we need to move fast and get features into the hands of our users as quickly as possible. Occasionally...
Read More - SQL4 min read
Mind The convT
We're using Go to write Dolt, the world's first version-controlled SQL database. This blog discusses how we sped up our table scans by 24% by avoiding interfaces at critical junctions. Interfaces Are Handy They modularize code along lines ...
Read More - SQLFEATURE RELEASE6 min read
Announcing Vector Indexes
Back in September, we announced that we were looking at adding support for Vectors and Vector Indexes to Dolt . It seems like every SQL database these days is going all in on vectors, and here at DoltHub we wanted to not just jump on that band...
Read More - RELEASEREFERENCE5 min read
Dolt Root Superuser Changes
Version 1.46.0 of Dolt makes two important changes to improve the default root superuser. This default superuser is now persisted to disk, just like any other user account, and it is also now restricted to localhost by default. These changes f...
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