- 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
- SQL7 min read
TPC-C Update 2024
Dolt reached production quality as a relational database about a year ago. We started more seriously testing Dolt against TPC-C beforehand in anticipation of more contentious transactional workloads. Dolt aims to be around 2-3x compared to MySQL on...
Read More - REFERENCE5 min read
Dolt's Commit Graph
A deep dive into the Dolt commit graph, the data structure that powers the version control capability of Dolt.
Read More - REFERENCE11 min read
Prolly Trees
A deep dive into the Probabilistic B-tree or Prolly Tree data structure including examples. Prolly Trees are used to create version controlled databases.
Read More - REFERENCE5 min read
Dolt's Storage Engine
A detailed deep dive into Dolt's storage engine. Dolt's storage engine provides database version control at scale using Prolly Tress and a commit graph.
Read More - INTEGRATION21 min read
ASP.NET Core + Dolt
This post shows how to build an ASP.NET Core web application using Razor Pages and Entity Framework Core with Dolt as the database, including how to access Dolt specific versioning features such as branching, commit logs, and data diffs.
Read More - SQL5 min read
100% Correctness
Dolt is a SQL database with Git-like versioning features intended to be a drop-in replacement for MySQL. In order to be a drop-in replacement, Dolt needs to match MySQL behavior as closely as possible. We chose sqllogictests , a collection of ...
Read More - GOLANG2 min read
- FEATURE RELEASE10 min read
- 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 now supports more advanced replication workflows from the web UI, such as resizing your deployment, upgrading to a larger instance, and restarting a stopped deployment.
Read More - REFERENCE18 min read
Getting Started: Rails and Dolt
A detailed guide, complete with sample code, on how to get started writing a version controlled Rails app using a Dolt database.
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
In this blog we try out Go's new profile-guided build optimizations on Dolt's SQL benchmarks and share the results
Read More - REFERENCE21 min read
Getting Started: Django and Dolt
A detailed guide, complete with sample code, on how to get started writing a version controlled Django app using a Dolt database.
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
In this tutorial, learn how to define views in MySQL and what they're good for, with examples
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