Tim Sehn

August 7, 2023

When I was writing my opus on Slowly Changing Dimension , I came across the term "temporal database" . I had not heard of a "temporal database" before. I had heard of "temporal tables" but not a "temporal database". After doing a bit of researc...

Neil Macneale

August 4, 2023

Here at DoltHub, we strive to ensure the Dolt database can be a drop in replacement for MySQL . There are almost 3 decades of development on MySQL, and we occasionally hear that we are crazy to attempt a full re-write. We're fine being called cra...

Taylor Bantle

August 2, 2023

Welcome to the RGD (React + GraphQL + Dolt) stack! As Dolt , the world's first version controlled database, has grown from a better way to share data to a MySQL-compatible OLTP SQL database with Git fea...

Nick Tobey

July 31, 2023

Dolt is a MySQL-compatible server with Git-style version control. Users want to use Dolt as a drop-in replacement for MySQL or as a replica for their MySQL database. For this to work, we need to be correct : all user queries should have t...

Zach Musgrave

July 28, 2023

This article discusses the technical details of writing yacc grammars / parsers using the goyacc tool. It's part of our our technical Golang blog series. We publish a new article in the series every 3 weeks. We're writing Dolt , a version-con...

Daylon Wilkins

July 26, 2023

Today, we are proud to announce the initial release of Full-Text indexes! This is very important for us, as Dolt is a drop-in replacement for MySQL, that gives you all the versioning features that you're used to from Git . As we're developin...

Alec Stein

July 24, 2023

While cleaning our hospital price database , I learned that GPT-4's function calling could quickly crack one of our hardest nuts. The context Since 2021, hospitals have been required to publish tables of: billing codes, representin...

Neil Macneale

July 21, 2023

Git for Data is at the root of DoltHub's DNA, and we believe that the Dolt Command Line Interface (CLI) should behave similarly to git. People familiar with git sit down to use the Dolt CLI, and it's impossible to miss the similarities. Data is n...

Max Hoffman

July 19, 2023

Dolt is the first SQL database that branches, diffs, and merges data the way Git version controls text. We expected versioning data to be different than versioning code. But as the first database with structural sharing at the storage layer, Dolt i...

Brian Hendriks

July 17, 2023

Introduction We are excited to announce that Hosted Dolt , the fully managed SQL database with Git-style versioning, has expanded its offering to include European regions on multiple cloud platforms. With this expansion, Hosted Dolt user...

Tim Sehn

July 14, 2023

Note: We released a Postgres version of Dolt called DoltgreSQL . It's been over a year since I published the original Have Postgres. Want Dolt. article. Interest in a Postgres-flavored version of Dolt has not waned. On average, about o...

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...