- 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
- FEATURE RELEASESQL5 min read
Dolt Now Supports Online Garbage Collection
Dolt is a version controlled SQL database that you can branch, merge, and diff. Dolt stores data in a prolly tree to efficiently support these operations, which can come with write overhead and use a lot of storage. You can reduce the am...
Read More - SQL6 min read
Simulating System Table Indexes
Dolt is the first version controlled SQL database. Dolt uses Git semantics to branch and commit state checkpoints, and MySQL semantics to define, mutate, and access data. We've optimized a variety of performance benchmarks over the last year: ...
Read More - REFERENCE10 min read
Getting Started: Git for Data
Last June, I published a Getting Started: Version Controlled Database blog that quickly became Dolt's GitHub README . As I say in that blog: Dolt started as a data sharing tool, "Git for Data" . Dolt's original focus was implementing G...
Read More - FEATURE RELEASESQL7 min read
Unlocking Time-Travel for Data and Code
Imagine, for a moment, that both code and data were not constrained to the present. With a "standard" database, your data lives only in the present. Sure, with backups you're able to recall the past, but to do so means to fully immerse yourself in…...
Read More - BOUNTY5 min read
Shrinking the insurance data dump
On its face, it's hundreds of terabytes, millions of files, and trillions of negotiated rates between insurers and providers. But the health insurance data dump is probably smaller than it seems. Back in July, health insurers published all their...
Read More - TECHNICAL3 min read
DoltHub goes to GopherCon
Dolt is the world's first SQL database with Git-style version control. We spent the first part of 2022 working on our performance, in large part by re-writing the storage engine. In October, we were lucky enough to be invited to speak about this ...
Read More - TECHNICAL5 min read
- USE CASE7 min read
- REFERENCE7 min read
So you want Data Merge?
A survey of the data merge space. Data merge in not mail merge. New tools exists to merge two tables at scale. This is true data merge.
Read More - SQL4 min read
MySQL Compatibility for Decimal and Floating Point Arithmetic
For those who are unfamiliar with Dolt , it is a version controlled SQL database. If you know what GitHub and MySQL are, you already know how to use Dolt! We have been improving our compatibility with MySQL everyday by implementing MySQL features...
Read More - GOLANG5 min read
Hacking Go's Runtime with Generics
A release of a new golang package for hashing generic types.
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
Explains how we improved blob write performance
Read More - WEB5 min read
Adding Google Analytics 4 to an existing Gatsby and Next.js application
Google Universal Analytics will stop collecting data on July 1, 2023. Learn how to add the new Google Analytics 4 (GA4) property to start collecting data from your Gatsby and Next.js applications.
Read More - GOLANG6 min read
Some Useful Patterns for Go's os/exec
A collection of useful patterns for interacting with spawned processes using os/exec.
Read More