- 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
- 5 min read
Archiving Presidential Tweets Using Dolt
Background This is a guest blog post by a member of the DoltHub community, detailing how they went about accumulating presidential tweets in Dolt. We are grateful to our community members for showing us ways of using Dolt we didn’t think of, and als...
Read More - 5 min read
Introducing Dolt CLI in SQL
Dolt is Git for data, a SQL database with version control tooling. While Dolt is nearing full MySQL compatibility, its current command line interface (CLI) functionality hasn't been accessible in SQL. That means that you can't currently run operation...
Read More - 4 min read
Getting a Mascot for Dolt
Dolt is Git for Data. It's a SQL database that you can branch, merge, clone, fork, push and pull, just like files in Git. Today we're going to be talking about our quest to get Dolt's branding right, and our first attempt to find a mascot that reflec...
Read More - 5 min read
Database Performance: Dolt vs MySQL
Dolt is a version controlled SQL database. Dolt's query interface is SQL, and it has Git-like version control features. Adding version control features to a SQL database has performance trade offs when comparing Dolt with traditional databases like M...
Read More - 3 min read
November Dataset Spotlight
Every month we highlight some interesting datasets on DoltHub. The focus is on new or updated datasets but sometimes we shed fresh light on a classic. For those new to Dolt and DoltHub, Dolt is Git for data. Git versions files. Dolt versions SQL tab...
Read More - 5 min read
Filter-Branch in Dolt
Dolt is a tool built for collaboration and data distribution, a SQL database you can branch, merge, diff, clone, fork, push and pull. Today, we're announcing support for filter-branch in Dolt. "Customer focus" is a mantra for our company. In August,...
Read More - 12 min read
Continuous Deployment with Github Actions: An Example
Github Actions FTW Not too long ago we endeavored to migrate Dolt's continuous integration pipeline from Jenkins to Github Actions. I wrote a blog about that process and complimented Github Actions on making the migration process intuitive and easy....
Read More - 4 min read
Dolt Supports Prepared Statements
Dolt is a SQL database that supports Git-like functionality, including branch, merge, clone, push and pull. Dolt targets compatibility with MySQL as an existing SQL dialect and wire protocol. We built Dolt on top of an excellent open-source implement...
Read More - 6 min read
Version Controlled Databases: Defining a Category
"Database version control" and "version controlled database" are not the same thing. Version controlling your database refers to the practice of storing schema and schema modifications in a traditional source control system like Git. "Version control...
Read More - 6 min read
Don't Panic
When Tim, Aaron, and I started working on this problem in August 2018 we immediately began playing with Noms. It was an open source project that gave us a lot of the things Aaron and I had been talking about in order to deliver the features we felt w...
Read More - 5 min read
Uploading Files to DoltHub
Dolt is Git for data and DoltHub is our web application that houses Dolt repositories. A few weeks ago I wrote about merging pull requests on DoltHub and our roadmap for "edit on the web". We're working on reducing friction for collaborating on data ...
Read More - 6 min read
A REST Service for Versioning DataFrames
We originally built Dolt because we thought that existing data distribution formats were broken. In particular, we believed that consumers of data should not have to parse various formats (CSV, JSON, etc.), write ingestion logic and decide on update ...
Read More - 11 min read
Debunking an election fraud claim using open data and Dolt
After four years of incredibly rancorous discourse about whether the US President was illegitimately elected with the help of foreign interference, it should surprise no one that the 2020 presidential election is mired in similar claims of illegitima...
Read More - 4 min read
Supporting AUTO_INCREMENT
Dolt is a database built for collaboration and data distribution. It's "Git for Data," a SQL database you can branch, merge, diff, clone, fork, push and pull. We intend to become a fully MySQL compatible database. Today, we're announcing support for ...
Read More - 8 min read
Doltpy: Dolt in Python
Dolt is a SQL database with Git-like version control features. It presents a familiar SQL interface while exposing Git-like primitives for versioning tables and their data. Doltpy is a Python API for interacting with Dolt in Python. This post details...
Read More - 3 min read
October Dataset Spotlight
Every month we highlight some interesting datasets on DoltHub. The focus is on new or updated datasets but sometimes we shed fresh light on a classic. For those new to Dolt and DoltHub, Dolt is Git for data. Git versions files. Dolt versions SQL tab...
Read More - 10 min read
Pushing down filters to make queries faster
Dolt is Git for Data, a SQL database you can branch, merge, clone, fork, sync, push and pull. Today we're excited to announce the release of a new optimization in the query planner: pushing down filters! What's a pushdown? Pushdown is a query optim...
Read More - 8 min read
Asynchronous Sorting in Go
When we began working on Dolt we made the decision to build on top of Noms. Noms stores data in a content addressable DAG, and has countless applications. It was a great starting point for us to build Dolt, and it let us hit the ground running. Once ...
Read More - 6 min read
Testing Login using Cypress
We use Cypress to write integration tests against DoltHub in production. Learn how we set up tests that log in a user so that we can test against authenticated pages.
Read More - 5 min read
We are Hiring
Dolt is a SQL database with Git-style versioning. DoltHub is a place on the internet to share Dolt databases. It takes a strong technical team to build a database from the storage engine up even when you get head start from open source projects like...
Read More