- 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
- SQL9 min read
Dolt Diff Magic: Part 3 – Diffing tables at two revisions
Welcome back to the third post in this series exploring the tricks you can do with Dolt's magical versioning features! 🪄 In the first post of this series , we explored how the dolt_diff system table enables you to see what tables have chan...
Read More - VIDEO1 min read
Dolt: The Database for Dummies
Dolt is the database for dummies Our CEO, Tim Sehn, recently wrote a blog about why Dolt is the database for dummies . In this video, we show off the features that make working with a Dolt database foolproof. You get copy/paste, undo, an...
Read More - 5 min read
This Tech Blog is an Ad
This is an ad. It was written by an employee of the company that owns this domain, and is an attempt to sell you a product. You clicked on it out of curiosity because the title was interesting and promised technical content that is relevant to you…...
Read More - 5 min read
Dolt: The Database for Dummies
Why name a product Dolt? We get asked all the time . It's named dolt to pay homage to how Linus Torvalds named git : Torvalds sarcastically quipped about the name git (which means "unpleasant person" in British English slang): "I'm ...
Read More - DOLTLAB4 min read
Monitoring a DoltLab instance with Prometheus
Hello DoltLabbers! Today's blog will be a quick-start guide, showing you how to monitor your DoltLab instance with Prometheus . We recently released DoltLab v0.4.2 that adds support for DoltLab users requiring implicit TLS connections ...
Read More - BOUNTY10 min read
Why nonprofit hospitals can be so damn expensive
One of the most expensive hospitals in America may actually be a nonprofit. Insurers pay the hospital, Mary Lanning Healthcare in Nebraska, an average of $200,000 for a particular neurosurgery. However, drive less than hour West to Kearney Regional...
Read More - WEB9 min read
Migrating a React app to the new Google Sign-In library
Google announced last year that they will be discontinuing their Google Sign-In Javascript Platform Library for the web. It will be replaced with Google Identity Services , their new family of Identity APIs that consolidate multiple identit...
Read More - 10 min read
How to get more than 2TB of Disk on AWS EC2 Ubuntu 20.04
Today's blog is a quick how-to guide aimed at helping others provision and actually use more than 2TBs of disk on an AWS EC2 Ubuntu 20.04. I never planned on writing this blog, but experiencing the surprisingly clunky and cryptic process c...
Read More - VIDEO1 min read
Using dolt revert to recover from operational errors
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. Being natively version controlled means Dolt ca...
Read More - SQL3 min read
SELECT Isn't Sensible
In my last blog post , I went over how we initially implemented foreign keys on our database— Dolt , which fuses a fully MySQL-compatible database with Git-style versioning capabilities—and how our first decision resulted in a complete rewrite o...
Read More - REFERENCE5 min read
So you want Data Version Control?
There is one name in the data version control space I'm truly jealous of: DVC , short for "Data Version Control". Data version control is only a small part of what DVC does. DVC is a tool to version code and data in machine learning pipelines. ...
Read More - TECHNICAL5 min read
Mitigating the variability of third party services like S3
Everyone has that favorite route that they use to drive to work. You’ve driven the route over and over and learn to trust and rely on it over time. You know exactly how long your drive is going to take and when you need to leave the house. So you…
Read More - BOUNTY2 min read
US Hospital Price Transparency Bounty Retrospective
US Hospital Price Transparency Bounty Retrospective A year ago we launched DoltHub data bounties . If you're unfamiliar, we use Dolt to create open databases that don't exist anywhere else on the internet. We use Dolt's data lineage capa...
Read More - SQLFEATURE RELEASE4 min read
Dolt Supports Cached Prepared Statements
Last year we announced prepared statement support , a simple form of query parameterization. True prepared statements save plans to be executed later, often multiple times. But the original work only progressed as far as satisfying the handler AP...
Read More - BOUNTY3 min read
$10,000 Jails and Prisons Data Bounty
What are data bounties? DoltHub data bounties are our way of getting people to use Dolt: in each bounty, we build meaningful datasets together using Git-style pull requests. If you haven't participated in a bounty already, why not start now...
Read More - SQL4 min read
The Foreign Key Eviction
When building a database, there are many decisions to be made regarding its implementation. Our database is Dolt , which is a SQL database with Git-style versioning. We're modeling our SQL implementation on MySQL, so much so that we're a drop-in…...
Read More - USE CASE7 min read
A Really Bad Day at Atlassian
A couple weeks ago, somebody at Atlassian had a really bad day. Seems like they didn't realize it at the time, but their customers noticed pretty quickly. Can we just talk about Atlassian services being down? 🤔 What happened there? It's not a ...
Read More - BOUNTY7 min read
Where is dynamite hidden in the US housing market?
I'm currently staring at what I think might be the biggest open database of housing sales records ever . It's 50GB of uncut housing sales records straight from the government coffers. Tens of millions of them. Good chance to dig around and play w...
Read More - SQL7 min read
Dolt Diff Magic: Part 2 – Viewing data diffs
Welcome back to the second post in this blog series exploring the magic that makes Dolt so unique and powerful. Dolt DB is a MySQL-compliant SQL database that also provides the distributed versioning features of Git. The result is a powerful dat...
Read More - WEBFEATURE RELEASE1 min read
Your Database Can Now Be Downloaded As CSVs
For those new to Dolt and DoltHub , Dolt is Git for data. Git versions files. Dolt versions SQL tables. DoltHub is a place on the internet to share Dolt databases. Recently we received a feature request from one of our customers asking u...
Read More