- 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
- SQL3 min read
Everything through the SQL Engine
Introduction Originally, Dolt was a CLI tool focused on data sharing and collaboration. As a CLI tool, Dolt exposed commands that allowed users to import, commit, branch, and merge data. About 1.5 years ago our company decided to focus on bui...
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...
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 becaus...
Read More - FEATURE RELEASEDOLTLAB9 min read
Announcing DoltLab: Your Self-Hosted DoltHub Solution
Download the latest DoltLab here and head over to https://docs.doltlab.com for the latest documentation 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 ...
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...
Read More - WEBFEATURE RELEASE7 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 prev...
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. D...
Read More - BOUNTY1 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 c...
Read More - BOUNTY2 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...
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 ...
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 comm...
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 d...
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 b...
Read More - REFERENCE4 min read
So you want Git SQL?
What does a mash up of Git and SQL look like? We built Dolt , a SQL database you can branch and merge like a Git repository. Is there a bit of a Git SQL movement forming? There are other Git + SQL mash ups being built that we find interesting. If...
Read More - USE CASE9 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 us...
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 a...
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 ...
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...
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 ...
Read More - BOUNTY5 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 pla...
Read More