- 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
- 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 - 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