- 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 RELEASEWORKBENCH5 min read
Dolt Workbench now supports PostgreSQL
We at DoltHub recently launched the Dolt Workbench , a modern, browser-based, open source SQL workbench with version control features when connected to Dolt . It started with support for MySQL-compatible databases, including MySQL, MariaDB, ...
Read More - REFERENCEWORKBENCH6 min read
So you want an Open Source SQL Workbench?
Here at DoltHub , we recently launched the Dolt Workbench , an open source, browser-based, modern SQL workbench for your MySQL -compatible (and soon to be PostgreSQL -compatible) databases. When I search for "SQL Workbench" I mostly get ...
Read More - USE CASE7 min read
Extending Shared Datasets
Dolt is the world's first fully-versioned, relational database . You can branch, merge, diff, push, and pull your relational data in all the same ways that Git allows you to work with source code files. One of the powerful features of Dolt i...
Read More - TECHNICALDOLTGRES5 min read
Comparing benchmarks for Postgres, MySQL, and their Dolt equivalents
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 - REFERENCE6 min read
Dolt Concurrent Transaction Example
Dolt is the world's first version controlled SQL database . Dolt is built on a novel storage engine that makes diffs and merges fast. When committing a SQL transaction, Dolt uses the same merge logic you invoke on a dolt merge between ...
Read More - TECHNICAL16 min read
Using Functional Dependency Analysis to improve Join performance
Two months ago I talked about how we got 4 9s of correctness in sqllogictests . I mentioned how the most time consuming task was optimizing a test query that joined 64 tables, a query that even MySQL choked on. I'm going to dive deeper into how...
Read More - REFERENCE8 min read
So you want to Version Control Configuration?
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 f...
Read More - REFERENCEDOLTGRES6 min read
Contributing to DoltgreSQL
Last month, I announced that we were finally starting development on DoltgreSQL . In a little over a month, we've made quite a lot of progress and released a new pre-release version. We've also expanded the development team that is working on ...
Read More - 3 min read
Christmas Come Early: An AWS EBS Performance Regression Update
Two weeks ago we published A Spooky Performance Regression in AWS EBS Volumes that highlighted a performance regression in writes against AWS EBS volumes we saw while benchmarking Dolt and MySQL . Initially we suspected that a recent sel...
Read More - REFERENCE7 min read
Sizing Your Dolt Instance
Dolt is the world's first version controlled SQL database . To implement Git-style version control functionality at Online Transaction Processing (OLTP) performance , Dolt has different hardware requirements than other OLTP databases. This arti...
Read More - INTEGRATION14 min read
Entity Framework Core with Dolt
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. Dolt is built from the ground up on ope...
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