- REFERENCE9 min read
So you want Database Versioning?
Here at DoltHub, we've had a lot of success with our "So you want..." series of blog posts helping people find Dolt when they are looking for it. Dolt is a lot of things. Dolt is a version controlled database, a Git database, Git for data, data…
Read More
- INTEGRATION8 min read
Coming soon... MySQL Binlog Replication
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
Read More - 8 min read
The Wordcel's Guide to Shape Rotation using the Git Commit Graph
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
Read More - 4 min read
DoltHub's DBs are migrated. Are yours?
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
Read More - SQL5 min read
Prefix Indexes
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
Read More - FEATURE RELEASESQL6 min read
Improving Stored Procedure Support
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
Read More - BOUNTY10 min read
(Do Not) Let Them Build: Mining Open Data to find NIMBY and YIMBY counties
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
Read More - SQL7 min read
Cooperating with Golang's GC & Fast Blob Writes
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
Read More - BOUNTY4 min read
Open Source Hospital Price Transparency
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
Read More - WEB5 min read
Adding Google Analytics 4 to an existing Gatsby and Next.js application
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
Read More - GOLANG6 min read
Some Useful Patterns for Go's os/exec
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
Read More - REFERENCE16 min read
So you want Data Quality Control?
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
Read More - SQL7 min read
Three Ways to Import Data into Dolt
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
Read More - HOSTEDFEATURE RELEASE2 min read
Hosted Dolt now has Organization Teams
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
Read More - FEATURE RELEASESQL10 min read
Introducing Branch Permissions
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
Read More - REFERENCE8 min read
What Do Two Dot and Three Dot Mean for Logs and Diffs?
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
Read More - SQL3 min read
Dolt Supports Every Type
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,
Read More - GOLANG16 min read
Pruning test dependencies from Go binaries
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
Read More - SQL9 min read
Memoizing Joins
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
Read More - REFERENCE6 min read
So you want Soft Deletes?
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
Read More