- 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
- 10 min read
Getting Started: Hosted Dolt
There are a bunch of ways to get started with Dolt, the word's first and only version controlled database. You can run Dolt locally as a version controlled database or as Git for Data. You can start using Dolt by sharing data on DoltHub or participa...
Read More - 4 min read
Using dolt_ignore to Prevent Accidents
An introduction to using the dolt_ignore configuration table to prevent staging tables that ought not to be staged.
Read More - 7 min read
Three-Way Merges in Dolt: Modeling Schema Conflicts
Initial release of the dolt_schema_conflicts table.
Read More - 5 min read
Connecting to a Database With Branches
Considerations, and recommendations for connecting to a database with branches
Read More - 10 min read
- 5 min read
Rename our Database
Rename our database! MulletDB? DataRebase? OurSQL? MarxDB? Choose your fighter.
Read More - 5 min read
Why a database of hospital prices doesn't exist yet
In 2021, a US executive order forced hospitals to publish all their insurance-negotiated rates in machine readable files. We think this data should be public, so we're crowdsourcing a single, fully open, MySQL-compatible database of it. You can track...
Read More - 7 min read
Dolt Architecture Introduction
Dolt is the world's first version controlled SQL database. How would you build a version controlled SQL database? This article will start with some of the high level requirements, explain some possible architecture options, and then explain the actu...
Read More - 4 min read
Cloning a Hosted Database
Hosted DoltDB is for running online, production Dolt databases. Since we launched Hosted last year, we've been adding new features to offer a streamlined user experience and easy access to Dolt's powerful database and version control features. Our la...
Read More - 5 min read
Keep Calm And Panic
Dolt is a SQL database with MySQL’s syntax and Git’s versioning semantics. Dolt is run as a service, and when things go wrong we prefer SQL errors to crashed servers. This was the basic premise behind Brian’s painstaking rewrite of Noms panics a few...
Read More - 6 min read
Using SQLAlchemy for Dolt Time Travel
A customer was struggling with how to use standard ORM tools, like SQLAlchemy, to access Dolt time travel features across schema changes. One specific problem area is that combining app ORM/schema tools with Dolt time travel features has been very p...
Read More - 7 min read
Accessing Dolt Data with the Postgres mysql_fdw
Dolt is a full featured SQL database which supports Git-like version control features, including branch, diff, merge, clone, push and pull. It's wire protocol and supported SQL dialect are based on MySQL. Here at DoltHub, it's not uncommon for our u...
Read More - 6 min read
Introducing dolt_column_diff
Dolt is a version controlled relational database that combines the version control features of Git and the relational database features of MySQL. One of the features that leverages the powerful versioned history Dolt tracks is our Database History Sy...
Read More - 17 min read
Adding a GPT assistant to the Dolt CLI
Tips and tricks for getting ChatGPT assistance integrated into your favorite command line tool
Read More - 12 min read
Versioned MySQL Replicas on Hosted Dolt
Today we're showing how to use Hosted Dolt to run a versioned MySQL replica. Adding Dolt to your existing MySQL database as a replica is a great way to easily try out Dolt with your own data. As we'll see in the demo, the changes from MySQL flow thro...
Read More - 3 min read
Introducing the Commit Graph on DoltHub: Visualizing Commit History
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. We're excited to announce the release of a new DoltHub feature: the commit graph. With...
Read More - 11 min read
Creating a Webapp with Hosted Dolt and AWS Amplify
How to create a webapp with Hosted Dolt and AWS Amplify
Read More - 10 min read
SwissMap: A smaller, faster Golang Hash Table
Initial release of SwissMap, a Golang port of Abseil's flat_hash_map.
Read More - 9 min read