- 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
- 14 min read
MySQL Stored Procedures: How and why with examples
MySQL allows you to define stored procedures on your databases that can execute arbitrary SQL statements whenever you invoke them, including updating data in one or more tables. This tutorial will teach you how to use stored procedures and giv...
Read More - FEATURE RELEASE3 min read
Announcing automatic merging of JSON changes
Here's something that's true: Dolt makes it easy to collaborate and merge independent changes to your SQL database. Here's something else that's true: People really like JSON. It's flexible, human readable, and there's lots of existing tools ...
Read More - GOLANG9 min read
Coming Soon: Golang 1.22 🚀
At DoltHub , we love Go! We're using Go to build DoltDB , an open-source SQL database engine with Git-like distributed version control. Dolt lets you branch, fork, merge, and diff your relational tables, just like Git does for your source code ...
Read More - TECHNICAL13 min read
Writing a version-controlled application
Introduction We're building Dolt , the world's first version controlled SQL database . Our customers are using Dolt in a bunch of different ways , but by far the most common one is to write a version-controlled application. What is a...
Read More - REFERENCE16 min read
Getting Started: Laravel and Dolt
We're on a mission to show that Dolt works with all your favorite tools in all your favorite languages . Today we head to PHP -land and show you how to integrate Dolt with Laravel , a popular website builder with a built in ORM. ...
Read More - COMMAND LINE3 min read
Dolt CLI New Year's Resolutions
Dolt is a version controlled, relational database , the best of Git and MySQL combined. Recently, we've been giving a lot of love to the SQL side of Dolt and building a really robust experience. This year, I'm excited to give the Command Line…
Read More - FEATURE RELEASE12 min read
Dolt Interactive Rebase
Dolt is the world's first fully-versioned, relational database . The inspiration for Dolt's decentralized versioning model is Git. Dolt allows you to branch, merge, diff, push, and pull your relational data in all the same ways that Git allows ...
Read More - FEATURE RELEASE9 min read
Dolt SQL Server Push Support
Users of Git, in particular hosted Git services like GitHub, are very familiar with the ability to send their changes to another location using the push operation. Dolt, as the spawn of Git and MySQL, has supported the ability to push to DoltH...
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