Tim Sehn

June 22, 2023

Understand slowly changing dimension definitions, methods, and tools. Outlines the business benefits of using slowly changing dimension for database versioning. Introduces Dolt, the first SQL database with built in slowly changing dimension.

Jason Fulghum

June 21, 2023

The `@@dolt_transaction_commit` system variable turns all SQL commits into Dolt commits, enabling you to have a versioned history of your data without having to explicitly call dolt_commit().

Aaron Son

June 16, 2023

Runtime costs and strategies for static initialization in Go

Brian Hendriks

June 15, 2023

The database is the heart of most applications. It's where the data that drives your web applications lives. It's where your users' data is stored. The data in your database may be used in countless ways such as analytics, machine learning, and…

Neil Macneale

June 12, 2023

Dolt's Command Line Interface is being modernized to integrate better with our SQL Server. A little history, and a plan for the future.

Zach Musgrave

June 9, 2023

In this tutorial, learn how to define triggers in MySQL and what they're good for, with examples

James Cor

June 7, 2023

In case you haven't heard, we're now Dolt 1.0 !. However, we're not finished. In this blog, we'll go over some recent improvements to Dolt's JSON handling. Additionally, I'll go through some examples of JSON handling to showcase the new functiona...

Dustin Brown

June 5, 2023

In early May we announced Dolt v1.0.0 , the first stable release of Dolt, signaling that Dolt is ready for production use. Shortly thereafter we revealed that DoltHub.com now runs on Dolt. In my previous blog post I explain how we transitio...

Daylon Wilkins

June 2, 2023

I'm an engineer at DoltHub , and for the past month, I've been working on matching Dolt 's regular expression capabilities with MySQL. This is important for us, as Dolt is a drop-in replacement for MySQL, that gives you all the versioning ...

Brian Hendriks

May 31, 2023

Dolt is Git for Data. It's a MySQL compatible database with Git-style versioning and branching built in. We launched Hosted Dolt a little over a year ago and since then we've released additional metrics, improved logs, created a sql workbench,...

Jennifer Purevsuren

May 30, 2023

Dolt is a version-controlled relational database that supports MySQL features. Today, we are excited to announce that we are adding support for MySQL Events . These are tasks that run on a specific schedule, such as executing a query statemen...

Zach Musgrave

May 25, 2023

How to launch multiple Golang binaries from a test and attach your debugger to them

Alec Stein

May 24, 2023

Hospital price data is pretty damn tedious to collect . There thousands of different formats for these files, which by and large contain the same kind of data, just phrased differently. That makes it expensive to buy and time consuming to make. ...

Tim Sehn

May 22, 2023

Nike is synonymous with the "Just Do It" ad campaign. Some people think "Dolt" is "DoIt", "Do It" with the space removed. Notice there is no difference in some fonts, like the one we use for this blog. No one would name their database Dolt, as in "...

Daylon Wilkins

May 19, 2023

Sometimes, the most complicated solution may end up being the simplest. This sounds like a contradiction, but it depends on where a project's priorities lay. I'm an engineer here at DoltHub , and about 9 months ago I implemented collation su...

Taylor Bantle

May 17, 2023

We have two web products for Dolt : DoltHub and Hosted Dolt . DoltHub is GitHub for Dolt and Hosted is AWS RDS for Dolt. Each product has different use cases depending on your goals, but there are also reasons to use DoltHub and Hos...

Zach Musgrave

May 15, 2023

Struggling with a crippling addiction to YAML? You aren't alone. We can help.

Dustin Brown

May 12, 2023

For the past few months at DoltHub , we've been really excited about the release of Dolt 1.0 . If you missed it, it dropped last Friday May 5th. Dolt 1.0 is the first stable release of Dolt and guarantees forward storage compatibility, produ...

Pavel Safronov

May 10, 2023

Dolt is a MySQL-compatible database that allows branching, diffing, and merging database changes. In this blog post, we will discuss how Dolt is being used with a network automation solution called Nautobot and the recent fixes we've had to ma...

Tim Sehn

May 8, 2023

There are a bunch of ways to get started with Dolt , the word's first and only version controlled database . You can run Dolt locally as a version controlled database or as Git for Data . You can start using Dolt by sharing data on Do...