- 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
- INTEGRATION2 min read
Making Dolt Compatible With SQL Editors
Dolt is a SQL database with Git-style versioning. We've been working hard to make Dolt fully compatible with MySQL. An important test for compatibility is support for MySQL editors. These editors provide user interfaces for you to inspect data...
Read More - 2 min read
Dolt Ditched the Contributor License Agreement
Dolt is an open source database that supports Git-style versioning. DoltHub is a place on the internet to share Dolt databases. Dolt is collectively our team's first major open source endeavor. We're learning as we go. We recently ditched our…...
Read More - DATASET1 min read
March Dataset Spotlight
It's that time. Our March 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 Bount...
Read More - 2 min read
Private Repositories are Free
Dolt is a SQL database with Git-style versioning. DoltHub is Dolt's GitHub . A few weeks ago, we made private repositories free up to 1GB and announced it on Twitter. This blog explains why we made pr...
Read More - 5 min read
Data Bounties and Open Data
"Open Data" is quickly attaining the hype and ambiguity of previous tech crazes like "Big Data" and "Block Chain". The motivation behind Open Data is easy to understand: data is one of the most valuable but closely guarded resources in the tech…...
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