- 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
- DOLTGRESTECHNICAL6 min read
Automatically translating MySQL statements into Postgres statements
Introduction We're hard at work building Doltgres , a Postgres-compatible database with git-inspired version control features. Doltgres is currently in alpha release, meaning lots of functionality doesn't work yet. We're committed to a be...
Read More - REFERENCE5 min read
QLDB Deprecated. Looking for an Alternative Immutable Database?
Recently, AWS announced they were no longer accepting new Quantum Ledger Database (QLDB) users and the service would be deprecated in July 2025. What are you supposed to do if you are a QLDB user? AWS recommends migr...
Read More - FEATURE RELEASEHOSTED8 min read
Announcing Hosted MySQL with Dolt Replica
We are excited to announce that Hosted Dolt now supports creating clusters with a MySQL primary and a Dolt replica. This feature allows you to create a MySQL server that is replicated to a Dolt database. In this blog I'll walk you through how...
Read More - INTEGRATION12 min read
Using python-mysql-replication with Dolt
Dolt is the world's first version controlled SQL database – you can branch/diff/fork/merge/rebase your data, in all the same ways that Git lets you work with source code files. Thanks to Dolt's custom storage engine , these operations to compu...
Read More - WEB7 min read
Drawing a commit graph
In a previous blog , we announced the release of the DoltHub commit graph and briefly discussed its implementation. Since then, we have written and adopted our own commit graph npm package. This blog will walk you through the key aspects and…
Read More - DOLTGRES4 min read
When will Doltgres go Beta?
Doltgres , the Postgres-flavored version of Dolt, the world's first and only version controlled SQL database , was released in Alpha in November 2023 . A Postgres-flavored version was our top customer ask . Demand doesn't seem to have waned ...
Read More - SQL3 min read
Correctness Update
Welcome to another edition of Dolt's monthly correctness updates! If you missed it, here's last month's update . This month, we resolved customer issues with ORMs, tackled older date and time bugs, and dealt with a long standing auto increment is...
Read More - REFERENCE6 min read
Standard Dolt Deployments
Here at DoltHub, we ship a number of products . Dolt is an Online Transaction Processing (OLTP) database with Git-style version control, like Git and MySQL had a baby. DoltHub is Dolt's GitHub, an online collaboration platform for Dolt data...
Read More - DOLTLAB18 min read
DoltLab: a history of features
Earlier this week we released DoltLab v2.3.0 . This release signifies the end of our months-long endeavor to make the first-time DoltLab user experience as simple and straightforward as possible. In this release, we've removed TLS configuration i...
Read More - FEATURE RELEASE4 min read
Introducing the `dolt archive` command
Here at Dolt, the first database to provide version control features like Git, we've been lucky to leverage existing code extensively while building our product. One piece we leveraged very heavily was Noms , and for the purposes of our discussio...
Read More - DOLTGRES5 min read
Re-introducing Dolt Functions in Doltgres
Introduction We're hard at work building Doltgres , a Postgres-compatible database with git-inspired version control features. Before we built Doltgres we built Dolt , which is MySQL-compatible instead. But there are many differences b...
Read More - SQL4 min read
New KV Execution Engine
This year, Dolt started passing every test in the sqllogictest suite . Correctness is crucial for reliability, but also lets us confidently reengineer the SQL engine for performance. One of the ways we are making query execution faster is c...
Read More - HOSTED4 min read
Hosted Dolt Private Deployments
Over two years ago, we launched our first hosted offering for Dolt. Since then, we have added features like the SQL workbench , support for Google Cloud and Single-sign on support with SAML . Up until now, our hosted offerings have all be...
Read More - REFERENCE5 min read
The Dolt Timeline
One of the major themes here at DoltHub for the next year or so is trust. We built Dolt , the world's first version controlled SQL database. We know innovating at the database layer of your stack requires complete trust in the new technology y...
Read More - GOLANG9 min read
What's the best Static Analysis tool for Golang?
If you've spent enough time writing in Golang, you've probably written code like this by accident: // FinalizeSomeWork returns an error on failure, and nil on success. func ( c * Connection ) FinalizeSomeWork ( ) error { ...
Read More - TECHNICAL7 min read
What Should Happen when there is a Schema Conflict?
Lately, I've been writing a lot about three-way merge . Dolt is the first and only SQL database to provide three-way merge of both schema and data. Being first means we get to define how three-way works for SQL databases. Defining behavior can...
Read More - SQL5 min read
Dolt TPC-C Improvements
The first production version of Dolt was released a little over a year ago. Since then we have been narrowing the performance differences between MySQL and Dolt. We've blogged several times recently about improving Dolt's transactional throug...
Read More - INTEGRATION19 min read
Using Debezium to Capture Changes from a Dolt Database
A few weeks ago, we announced the first release of support for Dolt-to-MySQL replication . Dolt now supports replicating to a MySQL database and from a MySQL database, through the MySQL binlog protocol . In addition to replicating databases to ...
Read More - REFERENCE16 min read
Ensuring Data Quality with SQL Types and Constraints
The inspiration for Dolt and DoltHub was data sharing. Most data today is shared via file. Common data formats are CSV, XML, or JSON. Dolt is a fully capable MySQL-compatible SQL database with Git-like version control. We share open source us...
Read More - TECHNICAL9 min read
lambdabats: Running BATS Tests with Massive Parallelism
Introduction Over four years ago, we wrote about how we use Bash Automated Testing System (Bats) to test Dolt . We love bats for automated end-to-end tests of Dolt use cases that make use of the Dolt CLI. At the time that the blog launch...
Read More