- 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
- WEBFEATURE RELEASE4 min read
Automate Your Database Workflow with the New DoltHub API
We are excited to announce the release of the new DoltHub API, designed to make it easier to manage and collaborate on databases programmatically. The DoltHub API offers a range of features that can help streamline your work and improve produ...
Read More - 7 min read
Type embedding: Golang's fake inheritance
Last week a complaint from a gopher about his coworkers bringing Java conventions to a Golang codebase made a minor splash on Reddit. Their complaints: All context.Context are currently being stored as fields in structs. All sync.Wai...
Read More - 15 min read
Exploring NanoGPT
ChatGPT is all the rage. I asked ChatGPT if you could raise money if you haven't blogged about it and I did not agree with the response. I may need to raise money again. So, here we go. I was inspired by ...
Read More - FEATURE RELEASE8 min read
Dolt Binlog Replication Preview
Dolt Binlog Replication Preview Today, we are excited to announce Dolt's support for replicating from a MySQL binlog ! This initial support allows a Dolt sql-server to configure a MySQL or MariaDB instance as its replication source, connect...
Read More - BOUNTY4 min read
Open source lab test pricing data, and why prices vary so much
Hospital lab tests are commodities: a test is a test is a test. So how can end up with a $8,500 mole biopsy or a $28,000 strep throat cell culture ? Many investigations raise this question but stop short of answering it. We dug into this qu...
Read More - USE CASEREFERENCE8 min read
Dolt + Looker Studio
A couple weeks ago I wrote about how to use Dolt with Apache Superset . Dolt provides powerful versioning features to Superset charts and dashboards. Dolt "just works" with Superset using the MySQL connector so it's really easy to get start...
Read More - 7 min read
MySQL Information Schema Compatibility
Dolt is a version controlled MySQL-compatible database, written from the ground up in Go. We're always working to close the remaining gap on full compatibility with MySQL. In this blog post, we're talking about the work we've done to make Dolt…
Read More - 9 min read
Version control for Video Game Development using Dolt
Dolt is the world's first SQL database that you can branch and merge, push and pull, fork and clone just like a git repository. A lot of people, when they hear about this, say "that's really cool, but what would I do with it?" The answer of cours...
Read More - USE CASE15 min read
Dolt for Backups
Dolt started as a data sharing tool . Dolt is still a great data sharing tool as you can see from DoltHub Data Bounties where people around the world collaborate on building open databases . But as Dolt got more popular, people wanted t...
Read More - SQL6 min read
Anti Performance
Dolt is the first fully version controlled relational database . Every Git command is exposed as a SQL function, allowing users to efficiently branch, diff, and merge tables. We recently added anti and semi join support. ANTI_JOIN and SEMI_J...
Read More - REFERENCEUSE CASEGOLANG10 min read
Embedding Go in C
Here at DoltHub, our centerpiece is Dolt , which fuses a MySQL-compatible database with Git-style versioning capabilities. People have found many creative uses for Dolt , but there's one area that Dolt has yet to step foot in: the library...
Read More - REFERENCE5 min read
Dolt for MySQL Database Versioning
Recently, I came across this Reddit post going over how they manage database versioning . I was particularly interested in this response To be fair it is really strong process for tracking and recording database c...
Read More - USE CASEREFERENCE6 min read
Dolt + Superset
A customer wanted to use Apache Superset to visualize Dolt databases. This customer runs DoltLab and intends to version hundreds of databases there. He wants a subset of those databases available to Superset for visualization. Dolt prov...
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
ACID Transactions in Dolt
Today's blog is about ACID transactions in Dolt, how we built them and what this means for Dolt users. Dolt first released SQL transactions 18 months ago. Since then we've continued to improve transactional performance in Dolt sql-server, but th...
Read More