Tim Sehn

July 12, 2023

Here at DoltHub , we built Dolt , the world's first version controlled SQL database . Dolt is MySQL-compatible so all the tools you're used to using with MySQL work the same way with Dolt, like SQLAlchemy . SQLAlchemy is a popular Pyth...

Liu Liu

July 10, 2023

For those of you that are new, Dolt is a database that supports Git-style versioning. DoltHub is a place on the internet to share and collaborate on Dolt databases. We are excited to announce a new feature in our documentation that showcas...

Jason Fulghum

July 7, 2023

At DoltHub , we love Go! We're building DoltDB , an open-source SQL database engine with Git-like distributed version control, all implemented in Golang. (Actually... astute blog readers will remember that we have a little bit of C code in th...

Dustin Brown

July 5, 2023

In June of this year we released DoltLab v1.0.0 which uses Dolt as its default application database instead of PostgreSQL , providing out-of-the-box, version-controlled data for all of our DoltLab customers. Today, I'll cover how you can su...

Taylor Bantle

June 30, 2023

Hosted DoltDB is for running online, production Dolt databases. Hosted comes with a built-in SQL Workbench . We recently added CSV support to the workbench, including uploading CSVs to update tables in your database and exporting query resul...

Alec Stein

June 28, 2023

I'm staring down 400M rows of hospital prices that, to my knowledge, haven't been seen before by the public. At least not all in one place, and definitely not by someone like me, who's more used to avoiding medical bills than trying to make sense o...

Tim Sehn

June 26, 2023

A high security network can have what is called an "air gap" . An air-gapped network is a network where there are no physical connections to other networks. To get data in and out of an air-gapped network, someone physically must bring the data a...

Max Hoffman

June 23, 2023

Dolt was originally designed as a standalone CLI tool for supporting distributed asynchronous data sharing with the same primitives as Git. But we are now a database company. We still support data sharing with Git semantics but increasingly in a…

Tim Sehn

June 22, 2023

Slowly changing dimension is a framework used to discuss database versioning . It can be used to simulate database version control . In the past, database version control needed to be simulated using slowly changing dimension because the t...

Jason Fulghum

June 21, 2023

Dolt is the world's first fully-versioned SQL relational database. It enables you to branch, fork, diff, and merge your tables, and to time travel to any point in your data's history and examine how your data and schema have changed over time…

Aaron Son

June 16, 2023

This article discusses the technical details of static initialization for map data in Go binaries, and some alternative strategies for dealing with the performance impacts. It's part of our our technical Golang blog series. We publish a new arti...

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

Git and MySQL had a baby, and it's called Dolt. That wasn’t always the case though. Let’s talk a little about Dolt’s history, and where we’re going with the Dolt Command Line Interface (CLI). In The Beginning Dolt started out as a command ...

Zach Musgrave

June 9, 2023

MySQL allows you to define triggers on your tables that will do additional work or validation every time data in the table is changed. This tutorial will teach you how to use triggers and give you some ideas about what they're good for. ...

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

This article discusses the technical details of writing integration tests that manage multiple sub-processes in Golang, including attaching debuggers to the new processes. It's part of our our technical Golang blog series. We publish a new article...