James Cor

August 5, 2024

Welcome to another edition of Dolt's monthly correctness updates! If you missed it, here's last month's update . This month, we resolved customer issues with ORMs, tackled older date and time bugs, and dealt with a long standing auto increment is...

Tim Sehn

August 2, 2024

Here at DoltHub, we ship a number of products . Dolt is an Online Transaction Processing (OLTP) database with Git-style version control, like Git and MySQL had a baby. DoltHub is Dolt's GitHub, an online collaboration platform for Dolt data...

Dustin Brown

August 1, 2024

Earlier this week we released DoltLab v2.3.0 . This release signifies the end of our months-long endeavor to make the first-time DoltLab user experience as simple and straightforward as possible. In this release, we've removed TLS configuration i...

Neil Macneale

July 31, 2024

Here at Dolt, the first database to provide version control features like Git, we've been lucky to leverage existing code extensively while building our product. One piece we leveraged very heavily was Noms , and for the purposes of our discussio...

Zach Musgrave

July 30, 2024

Introduction We're hard at work building Doltgres , a Postgres-compatible database with git-inspired version control features. Before we built Doltgres we built Dolt , which is MySQL-compatible instead. But there are many differences b...

Max Hoffman

July 29, 2024

This year, Dolt started passing every test in the sqllogictest suite . Correctness is crucial for reliability, but also lets us confidently reengineer the SQL engine for performance. One of the ways we are making query execution faster is c...

Aaron Son

July 26, 2024

Over two years ago, we launched our first hosted offering for Dolt. Since then, we have added features like the SQL workbench , support for Google Cloud and Single-sign on support with SAML . Up until now, our hosted offerings have all be...

Tim Sehn

July 25, 2024

One of the major themes here at DoltHub for the next year or so is trust. We built Dolt , the world's first version controlled SQL database. We know innovating at the database layer of your stack requires complete trust in the new technology y...

Nick Tobey

July 24, 2024

If you've spent enough time writing in Golang, you've probably written code like this by accident: // FinalizeSomeWork returns an error on failure, and nil on success. func ( c * Connection ) FinalizeSomeWork ( ) error { ...

Tim Sehn

July 23, 2024

Lately, I've been writing a lot about three-way merge . Dolt is the first and only SQL database to provide three-way merge of both schema and data. Being first means we get to define how three-way works for SQL databases. Defining behavior can...

Max Hoffman

July 22, 2024

The first production version of Dolt was released a little over a year ago. Since then we have been narrowing the performance differences between MySQL and Dolt. We've blogged several times recently about improving Dolt's transactional throug...

Jason Fulghum

July 19, 2024

A few weeks ago, we announced the first release of support for Dolt-to-MySQL replication . Dolt now supports replicating to a MySQL database and from a MySQL database, through the MySQL binlog protocol . In addition to replicating databases to ...

Tim Sehn

July 18, 2024

The inspiration for Dolt and DoltHub was data sharing. Most data today is shared via file. Common data formats are CSV, XML, or JSON. Dolt is a fully capable MySQL-compatible SQL database with Git-like version control. We share open source us...

Aaron Son

July 17, 2024

Introduction Over four years ago, we wrote about how we use Bash Automated Testing System (Bats) to test Dolt . We love bats for automated end-to-end tests of Dolt use cases that make use of the Dolt CLI. At the time that the blog launch...

Tim Sehn

July 16, 2024

What open source database is faster? Postgres or MySQL ? It's surprisingly hard to find latency benchmark comparisons between these two databases. Here at DoltHub, we're building the world's first version controlled SQL database, Dolt . D...

Nick Tobey

July 15, 2024

Last month we announced that we were making changes to how Dolt stores JSON documents , in order to make Dolt best-in-class for manipulating JSON within a SQL database. Today, we're going to explore exactly what that means, how we accomplished it...

Zach Musgrave

July 12, 2024

Introduction We're using Go to write Dolt , the world's first version-controlled SQL database. Like most large Go codebases, we have a lot of collection types that we iterate over. New in Go 1.23 , you can now use the range keyword to ...

Dustin Brown

July 11, 2024

Today we're announcing the release of DoltLab v2.2.0 that contains some important new changes that make getting started with DoltLab much easier. This year our focus with DoltLab has been improving the first-time user experience. So far, we'v...

Tim Sehn

July 10, 2024

As promised in Three-way Merge Opus , I've come with a plethora of examples of three-way merge in a SQL database. Dolt is the only SQL database to support three-way merge of both data and schema. Getting Started Start with the database w...

Zach Musgrave

July 9, 2024

Introduction We're hard at work building Doltgres , a Postgres-compatible database with git-inspired version control features. Doltgres is built on top of Dolt , which uses MySQL's syntax and wire protocol. Dolt has tens of thousands of t...