Blog

Today's blog is a quick how-to guide aimed at helping others provision and actually use more than 2TBs of disk on an AWS EC2 Ubuntu 20.04. I never planned on writing this blog, but experiencing the surprisi…

Introduction Dolt is git for data, the world's only SQL database that you can branch and merge, clone and fork, push and pull just like a git repository. It's like Git and MySQL had a baby. Being nati…

In my last blog post, I went over how we initially implemented foreign keys on our database—Dolt, which fuses a fully MySQL-compatible database with Git-style versioning capabilities—and how our first decisi…

A survey of data version control tools for Git-like version control of files, data pipeline version control, versioned data lakes, and version controlled databases. Dolt is a version controlled database.

Everyone has that favorite route that they use to drive to work. You’ve driven the route over and over and learn to trust and rely on it over time. You know exactly how long your drive is going to take and …

US Hospital Price Transparency Bounty Retrospective A year ago we launched DoltHub data bounties. If you're unfamiliar, we use Dolt to create open databases that don't exist anywhere else on the internet. W…

Last year we announced prepared statement support, a simple form of query parameterization. True prepared statements save plans to be executed later, often multiple times. But the original work only progre…

What are data bounties? DoltHub data bounties are our way of getting people to use Dolt: in each bounty, we build meaningful datasets together using Git-style pull requests. If you haven't participated in a…

When building a database, there are many decisions to be made regarding its implementation. Our database is Dolt, which is a SQL database with Git-style versioning. We're modeling our SQL implementation on M…

A couple weeks ago, somebody at Atlassian had a really bad day. Seems like they didn't realize it at the time, but their customers noticed pretty quickly. Atlassian makes a bunch of software engineering t…

I'm currently staring at what I think might be the biggest open database of housing sales records ever. It's 50GB of uncut housing sales records straight from the government coffers. Tens of millions of them. …

Welcome back to the second post in this blog series exploring the magic that makes Dolt so unique and powerful. Dolt DB is a MySQL-compliant SQL database that also provides the distributed versioning featur…

For those new to Dolt and DoltHub, Dolt is Git for data. Git versions files. Dolt versions SQL tables. DoltHub is a place on the internet to share Dolt databases. Recently we received a feature request from…

Today we're going to discuss a series of schema bugs discovered in our version-controlled database, Dolt. It manifested in three related ways, from the display layer, into the storage layer, and finally the…

Today we are excited to announce the release of DoltLab v0.3.1, the product that lets you self-host your own DoltHub! Hopefully you've been following along with our DoltLab announcements and related blog po…

What Makes Dolt Easy? We think one of the big advantages of Dolt is that it can be downloaded and running on your machine in under a minute. Maybe a little bit longer when you set up your DoltHub login so y…

Go 1.18 has been released and along with it comes long-awaited support for Generics! Generics are the most significant change to the language in years. They add a new dimension to what is otherwise a minimal…

Introduction We have been working hard towards making Dolt a production-grade, MySQL compatible database. Last year, we discussed MySQL compatibility in the form of SQLLogictests where we hit 99% correctne…

Note: We released a Postgres version of Dolt called DoltgreSQL. Dolt is the first version controlled SQL database. DoltHub is a place on the internet to share Dolt databases. DoltLab is a self-hosted ve…

Version Control your Existing Database One of the best use cases to get started using Dolt is to version control your existing database in Dolt. This is additive to your existing environment and won't requi…