- 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 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 - FEATURE RELEASEWEB3 min read
Pull Request Diff Comments
DoltHub is a place on the internet to share, discover, and collaborate on Dolt databases. We're committed to making data collaboration seamless and effective for you, which is why we're excited to share an exciting addition to our pull request...
Read More - 9 min read
A bug in MySQL, or working as intended? You decide
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 - 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
Replication Updates
Dolt supports three types of replication : Remote-based replication launched October 2021 Standby replication launched October 2022 Replicate from MySQL to Dolt launched February 2023 Hosted Dolt launched read replicas in...
Read More - SQLFEATURE RELEASE7 min read
Announcing: Scheduled Events
We're excited to announce support for executing scheduled events on a Dolt sql-server! Scheduled Events is a MySQL feature that lets you define SQL statements that run on a set schedule. You can think of it as the SQL server equivalent of cron j...
Read More - GOLANG9 min read
Using AWS Lambda with Golang to Generate On-call Calendars
We love developing in Go here at DoltHub. Our core product is DoltDB – an open-source, versioned, relational database that combines Git's distributed versioning features with all the power and expressiveness of a SQL database. Dolt is built from...
Read More - INTEGRATION20 min read
Getting Started with Dolt and Knex.js
Dolt is the world's first version controlled SQL database . Dolt is MySQL-compatible so all the tools you use with MySQL work the same way with Dolt, including Knex.js (which is surprisingly pronounced /k'nex/ instead of /nex/ - Tim wo...
Read More - REFERENCE8 min read
Python `autocommit` Off By Default
The snake doesn't like to commit. In Python autocommit is off by default in the Database API . This is different than other standard database connectors like ODBC and JDBC. Most common databases have autocommit on by default including SQL...
Read More - TECHNICAL10 min read
Running an open-source project Discord server
We are writing Dolt , the world's first and only version-controlled SQL database. It's free and open source software, and we've been using Discord to connect with our users for a little over 3 years. This blog is about why we picked Discord an...
Read More - FEATURE RELEASESQL5 min read
Reannouncing Dolt Query Diff
A couple years ago, we announced a version of query-diff . The feature always made us nervous. Dolt's storage engine promises fast diff based on content-addressed prolly trees . However, query-diff doesn't take advantage of Prolly trees; ra...
Read More - BOUNTY7 min read
Bye Bye Data Bounties
We're saying Good Bye to one of DoltHub 's most unique experiments, Data Bounties . DoltHub started with a data marketplace mission. Data Bounties were our best idea to bootstrap a virtuous cycle between data producers and data consumers. Da...
Read More - REFERENCEINTEGRATION11 min read
Dolt + Google Sheets
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 . I first tested Dolt against Google Sheets in fall of 2020 wor...
Read More