- 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
- 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
A demonstration, complete with sample code, on how to use Dolphie with Dolt, the world's first version controlled SQL database.
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
Dolt Workbench now lets you set up remotes and sync databases by pulling and pushing changes.
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
A demonstration, complete with sample code, on how to use Mydumper with Dolt, the world's first version controlled SQL database.
Read More - DOLTHUBFEATURE RELEASE13 min read
Pull Request CI on DoltHub
We're excited to announce that CI testing on pull requests is now live on DoltHub.com.
Read More - REFERENCE6 min read
MySQL-9.0, Dolt, and Caching SHA-2 Auth Support
Dolt now supports caching_sha2_password auth, which you may need if you want to use the MySQL-9.0 innovation release.
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
As Doltgres is being rapidly developed, we needed Postgres-specific solutions to certain version control features that are implemented in Dolt. This blog walks through how we converted MySQL-flavored system tables in Dolt to Postgres-flavored system tables that account for different schemas and types in Doltgres.
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 - REFERENCE5 min read
Dolt Configuration
Dolt configuration is a bit of a mess. To start, it's a union of Git and MySQL styles of configuration. Then, Dolt specific configuration is sprinkled on top. It's been on our list for a long time to consolidate and rationalize Dolt configuration...
Read More - REFERENCE2 min read
Dolt SSL Authentication
Dolt is the world's first and only version controlled SQL database. Dolt is fully MySQL-compatible. You connect to it with any MySQL client. Some MySQL clients require connection authentication using Transport Layer Security (TLS) . TLS is ofte...
Read More - REFERENCE4 min read
Workbenches are Better with a Version Controlled Database
The Dolt Workbench illustrates how much better the workbench experience can be when using a version controlled database. Find out how and why in this blog.
Read More - INTEGRATION8 min read
Using Perl to Query Dolt Databases
Perl is still alive and well and works beautifully with Dolt databases.
Read More