- 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
- GOLANG6 min read
Why Are Golang Heaps So Complicated
Heaps are commonly used to partially sort a set. Every insertion/deletion from the set is followed by a "fixup" to restore either min-heap or max-heap integrity. For example, a max-heap can be represented as a binary tree where every parent is…
Read More - RELEASEWEBWORKBENCH3 min read
Introducing the Dolt Workbench
We are excited to announce the release of the Dolt Workbench - a modern, browser-based, open source SQL workbench for your MySQL-compatible database. It works with MySQL, MariaDB, and Dolt databases, with additional version control features w...
Read More - TECHNICALDOLTGRES9 min read
Getting to one 7 of SQL correctness for DoltgreSQL
Introduction We're writing Dolt , the world's first version controlled SQL database . Dolt is based on the MySQL dialect and wire protocol, and built to be a drop-in replacement for any MySQL application. But many potential customers expr...
Read More - REFERENCE7 min read
Dolt + Excel
Dolt , DoltHub , and Hosted Dolt can be used for Spreadsheet Version Control . Many of our customers migrated to Dolt from a really complicated, heavily edited spreadsheet . Earlier this year, I wrote a blog about how to use Dolt with G...
Read More - 5 min read
A Spooky Performance Regression in AWS EBS Volumes
For every Dolt release, we run a suite of Sysbench tests that measure the median latency of Dolt's reads and writes. Since Dolt is a drop-in replacement for MySQL , and soon to be a drop-in replacement for PostgreSQL , we compare Dolt'...
Read More - REFERENCE14 min read
Smashing Decentralized Databases Together for Fun and Science
A year ago, our founder and CEO Tim wrote a blog post about the recent explosion of interest in decentralized databases. You can read it here . If you like learning about cool new technologies, you should read that first. In Tim’s post, he ...
Read More - FEATURE RELEASE10 min read
Dolt Reflog
DoltDB is the world's first fully-versioned relational database . You can branch, merge, diff, push, and pull your relational data in the same ways that Git allows you to work with your source code files. We're passionate about making Dolt t...
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 d...
Read More - INTEGRATION15 min read
Hibernate on Dolt, A Sample App
Dolt is the world's first version controlled Database . I've been building software for more than 20 years, and building on top of Dolt makes application development fun again. As I built a little application us...
Read More - TECHNICAL7 min read
Getting stack traces for errors in Go
Introduction This blog is part of our ongoing Go language blog series . We publish a new article in the series every three weeks. We're writing Dolt , the world's first version controlled SQL database . This blog is about different ...
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
Here at DoltHub we love fixing customer problems. We have a goal to fix every bug our customers report within 24hrs. It's one of the reasons we release new builds all the time, for instance, three this week! It would be irresponsible for us to...
Read More - RELEASE4 min read
Virtual column support in Dolt
Introduction We're writing Dolt , the world's first version controlled SQL database. Dolt advertises itself as a drop-in replacement for MySQL, so if your current application works on MySQL you can swap in Dolt on the backend with no code c...
Read More - 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
Here at DoltHub, we strive to ensure the Dolt database can be a drop in replacement for MySQL . We've written a lot about this , and this particular post continues this tradition. The tool of this round is called FusionAuth , which is a...
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()
DoltDB is the world's first fully-versioned relational database. It gives you the versioning semantics of Git with all the power and expressiveness of SQL. One of Dolt's greatest strengths is keeping your data safe. You can trace how every bit...
Read More