- 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
Costing Index Scans
Dolt is the first version controlled SQL database . We have made many correctness and performance improvements over the last couple of years. But one of the things we have never been good at are queries that need to adapt to underlying table da...
Read More - INTEGRATION15 min read
- TECHNICAL7 min read
Getting stack traces for errors in Go
Techniques and libraries for getting stack traces for your errors in Go
Read More - WEB6 min read
Building Single Sign-On for your Web Application
We recently released single sign-on (SSO) for two of our web products, Hosted Dolt and DoltLab Enterprise . Administrators can configure an Identity Provider (IdP), where their users can authenticate and authorize access to their organization ...
Read More - SQL7 min read
Sensible User Privileges and Dolt Procedures
Keeping your version controlled data safe just got easier
Read More - RELEASE4 min read
- RELEASEDOLTGRES3 min read
Announcing DoltgreSQL
We are pleased to announce that we have started development on DoltgreSQL ! Dolt has grown significantly over the past few years, however it uses MySQL's syntax. Many users have asked us if we would support PostgreSQL's syntax, and we are fina...
Read More - FEATURE RELEASEDOLTLAB6 min read
Announcing DoltLab Enterprise Edition
We launched DoltLab , the self-hosted version of DoltHub.com back in January 2022 as a way to support users who wanted to harness the power of Dolt, but not push their data to the public internet. From that point on, we've consistently impr...
Read More - REFERENCE10 min read
AUTO_INCREMENT vs UUID Primary Keys
Dolt is the first and only version controlled SQL database . Dolt supports branches, merges, and clones. Astute Dolt users have long noticed that Dolt branches and clones do not play well with AUTO_INCREMENT primary keys. The Dolt recommende...
Read More - REFERENCE15 min read
Getting Started: Dolt with Docker
For a long time, Dolt resisted Docker . Here at DoltHub , we take a lot of pride in the fact that Dolt is a single program with no external dependencies. To use Dolt, you simply download the current build for your operating system, put th...
Read More - SQL12 min read
Transactions in Dolt? Hold My Beer
Dolt is a drop in replacement for MySQL, but beware because transactions behave differently
Read More - GOLANG10 min read
They're called Slices because they have Sharp Edges: Even More Go Pitfalls
On my last Golang post , I suggested that the main source of confusion in Golang is the fact that the language presents itself as a C-like object oriented language, and dresses itself in C-like syntax, while differing from C-like languages in…
Read More - FEATURE RELEASE6 min read
Recovering Dropped Databases with dolt_undrop()
The new dolt_undrop() stored procedure allows you to easily restore dropped databases
Read More - FEATURE RELEASEWEB3 min read
Pull Request Diff Comments
After you open a pull request in a database, users can comment on the comparison of table cells between the two specified branches.
Read More - 9 min read
A bug in MySQL, or working as intended? You decide
Fixing a bug in Dolt that MySQL still has and will not fix
Read More - SQL17 min read
Four 9's of Correctness
sqllogictests is a collection of around 6 million sql correctness tests, designed to be used a as benchmark for SQL engine implementations. Although sqllogictests was made by the sqlite team, it can check for compatibility with several differ...
Read More - SQLFEATURE RELEASE5 min read
How to Use Lateral Joins
Dolt is the first SQL database that versions data with Git semantics. Using Dolt is as easy as downloading the binary , picking a directory for your data ( mydb ), running dolt sql-server , and using a MySQL client to connect mysql -h 0.0.0....
Read More - FEATURE RELEASEHOSTED11 min read
- SQLFEATURE RELEASE7 min read
Announcing: Scheduled Events
Dolt now supports creating and executing MySQL Scheduled Events.
Read More