- 11 min read
So you want an AI Database?
Here at DoltHub, we built the world's first version-controlled SQL database: Dolt. What do version control and databases have to do with Artificial Intelligence (AI)? It turns out, a lot. At first, we were skeptical about the AI revolution, but then...
Read More
- 6 min read
Introducing DOLT_PATCH()
Dolt is a version controlled relational database that is a combination of the version control features of Git and the relational database features of MySQL. Today, we announce another new feature, the DOLT_PATCH() table function. This feature's funct...
Read More - 13 min read
Debugging Slow SQL Queries
Dolt is the only version controlled relational database. Like if MySQL and Git had a baby, this baby also inherited the trauma of both parents. Today we will be talking about the SQL half. Our users send us increasingly complicated queries in need o...
Read More - 6 min read
Price transparency is broken
Last year I wrote about how much new health insurance data spilled onto the web (petabytes). It turned out that for practical purposes most of the rates could probably be discarded, with the usable fraction probably being less than 10%. But it looks...
Read More - 5 min read
DoltHub goes to PyData NYC
Dolt is the world's first SQL database with Git-style version control. One of our more popular use cases is assembling large datasets with an army of volunteers, like with our medical pricing bounties. The same people who care about these large datas...
Read More - 7 min read
Comparing DoltHub and the Hosted SQL Workbench
Dolt is a MySQL-compatible database with Git-like features. DoltHub is GitHub for Dolt. Hosted DoltDB is AWS RDS for Dolt. Both DoltHub and Hosted come with a UI to help visualize data and track changes, while also providing seamless collaboration am...
Read More - 18 min read
Getting Started: Versioned MySQL Replica
We have new mode to run Dolt in! The Versioned MySQL Replica. In this mode, you set up Dolt to replicate a primary MySQL. Set up can take as as little as three commands. After set up, Dolt replicates every write to your primary to Dolt and creates a...
Read More - 8 min read
Real World Golang Concurrency Examples
Here at DoltHub, we're big fans of Golang. We built DoltDB, the first fully versioned SQL relational database, entirely on a Golang stack, and we use Go for all the services that power DoltHub, too. This post is a continuation of our series on Golang...
Read More - 9 min read
Caching Gatsby builds with Docker in GitHub Actions
At DoltHub, we write a lot of blogs. Each week our team publishes three to four blogs on various topics. Some recent blogs include our ongoing effort to publish Hospital Price Data in a single, coherent database, the release of Dolt v0.75.0 which inc...
Read More - 5 min read
- 4 min read
Hospital data for all: Part I
I announced a few months ago that we were planning to make hospital prices accessible in a single, public, freely-accessible database, giving the public access to secret negotiations insurers have with hospitals. We’ll capture these rates in two par...
Read More - 10 min read
Dolt Supports Spatial Indexes
Dolt is a version controlled SQL database; think Git and MySQL had a baby. Just over a year ago, we began our spatial journey with the addition of Spatial Types. We closed that gap about three months ago when we announced the support of Multi-Geometr...
Read More - 9 min read
So you want Change Data Capture?
A survey of products offering Change Data Capture. This article will explain what Change Data Capture is, how it works, and why you would use it.
Read More - 3 min read
Hosted DoltDB on Google Cloud Platform
Dolt is a SQL database with Git-like features that allow for version control of data. Last year we launched Hosted DoltDB, a hosted platform for Dolt databases that offers a streamlined user experience and easy access to Dolt's powerful database and ...
Read More - 5 min read
Automate Your Database Workflow with the New DoltHub API
We are excited to announce the release of the new DoltHub API, designed to make it easier to manage and collaborate on databases programmatically. The DoltHub API offers a range of features that can help streamline your work and improve productivity....
Read More - 7 min read
Type embedding: Golang's fake inheritance
Last week a complaint from a gopher about his coworkers bringing Java conventions to a Golang codebase made a minor splash on Reddit. Their complaints: All context.Context are currently being stored as fields in structs. All sync.WaitGroups are bein...
Read More - 15 min read
Exploring NanoGPT
ChatGPT is all the rage. I asked ChatGPT if you could raise money if you haven't blogged about it and I did not agree with the response. Can't raise I may need to raise money again. So, here we go. I was inspired by a video posted by Andrej Karpat...
Read More - 8 min read
Dolt Binlog Replication Preview
Dolt Binlog Replication Preview Today, we are excited to announce Dolt's support for replicating from a MySQL binlog! This initial support allows a Dolt sql-server to configure a MySQL or MariaDB instance as its replication source, connect to it, an...
Read More - 5 min read
Open source lab test pricing data, and why prices vary so much
Hospital lab tests are commodities: a test is a test is a test. So how can end up with a $8,500 mole biopsy or a $28,000 strep throat cell culture? Many investigations raise this question but stop short of answering it. We dug into this question a l...
Read More - 9 min read
Dolt + Looker Studio
A couple weeks ago I wrote about how to use Dolt with Apache Superset. Dolt provides powerful versioning features to Superset charts and dashboards. Dolt "just works" with Superset using the MySQL connector so it's really easy to get started. The pow...
Read More - 7 min read
MySQL Information Schema Compatibility
Dolt is a version controlled MySQL-compatible database, written from the ground up in Go. We're always working to close the remaining gap on full compatibility with MySQL. In this blog post, we're talking about the work we've done to make Dolt compat...
Read More