- 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
- 12 min read
Dolt Vs MySQL Vs Postgres
Dolt was originally designed as a standalone CLI tool for supporting distributed asynchronous data sharing with the same primitives as Git. But we are now a database company. We still support data sharing with Git semantics but increasingly in a clie...
Read More - 21 min read
So you want Slowly Changing Dimension?
Understand slowly changing dimension definitions, methods, and tools. Outlines the business benefits of using slowly changing dimension for database versioning. Introduces Dolt, the first SQL database with built in slowly changing dimension.
Read More - 10 min read
Automatic Dolt Commits with @@dolt_transaction_commit
The `@@dolt_transaction_commit` system variable turns all SQL commits into Dolt commits, enabling you to have a versioned history of your data without having to explicitly call dolt_commit().
Read More - 13 min read
Initializing Large Static Maps in Go
Runtime costs and strategies for static initialization in Go
Read More - 5 min read
Running a Production Database
The database is the heart of most applications. It's where the data that drives your web applications lives. It's where your users' data is stored. The data in your database may be used in countless ways such as analytics, machine learning, and repor...
Read More - 6 min read
The Future of the Dolt Command Line Interface
Dolt's Command Line Interface is being modernized to integrate better with our SQL Server. A little history, and a plan for the future.
Read More - 8 min read
MySQL Triggers: How and why with examples
In this tutorial, learn how to define triggers in MySQL and what they're good for, with examples
Read More - 3 min read
Better JSON Support
In case you haven't heard, we're now Dolt 1.0!. However, we're not finished. In this blog, we'll go over some recent improvements to Dolt's JSON handling. Additionally, I'll go through some examples of JSON handling to showcase the new functionality....
Read More - 5 min read
Announcing DoltLab v1.0.0, now backed by Dolt
In early May we announced Dolt v1.0.0, the first stable release of Dolt, signaling that Dolt is ready for production use. Shortly thereafter we revealed that DoltHub.com now runs on Dolt. In my previous blog post I explain how we transitioned DoltHub...
Read More - 8 min read
Replicating Unexpected Behavior
I'm an engineer at DoltHub, and for the past month, I've been working on matching Dolt's regular expression capabilities with MySQL. This is important for us, as Dolt is a drop-in replacement for MySQL, that gives you all the versioning features that...
Read More - 4 min read
Hosted DoltDB Launches Replicas
Dolt is Git for Data. It's a MySQL compatible database with Git-style versioning and branching built in. We launched Hosted Dolt a little over a year ago and since then we've released additional metrics, improved logs, created a sql workbench, added ...
Read More - 5 min read
Introducing Dolt Events
Dolt is a version-controlled relational database that supports MySQL features. Today, we are excited to announce that we are adding support for MySQL Events. These are tasks that run on a specific schedule, such as executing a query statement at a pa...
Read More - 10 min read
Writing and debugging integration tests of multiple processes with Golang
How to launch multiple Golang binaries from a test and attach your debugger to them
Read More - 5 min read
Community-built hospital price database hits 400 hospitals
Hospital price data is pretty damn tedious to collect. There thousands of different formats for these files, which by and large contain the same kind of data, just phrased differently. That makes it expensive to buy and time consuming to make. Our t...
Read More - 9 min read
C to WASM to Go
Sometimes, the most complicated solution may end up being the simplest. This sounds like a contradiction, but it depends on where a project's priorities lay. I'm an engineer here at DoltHub, and about 9 months ago I implemented collation support for...
Read More - 6 min read
Using DoltHub as a Remote for Hosted Dolt
We have two web products for Dolt: DoltHub and Hosted Dolt. DoltHub is GitHub for Dolt and Hosted is AWS RDS for Dolt. Each product has different use cases depending on your goals, but there are also reasons to use DoltHub and Hosted together. Easily...
Read More - 8 min read
Your config file should be a database
Struggling with a crippling addiction to YAML? You aren't alone. We can help.
Read More - 18 min read
DoltHub on Hosted Dolt
For the past few months at DoltHub, we've been really excited about the release of Dolt 1.0. If you missed it, it dropped last Friday May 5th. Dolt 1.0 is the first stable release of Dolt and guarantees forward storage compatibility, production grad...
Read More - 8 min read
Making Nautobot work with Dolt, again
Dolt is a MySQL-compatible database that allows branching, diffing, and merging database changes. In this blog post, we will discuss how Dolt is being used with a network automation solution called Nautobot and the recent fixes we've had to make at D...
Read More