Jason Fulghum

December 16, 2022

DoltDB is a MySQL-compatible database with Git's distributed versioning features. It's the first relational database that versions your data changes AND your schema changes. Today's blog post is a teaser for a new project we're working on... My

Zach Musgrave

December 14, 2022

It's 2022, and the version control wars are conclusively over. Everybody uses git, but hardly anybody really understands it, and even fewer truly love it. I think these last two points are related. It's hard to

Dhruv Sringari

December 12, 2022

DoltHub is the place to share Dolt 's version controlled databases. Last month, we created a migrate button that automatically migrates your Dolt databases to the latest storage format. We've since migrated all ~100 public databases on the Do

James Cor

December 9, 2022

If you haven't heard, Dolt is a SQL database with Git versioning . A couple of months ago, a customer asked for prefix indexes , so we implemented them. In this blog, we'll discuss how to use prefix indexes, their benefits, as well as their lim

Daylon Wilkins

December 8, 2022

Here at DoltHub, our centerpiece is Dolt, which fuses a MySQL-compatible database with Git-style versioning capabilities. After you install Dolt , all it takes are a few commands to have a running server: mkdir demo cd demo dolt init dolt

This is a guest post by Rimantas Lukosevicius. He is a regular bounty contributor and this is his first data analysis blog for us. Who and Where are the NIMBYs? During the second iteration of DoltHub's USA housing price data bounty a

Max Hoffman

December 5, 2022

Dolt is the first SQL database with Git versioning . We are drop-in MySQL compatible, support every Git command, and are actively defining a new frontier at the intersection of the two APIs. Last month we wrote an import tutorial with initi

Alec Stein

December 2, 2022

This work was done with help of Dr. Jaan Altosaar at One Fact Foundation . You can reach him at jaan@onefact.org . We just built a data bank of hospital price lists: lists that are supposed to contain all of a hospital's prices. To our know

Taylor Bantle

November 30, 2022

Google announced earlier this year that Universal Analytics will stop processing data on July 1, 2023 (July 1, 2024 for Analytics 360 Properties) in favor of their newer Google Analytics 4 . You can think of Google Analytics 4 (GA4) as a ne

Aaron Son

November 28, 2022

We're building Dolt , the world's first SQL database with Git-like version control . Dolt has a large test suite, partly in golang unit tests and partly in bats , a framework for writing tests that run in Bash and can easily test many interac

Tim Sehn

November 23, 2022

Data Quality Control is a big, broad topic. So, I'm warning you in advance, this article is going to be long, like 4,000 words long. Here at DoltHub we built the world's first version controlled SQL database , Dolt . In traditional softwa

Max Hoffman

November 21, 2022

Dolt is the first database that versions data like Git versions code. We focused on a few key areas for improving Dolt this year: 1) sharpening MySQL feature parity, 2) smoothing the first hour experience, and 3) chasing MySQL's performance. Tod

Zach Musgrave

November 18, 2022

Today, I want to talk about a new term that I just invented but feel certain is destined for fame or even infamy: cozy data . To introduce what I mean by this groundbreaking concept, I think it's easiest to come at it sideways by describin

Mario Lopez

November 16, 2022

In May we launched Hosted DoltDB , a cloud-hosted Dolt database with built in logs and monitoring. For those new to Hosted DoltDB , here are some blogs to get you up to speed. Introduction to Hosted Dolt Hosted Dolt Infrastructure

Daylon Wilkins

November 14, 2022

Here at DoltHub, our centerpiece is Dolt, which fuses a MySQL-compatible database with Git-style versioning capabilities. After you install Dolt , all it takes are a few commands to have a running server: mkdir demo cd demo dolt init dolt sq

Taylor Bantle

November 11, 2022

TL;DR Git versions files and Dolt versions data . The diff and log commands in Git and Dolt are useful tools to view what has changed between different revisions. You can control what changes you want to include when listing logs

James Cor

November 9, 2022

If you haven't heard, Dolt is a version controlled database, kinda like if Git and MySQL had a baby. Not too long ago, we announced partial support for Spatial Data Types . Since then, we've received requests for the rest of the Spatial Types,

Zach Musgrave

November 7, 2022

We're building Dolt , the world's first SQL database with Git-like version control . Recently, a customer contacted us to let us know that test symbols were making it into their binary when they took a dependency on our go-mysql-server l

Max Hoffman

November 4, 2022

Dolt is a relational database with Git versioning primitives. Dolt versions data where Git versions code. Most of our users are interested in transactional workloads, but we also have customers with heavier analytical queries. Joins have been th

Tim Sehn

November 3, 2022

This recent article and corresponding Hacker News thread brought the topic of soft deletes to my attention. People have been wondering if soft deletes are a good idea for a long time . Here at DoltHub , we built a version controlle