- 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 RELEASESQL8 min read
Common Table Expressions (WITH)
Introduction Dolt is Git for data. It's a SQL database that you can clone, fork, branch, merge, push and pull like a Git repository. We're committed to supporting 100% of the functionality offered by Git and 100% of the functionality offere...
Read More - PYTHONINTEGRATION6 min read
Dolt with Popular DataFrame Tools
Dolt is a version-controlled SQL database. For data science (DS) workflows, specifically, Dolt uses data versioning primitives to implement unique flavors of reproducibility. DataFrames are a common interface for exploring CSV, Parquet and other...
Read More - BOUNTY4 min read
Assembling a Grand Catalog—A Data Bounty Retrospective
Should you use DoltHub Bounties for your data-wrangling needs? Our bounty partners wanted to assemble a “master” catalog of all the college courses taught in the United States. For them, it was an easy riddle. To recap, a partner approached u...
Read More - SQL6 min read
Recent Improvements to Join Planning in Dolt
Dolt is a SQL database that supports Git-like features, including branch, diff, merge, clone, push and pull. Dolt's SQL functionality is built on top of a SQL engine written in Golang . We've previously blogged about our first steps in optimi...
Read More - REFERENCE9 min read
Merging and Resolving Conflicts Programmatically with SQL
In the first part of this two part blog we covered concurrent connection handling within dolt sql-server . We learned about session state, how to commit changes, and how to persist those changes across sessions. Today we'll talk about the expl...
Read More - REFERENCE16 min read
dolt sql-server Concurrency
Update 2021-08-02 : Dolt now supports SQL transactions with COMMIT , ROLLBACK , SAVEPOINT and the other MySQL transaction primitives, so it's now safe to run the SQL server out of the box with multiple readers and writers. The techniques de...
Read More - BOUNTY1 min read
Introducing the Logo-2k+Extended $10k Data Bounty
Today, we’re launching our 4th bounty. Our previous three on the Presidential Election , Hospital Pricing , and College Course Catalogs have been eminent successes, if I do say so myself. Bounties are a really great way to assemble open d...
Read More - SQLFEATURE RELEASE4 min read
Introducing Stored Procedures
Dolt is a SQL database with Git-style versioning. With each new version of Dolt , we increase the number of supported SQL features, moving toward our goal of being a complete drop-in replacement for MySQL, while adding all of the versioning fea...
Read More - USE CASE9 min read
Dolt Use Cases in the Wild
About a year ago, we wrote a blog post about how we thought people might use Dolt, the SQL database you can fork, clone, branch, merge, push and pull just like a git repository. At the time we wrote it, we didn't have any paying customers, and w...
Read More - FEATURE RELEASEWEB3 min read
Edit Dolt on the Web Using SQL
DoltHub is a place on the internet to share, discover, and collaborate on Dolt databases. Last week we released a new feature on our edit on the web roadmap : edit data using the SQL Console. About a year ago when we released SQL querie...
Read More - BOUNTY2 min read
Hospital Price Transparency Bounty Review
We finished our second data bounty Monday, March 1. The target of the bounty was hospital prices . The results surpassed our expectations. We built a database of 1,400 of approximately 6,000 US hospital's chargemasters, representing over 72.7M...
Read More - DATASET2 min read
February Dataset Spotlight
It's that time. Our February dataset spotlight here at DoltHub . For new folks, Dolt is a SQL database with git-like versioning and DoltHub is a place on the internet to share Dolt databases. This monthly feature keeps you updated on Data Bo...
Read More - SQLREFERENCE7 min read
Implementing window functions in go-mysql-server
Dolt is Git for Data, the first SQL database you can clone, fork, branch and merge. Its SQL engine is go-mysql-server . Our goal is to be a 100% compatible, drop-in replacement for MySQL, but we have a ways to go. Today we're excited to announc...
Read More - BOUNTY6 min read
OpenElections Follow Up
As some of you are aware, we finished our first data bounty on Feb. 14 to collect US Presidential Precinct results for 2016 and 2020 . On Feb. 15, we published a bounty review . The bounty review gained some distribution on HackerNews aft...
Read More - BOUNTY2 min read
National Course Catalog $10,000 Database Bounty
It's time for another data bounty ! We completed the US Presidential Election Precinct Results bounty and we have a week or so left in the Hospital Price Transparency bounty . For the next bounty, we want to build a database of US Colle...
Read More - PYTHON2 min read
Mypy and Doltpy
Dolt Dolt is an SQL-database with Git-versioning. The goal of Doltpy , in concert with Dolt , is to solve reproducibility and versioning problems for data and machine learning engineers using Python. Mypy Mypy was created by Guid...
Read More - SQL3 min read
Dolt CLI in SQL - Update
Dolt is a SQL database with Git-style versioning. In a previous post we discussed the need to introduce Dolt CLI functions in SQL. We believe that version control is something that can be native to your SQL workflow. This allows for possibilit...
Read More - BOUNTY2 min read
US Presidential Election $25,000 Database Bounty Review
On December 14, we launched our first data bounty to earn a share of $25,000 by wrangling US Presidential Precinct-level data . The bounty ended yesterday. How did it go? This blog entry will answer that question. Dolt is a SQL database w...
Read More - PYTHON7 min read
Doltpy 2.0
Background Earlier in the week we talked about Dolt's "API surface area." To recap, Dolt is a relational database with version control features. Dolt has a SQL query interface implementing the MySQL dialect, as well as a command line inter...
Read More - FEATURE RELEASESQL6 min read
Introducing Type Changes
Dolt is a SQL database with Git-style versioning. With each new version of Dolt , we increase the number of supported SQL features, moving toward our goal of being a complete drop-in replacement for MySQL, while adding all of the versioning fe...
Read More