Tim Sehn

March 5, 2024

Dolt is the world's first version controlled SQL database . How would you build such a thing? Dolt's unique storage engine implements a Git-style commit graph of Prolly Trees . This blog explains the Dolt commit graph in detail and how ...

Tim Sehn

March 3, 2024

"Prolly Tree" is short for "Probabilistic B-tree" . "Prolly Tree" was coined by the good folks who built Noms , who as far as we can tell invented the data structure. We here at DoltHub have immense respect for their pioneering work, without...

Tim Sehn

February 29, 2024

Dolt is the world's first version controlled SQL database . How would you build such a thing? A few months ago, I wrote an article outlining the motivations, requirements, and choices that led to Dolt's Architecture . Today, in the next...

Jason Fulghum

February 28, 2024

DoltDB is the world's first fully-versioned relational database . You can branch, merge, diff, push, and pull your relational data in the same ways that Git allows you to work with source code files. If you're curious what sorts of use cases th...

James Cor

February 26, 2024

Dolt is a SQL database with Git-like versioning features intended to be a drop-in replacement for MySQL. In order to be a drop-in replacement, Dolt needs to match MySQL behavior as closely as possible. We chose sqllogictests , a collection of ...

Stephanie You

February 23, 2024

When working with command-line applications in Go, color can be a great way to enhance the user experience, convey information in a more visually appealing way, or generally communicate more effectively. In this article, I'll show you some easy way...

Neil Macneale

February 21, 2024

Dolt is the first version controlled SQL database, and the natural consequence of that is it needs to store every value of every row that has ever existed in your database. Git is similar, and it turns out that st...

Dustin Brown

February 19, 2024

In a recent blog post Zach demonstrated that building Dolt using Golang's Profile-Guided Optimization (PGO) improved benchmarking performance by 5%. Today we're excited to announce that Dolt releases, starting with v1.32.4 , are now buil...

Max Hoffman

February 16, 2024

Dolt is close to 100% MySQL compatible and only 2x slower than MySQL. Few customers find bugs that we cannot fix in under 24 hours, and the difference between a 10ms query in Dolt that is 5ms in MySQL is usually OK. But on rare occasions we still…

Daylon Wilkins

February 14, 2024

In November 2023 , we officially started development on DoltgreSQL , which is a version of Dolt built to be a drop-in replacement for PostgreSQL. For those that may not know, Dolt is the world's first database that is built, from the grou...

Taylor Bantle

February 12, 2024

Hosted Dolt is for running online, production Dolt databases. Last year we added support for read replicas . You can choose up to 8 read replicas and every write to the primary server is replicated to the read replicas. Since then, we've inc...

Tim Sehn

February 9, 2024

We're on a mission to show that Dolt , the world's first version controlled SQL database , works with all your favorite tools in all your favorite languages . Today we head to Ruby -land and show you how to integrate Dolt with Rails , a p...

Brian Hendriks

February 7, 2024

In Go, tags allow developers to attach metadata to struct fields. These tags can drive features and behaviors in various libraries and tools which access the tags via reflection. This article provides an overview of tags in Go, including their synt...

Dustin Brown

February 5, 2024

Recently, a customer reached out to our team asking for a blog using Dolt with Testcontainers , "an open source framework for providing throwaway, lightweight instances of databases, message brokers, web browsers, or just about anything that c...

Zach Musgrave

February 2, 2024

Introduction We're building Dolt , the world's first version-controlled SQL database. We measure Dolt's performance with sysbench , an industry standard set of SQL benchmarks that you can use to get an apples-to-apples performance compari...

Tim Sehn

January 31, 2024

We're on a mission to show that Dolt , the world's first version controlled database , works with all your favorite tools in all your favorite languages . Today we head back to Python -land and show you how to integrate Dolt with Django ,...

James Cor

January 29, 2024

Dolt is a versioned database that has a mix of Git and MySQL features. One of our goals is to be a drop-in replacement for MySQL. As a result, we need to support all the functions MySQL does; these are things like SIN() , CONCAT() , CURRENT_T...

Zach Musgrave

January 26, 2024

MySQL allows you to define views on your databases that let you write complex queries you can select from just like they were tables. This tutorial will teach you how to use views and give you some ideas about what they're good for. What...

Tim Sehn

January 24, 2024

A customer wanted to use Metabase to visualize Dolt databases. Dolt provides powerful versioning features to Metabase charts and dashboards. Dolt "just works" with Metabase using the MySQL connector so it's really easy to get started. T...

Max Hoffman

January 22, 2024

Dolt is the first relational database with history independent version control. Dolt's Git-like commit graph captures snapshots in a format that efficiently diffs and merges tables and schemas. We recently added index scan costing to Dolt's S...