Max Hoffman

July 8, 2024

Multiversion concurrency control (MVCC) is a technique relational databases use to avoid concurrent transactions blocking one another. This is how databases move beyond the performance limitations of two-phase locking . Most databases have conv...

Jason Fulghum

July 5, 2024

Introduction Dolt DB is the world's first, and only, version-controlled SQL database. Dolt is a drop-in replacement for MySQL, so any tools or applications that work with MySQL will work with Dolt (if they don't... let us know so we can fix...

Tim Sehn

July 3, 2024

When you build a database from scratch , you hear a lot of reasons why potential customers choose not to use it. Dolt adds compelling Git-like version control features to the classic SQL database. These features are enough to get a lot of people…...

Taylor Bantle

July 2, 2024

It's our goal to make Doltgres , a Postgres-flavored version of Dolt , a drop-in replacement for Postgres. A few weeks ago Zach wrote a blog about our design dilemma for implementing the pg_catalog schema: should we diverge from Postgr...

Zach Musgrave

July 1, 2024

Introduction Go generics were released in Go 1.18, over two years ago. We're using Go to write Dolt , the world's first version-controlled SQL database, and while we have hundreds of thousands of lines of Go code, we haven't used generics v...

Liu Liu

June 28, 2024

Dolt is the world's first version controlled SQL database , offering full MySQL compatibility. This means that all tools you typically use with MySQL, including Prisma , work seamlessly with Dolt. Prisma ORM is an open-source toolkit desig...

Dustin Brown

June 27, 2024

DoltLab is the self-hosted version of DoltHub that lets you manage and customize a web-based Dolt remote complete with pull-request style workflows for seamless database collaboration. If you're looking to try DoltLab for the first time,...

James Cor

June 26, 2024

Welcome back to another installment of Dolt's monthly correctness updates! Here's last month's update , in case you missed it. This month, a couple new Dolt customers came to us with a variety of issues; they uncovered panics, syntax errors, and ...

Nick Tobey

June 25, 2024

Designing a schema for your relational database is a daunting task that has long term implications for the database's performance, maintainability, and correctness. And it often requires making decisions before having a clear picture of the exact…

Tim Sehn

June 24, 2024

Dolt is a version controlled SQL database . How would you use such a thing? Are you building a data curation application for your customers? Are your customers asking for version control features like branches, merges, and diffs on the data ...

Max Hoffman

June 21, 2024

One of Golang's steepest learning curves is how to use channels. At the practical level, channels are locked, buffered queues. Their API matches that of a queue, the implementation is a queue, and I find it easiest to write and read channel code...

Liu Liu

June 20, 2024

Introducing Badges on DoltHub: Celebrate Your Milestones As DoltHub continues to grow, we’re excited to see more users actively engaging — creating databases, merging pull requests, and opening issues. Following our previous blog about ...

Tim Sehn

June 19, 2024

Dolt implements a Git-style commit graph on top of a Prolly-tree -based storage engine . This architecture makes Dolt the world's first and only version controlled SQL database . One of the major capabilities a version controlled SQL ...

Jennifer Purevsuren

June 18, 2024

Doltgres is a version-controlled, PostgreSQL-compatible database. This means any standard Postgres client should connect to the Doltgres server. Today’s blog shares an update on how far we are to support the standard Postgres SQL clients. We r...

Jason Fulghum

June 17, 2024

MySQL's replication protocol is widely used to help systems achieve high availability, load balancing, and data redundancy. The replication protocol was originally introduced waaaay back in 2000, and in the more than two decades since then, the…

Max Hoffman

June 14, 2024

Dolt is the first relational database that versions data the same way Git versions source code. Dolt is 100% MySQL compliant and implements Git's interface with the same "proportional to diff" runtime. We spend a lot of time making sure we compe...

Dustin Brown

June 13, 2024

We recently released DoltLab v2.1.6 which allows DoltLab Enterprise to use cloud storage, instead of disk storage on the DoltLab host. At the time of this writing, only AWS cloud resources are supported. This blog will walk you through set...

Nick Tobey

June 12, 2024

tl;dr: Querying JSON documents in Dolt is about to get a huge performance boost. Beginning with Dolt 1.40, we're changing the way that Dolt writes JSON documents to disk. This will allow us to greatly improve performance when working with JSON. T...

Zach Musgrave

June 11, 2024

Introduction We're hard at work building Doltgres , a Postgres-compatible database with git-inspired version control features. Our long-term goal is to be a drop-in replacement for Postgres, so that application developers can use Doltgres w...

Tim Sehn

June 10, 2024

Dolt is a version controlled SQL database . How would you use such a thing? Are you building a data curation application for your customers? Are your customers asking for version control features like branches, merges, and diffs? Are you loo...