- 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
- REFERENCE5 min read
Why a database of hospital prices doesn't exist yet
In 2021, a US executive order forced hospitals to publish all their insurance-negotiated rates in machine readable files. We think this data should be public, so we're crowdsourcing a single, fully open, MySQL-compatible database of it. You can tra...
Read More - REFERENCE6 min read
Dolt Architecture Introduction
Dolt is the world's first version controlled SQL database. How would you build a version controlled SQL database? This article will start with some of the high level requirements, explain some possible architecture options, and then explain the…...
Read More - FEATURE RELEASEHOSTED3 min read
Cloning a Hosted Database
Hosted DoltDB is for running online, production Dolt databases. Since we launched Hosted last year, we've been adding new features to offer a streamlined user experience and easy access to Dolt's powerful database and version control features....
Read More - GOLANGSQL5 min read
Keep Calm And Panic
Dolt is a SQL database with MySQL’s syntax and Git’s versioning semantics. Dolt is run as a service, and when things go wrong we prefer SQL errors to crashed servers. This was the basic premise behind Brian’s painstaking rewrite of Noms panics...
Read More - REFERENCE6 min read
Using SQLAlchemy for Dolt Time Travel
A customer was struggling with how to use standard ORM tools, like SQLAlchemy, to access Dolt time travel features across schema changes. One specific problem area is that combining app ORM/schema tools with Dolt time travel features has been...
Read More - FEATURE RELEASEREFERENCE7 min read
Accessing Dolt Data with the Postgres mysql_fdw
Dolt is a full featured SQL database which supports Git-like version control features, including branch, diff, merge, clone, push and pull. It's wire protocol and supported SQL dialect are based on MySQL. Here at DoltHub, it's not uncommon for o...
Read More - FEATURE RELEASE9 min read
Introducing dolt_column_diff
Dolt is a version controlled relational database that combines the version control features of Git and the relational database features of MySQL. One of the features that leverages the powerful versioned history Dolt tracks is our Database Hist...
Read More - TECHNICAL17 min read
Adding a GPT assistant to the Dolt CLI
ChatGPT is the talk of the town with the release of the immensely powerful GPT 4 model. Unless you've been living under a rock with no WiFi, you've certainly heard about it by now, and probably played with it yourself. Many people are excited, some...
Read More - FEATURE RELEASEHOSTED13 min read
Versioned MySQL Replicas on Hosted Dolt
Today we're showing how to use Hosted Dolt to run a versioned MySQL replica . Adding Dolt to your existing MySQL database as a replica is a great way to easily try out Dolt with your own data. As we'll see in the demo, the changes from MySQL f...
Read More - WEBFEATURE RELEASE2 min read
Introducing the Commit Graph on DoltHub: Visualizing Commit History
For those new to Dolt and DoltHub , Dolt is Git for data. Git versions files. Dolt versions SQL tables. DoltHub is a place on the internet to share Dolt databases. We're excited to announce the release of a new DoltHub feature: the commi...
Read More - USE CASEREFERENCE11 min read
Creating a Webapp with Hosted Dolt and AWS Amplify
In 2018 when we began building Dolt , we wanted to bring version control functionality to your datasets. We thought that the ability to branch and merge changes to data would allow for greater collaboration, resulting in higher quality data. Over...
Read More - GOLANG9 min read
SwissMap: A smaller, faster Golang Hash Table
Today's blog is announcing SwissMap , a new Golang hash table based on SwissTable that is faster and uses less memory than Golang's built-in map. We'll cover the motivation, design and implementation of this new package and give you some reaso...
Read More - TECHNICAL8 min read
Debugging Dolt's SQL Analyzer
I'm new to Dolt, both as a user and as an employee. Since I'm new here, I suppose I should introduce myself. I'm Neil 👋. You can look at my history on LinkedIn, but what matters is that I'd describe myself as developer obsessed. I've spent ...
Read More - FEATURE RELEASE6 min read
Introducing DOLT_PATCH()
Dolt is a version controlled relational database that is a combination of the version control features of Git and the relational database features of MySQL. Today, we announce another new feature, the DOLT_PATCH() table function . This featu...
Read More - SQL14 min read
Debugging Slow SQL Queries
Dolt is the only version controlled relational database. Like if MySQL and Git had a baby, this baby also inherited the trauma of both parents. Today we will be talking about the SQL half. Our users send us increasingly complicated queries in ne...
Read More - BOUNTY5 min read
Price transparency is broken
Last year I wrote about how much new health insurance data spilled onto the web ( petabytes ). It turned out that for practical purposes most of the rates could probably be discarded , with the usable fraction probably being less than 10%. Bu...
Read More - TECHNICAL4 min read
DoltHub goes to PyData NYC
Dolt is the world's first SQL database with Git-style version control. One of our more popular use cases is assembling large datasets with an army of volunteers, like with our medical pricing bounties . The same people who care about these larg...
Read More - HOSTED7 min read
Comparing DoltHub and the Hosted SQL Workbench
Dolt is a MySQL-compatible database with Git-like features. DoltHub is GitHub for Dolt. Hosted DoltDB is AWS RDS for Dolt. Both DoltHub and Hosted come with a UI to help visualize data and track changes, while also providing seamless ...
Read More - REFERENCE23 min read
Getting Started: Versioned MySQL Replica
We have new mode to run Dolt in! The Versioned MySQL Replica. In this mode, you set up Dolt to replicate a primary MySQL. Set up can take as as little as three commands. After set up, Dolt replicates every write to your primary to Dolt and cr...
Read More - GOLANG8 min read
Real World Golang Concurrency Examples
Here at DoltHub, we're big fans of Golang. We built DoltDB , the first fully versioned SQL relational database, entirely on a Golang stack, and we use Go for all the services that power DoltHub , too. This post is a continuation of our series o...
Read More