- 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
- DATASET1 min read
April Dataset Spotlight
It's that time for our April 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 - WEB8 min read
Using Apollo Client to Manage GraphQL Data in our Next.js Application
DoltHub is a place on the internet to share, discover, and collaborate on Dolt databases. We have a series about how we built DoltHub, which goes deeper into our system and front-end architecture. If you're curious about our architecture or...
Read More - FEATURE RELEASESQL4 min read
Dolt Now Supports Check Constraints
Dolt is an SQL database with Git versioning. We have come a long way since initially committing to 100% MySQL compatibility, and today we introduce our latest step in that journey: check constraints. What Are Check Constraints? Check const...
Read More - BOUNTY3 min read
Hospital Price Transparency Bounty Revisited
Today, I’m thrilled to announce a second round of the Hospital Price Transparency Bounty . Our first pass was very elucidating; we learned a lot about the “shape” of the data and we’re excited to let our Discord lovelies take a second crack at it...
Read More - INTEGRATION11 min read
Data Version Control and Dolt Reproducibility
Introduction Dolt and DVC are often compared because of because of DVC's name, Data Version Control. Dolt also does "data version control". So what's the difference? Well, DVC is a version controlled machine learning workflow manager and Dolt...
Read More - FEATURE RELEASESQL5 min read
JSON Support in Dolt
Dolt is a tool built for collaboration and data distribution, it's Git for Data . Git versions files, Dolt versions tables. We've built Dolt to support the MySQL query dialect, with the goal of becoming a drop-in replacement for MySQL. Currentl...
Read More - INTEGRATION14 min read
Introducing Dolt + Metaflow
Note : this blog post appeared on previously on Medium and represents a collaboration with the Metaflow maintainers at Netflix. Background This post details how to use Metaflow with Dolt. Metaflow is a framework for defining data scien...
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