- 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
- 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
Dolt is a drop in replacement for MySQL, but beware because transactions behave differently
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()
The new dolt_undrop() stored procedure allows you to easily restore dropped databases
Read More - FEATURE RELEASEWEB3 min read
Pull Request Diff Comments
After you open a pull request in a database, users can comment on the comparison of table cells between the two specified branches.
Read More - 9 min read
A bug in MySQL, or working as intended? You decide
Fixing a bug in Dolt that MySQL still has and will not fix
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
- SQLFEATURE RELEASE7 min read
Announcing: Scheduled Events
Dolt now supports creating and executing MySQL Scheduled Events.
Read More - GOLANG9 min read
Using AWS Lambda with Golang to Generate On-call Calendars
A quick Golang project to generate an ICS calendar feed for an on-call schedule managed by AWS Incident Manager
Read More - INTEGRATION20 min read
Getting Started with Dolt and Knex.js
A demonstration, complete with sample code, on how to use Knex.js with Dolt, the world's first version controlled SQL database.
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
Tips for running a Discord server for an open-source software project
Read More - FEATURE RELEASESQL5 min read
Reannouncing Dolt Query Diff
Dolt is now able to produce a diff from the resulting table sets from two queries, again.
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