- REFERENCE11 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 versi...
Read More
- 6 min read
Transforming postgres dumps to MySQL dumps
Introduction We are building Dolt, the only SQL database that you can branch and merge, fork and clone, push and pull like a Git repository. For Dolt's SQL interface, we chose to implement the MySQL dialect and wire protocol, simply because MySQL is...
Read More - BOUNTYWEBVIDEO1 min read
Making your first pull request
Participating in our bounties is easier than ever With DoltHub's graphical tools it's easier than ever to contribute to one of our online databases. We've put out a new video that shows you how to do it, step-by-step. Are you interested in particip...
Read More - FEATURE RELEASEDOLTLAB10 min read
Announcing DoltLab: Your Self-Hosted DoltHub Solution
In recent months, we've had a number of customers reach out to us in Discord telling us they're interested in exploring Dolt for their company, but feel uncomfortable pushing their company's private data to DoltHub. More often than not, these conver...
Read More - VIDEO1 min read
The Challenge of Building a Database
Why Would You Build a New Database? Building a database is a notoriously hard problem. MySQL and other traditional databases have a reputation for being solid, functional, and historically well-performing. So why build a new one? Databases haven’t s...
Read More - WEBFEATURE RELEASE6 min read
Announcing Write Queries for DoltHub's SQL API
DoltHub is a place on the internet to share, discover, and collaborate on Dolt databases. It's been our goal to add more features to make it easy to add and edit data on DoltHub. As a part of this roadmap, we're excited to announce our previously rea...
Read More - VIDEO1 min read
Dolt in Docker Tutorial
Dolt in Docker Tutorial Docker is a container runtime environment that some developers use to standardize dependency management. A "Dockerized" app has three lifecycle stages: Dockerfile: static dependency definitions. Docker image: a packaged ex...
Read More - BOUNTY3 min read
SHAQ Bounty Retrospective
Dolt is the world's first version controlled database. DoltHub is the place on the internet to share Dolt databases. About a year ago, we launched data bounties. Data bounties use Dolt's cell lineage features to pay people for their contributions to...
Read More - BOUNTY3 min read
$10,000 US Housing Prices Bounty
We just finished SHAQ, one of our most competitive bounties ever. And off the heels of that, comes an even more ambitious project: tracking the US housing market. Every. Single. Sale. Let's track housing sales across the US After a lull in 2009, ho...
Read More - WEB5 min read
Conditional Testing with Cypress
Dolt is Git for data and DoltHub is our web application that houses Dolt databases. We use Cypress.io as our end-to-end testing solution for DoltHub. To learn more about our journey with Cypress, check out our previous blogs: Why we chose Cypress, s...
Read More - VIDEO1 min read
Using the Dolt command line in SQL
Introduction Dolt is git for data, the world's only SQL database that you can branch and merge, clone and fork, push and pull just like a git repository. It's like Git and MySQL had a baby. To make dolt familiar, we gave it the same command line in...
Read More - VIDEO1 min read
The Database that Stole Christmas
A Prolly-Tree for Christmas Scary, we know. A few days before Christmas even. Who doesn’t love a scary story, though? Tim shares a story from his career of a database error that Dolt could have prevented or debugged much quicker. Dolt is designed to...
Read More - VIDEO1 min read
Doltpy Self-Guided Tutorial
Doltpy Tutorial Doltpy is a library that makes it easier to execute Dolt commands in a Python environment. These features include: Convert Python functions to equivalent Dolt CLI shell commands. Transform and format data between Python types, lik...
Read More - REFERENCE6 min read
So you want Git SQL?
Dolt is like Git and MySQL had a baby. Learn about the different tools to version SQL queries and databases in a Git manner. Dolt is a SQL database that you can clone, branch, merge, diff, and log just like a Git repository.
Read More - USE CASE10 min read
A transaction that lasts for months
The bad old days of software development If you're under 40, you've probably heard tell of a time, way far back in the mists of ancient history, when software developers didn't commonly use source control. And I don't mean that they didn't use git, ...
Read More - VIDEO1 min read
The History of DoltHub
Let's Build a Database Everyone loves a good origin story. In this video, our CEO Tim Sehn tells you DoltHub's story from Day 1. You'll learn why we called the company Dolt, our first product, and where we see Dolt going in the future as an OLTP dat...
Read More - WEBTECHNICAL8 min read
Using client-side storage in our React application
DoltHub is a web-based UI built in React to share, discover, and collaborate on Dolt databases. We've recently been adding more features to make it easier to add and change data in your Dolt database on the web. One of these features is file upload, ...
Read More - VIDEO1 min read
How to Alter Schema on DoltHub
DoltHub makes Schema Changes Easy This video will you show how to add columns to your Dolt database. It will also walk you through how to drop and add primary keys. This is all done online at Dolthub.com. We have more DoltHub How To videos available...
Read More - SQLTECHNICALGOLANG5 min read
Optimizing A 60 Hour IN Expression
A customer recently experienced performance issues with a query similar to this: SELECT a.*, b.x, c.y from c INNER JOIN b ON b.id = c.id INNER JOIN a ON a.id = c.id WHERE a.x in {str_iterable_tosql_list(ids)} The performance culprit and focus...
Read More - BOUNTY6 min read
Merging SHAQ Players for Fun and Profit
Dolt is a version controlled database. Dolt uses the Git-model of source control and applies it to the data and schema of a SQL database. That makes Dolt the first and only SQL database you can branch and merge. We also built DoltHub, a place on the ...
Read More - VIDEO1 min read
It's Time To Set Your Senior Engineer Free
Make your Senior Engineers More Productive with Dolt Operating on your database is a high risk because your application or even your whole company could go down. It only makes sense that senior engineers or experienced database administrators make c...
Read More







