- 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
- FEATURE RELEASE10 min read
Shallow Clone Support
Dolt is the first version controlled SQL database, and the natural consequence of that is it needs to store every value of every row that has ever existed in your database. Git is similar, and it turns out that st...
Read More - 2 min read
Announcing Dolt PGO Builds
In a recent blog post Zach demonstrated that building Dolt using Golang's Profile-Guided Optimization (PGO) improved benchmarking performance by 5%. Today we're excited to announce that Dolt releases, starting with v1.32.4 , are now buil...
Read More - SQL5 min read
Automatic Statistic Updates
Dolt is close to 100% MySQL compatible and only 2x slower than MySQL. Few customers find bugs that we cannot fix in under 24 hours, and the difference between a 10ms query in Dolt that is 5ms in MySQL is usually OK. But on rare occasions we still…
Read More - TECHNICALDOLTGRES8 min read
Adding Types to DoltgreSQL
In November 2023 , we officially started development on DoltgreSQL , which is a version of Dolt built to be a drop-in replacement for PostgreSQL. For those that may not know, Dolt is the world's first database that is built, from the grou...
Read More - HOSTEDFEATURE RELEASE2 min read
Upgrading Instances on Hosted Dolt
Hosted Dolt is for running online, production Dolt databases. Last year we added support for read replicas . You can choose up to 8 read replicas and every write to the primary server is replicated to the read replicas. Since then, we've inc...
Read More - REFERENCE18 min read
Getting Started: Rails and Dolt
We're on a mission to show that Dolt , the world's first version controlled SQL database , works with all your favorite tools in all your favorite languages . Today we head to Ruby -land and show you how to integrate Dolt with Rails , a p...
Read More - 8 min read
Understanding Tags in Go
In Go, tags allow developers to attach metadata to struct fields. These tags can drive features and behaviors in various libraries and tools which access the tags via reflection. This article provides an overview of tags in Go, including their synt...
Read More - 16 min read
Testcontainers for Go with Dolt
Recently, a customer reached out to our team asking for a blog using Dolt with Testcontainers , "an open source framework for providing throwaway, lightweight instances of databases, message brokers, web browsers, or just about anything that c...
Read More - GOLANG14 min read
Testing out Profile-Guided Optimization on Dolt's SQL Benchmarks
Introduction We're building Dolt , the world's first version-controlled SQL database. We measure Dolt's performance with sysbench , an industry standard set of SQL benchmarks that you can use to get an apples-to-apples performance compari...
Read More - REFERENCE21 min read
Getting Started: Django and Dolt
We're on a mission to show that Dolt , the world's first version controlled database , works with all your favorite tools in all your favorite languages . Today we head back to Python -land and show you how to integrate Dolt with Django ,...
Read More - SQL3 min read
Improvements to SQL Function Support
Dolt is a versioned database that has a mix of Git and MySQL features. One of our goals is to be a drop-in replacement for MySQL. As a result, we need to support all the functions MySQL does; these are things like SIN() , CONCAT() , CURRENT_T...
Read More - 11 min read
MySQL Views: How and why with examples
MySQL allows you to define views on your databases that let you write complex queries you can select from just like they were tables. This tutorial will teach you how to use views and give you some ideas about what they're good for. What...
Read More - USE CASEREFERENCE5 min read
Dolt + Metabase
A customer wanted to use Metabase to visualize Dolt databases. Dolt provides powerful versioning features to Metabase charts and dashboards. Dolt "just works" with Metabase using the MySQL connector so it's really easy to get started. T...
Read More - SQL7 min read
Join Statistics
Dolt is the first relational database with history independent version control. Dolt's Git-like commit graph captures snapshots in a format that efficiently diffs and merges tables and schemas. We recently added index scan costing to Dolt's S...
Read More - 7 min read
Structural Sharing with Schema Changes
Dolt is a MySQL-compatible database that supports Git-like version control features, including commit, diff, branch, merge, clone, push and pull. In order to make these operations efficient, it stores databases in a Merkle DAG, within which table...
Read More - 14 min read
MySQL Stored Procedures: How and why with examples
MySQL allows you to define stored procedures on your databases that can execute arbitrary SQL statements whenever you invoke them, including updating data in one or more tables. This tutorial will teach you how to use stored procedures and giv...
Read More - FEATURE RELEASE3 min read
Announcing automatic merging of JSON changes
Here's something that's true: Dolt makes it easy to collaborate and merge independent changes to your SQL database. Here's something else that's true: People really like JSON. It's flexible, human readable, and there's lots of existing tools ...
Read More - GOLANG9 min read
Coming Soon: Golang 1.22 🚀
At DoltHub , we love Go! We're using Go to build DoltDB , an open-source SQL database engine with Git-like distributed version control. Dolt lets you branch, fork, merge, and diff your relational tables, just like Git does for your source code ...
Read More - TECHNICAL13 min read
Writing a version-controlled application
Introduction We're building Dolt , the world's first version controlled SQL database . Our customers are using Dolt in a bunch of different ways , but by far the most common one is to write a version-controlled application. What is a...
Read More - REFERENCE16 min read
Getting Started: Laravel and Dolt
We're on a mission to show that Dolt works with all your favorite tools in all your favorite languages . Today we head to PHP -land and show you how to integrate Dolt with Laravel , a popular website builder with a built in ORM. ...
Read More