Tim Sehn

October 27, 2023

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 recommended alternat...

Tim Sehn

October 25, 2023

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 the directory yo...

Neil Macneale

October 23, 2023

Dolt is a drop in replacement for MySQL, but beware because transactions behave differently

Nick Tobey

October 20, 2023

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

Jason Fulghum

October 18, 2023

The new dolt_undrop() stored procedure allows you to easily restore dropped databases

Liu Liu

October 16, 2023

After you open a pull request in a database, users can comment on the comparison of table cells between the two specified branches.

Zach Musgrave

October 13, 2023

Fixing a bug in Dolt that MySQL still has and will not fix

Nick Tobey

October 11, 2023

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 different SQL ...

Tim Sehn

October 9, 2023

In the mid-2000s SQL was having a rough time. NoSQL was all the rage. A chorus of senior engineers shouted: "SQL doesn't scale." "Oracle...Microsoft...waaaaaah! "DBAs are expensive and get in developer's way" "$10,000 per core for a <bleep> Oracle l...

Max Hoffman

October 7, 2023

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.0 -u root. T...

Brian Hendriks

October 4, 2023

Dolt now supports replicated permissions, database drops

Jason Fulghum

October 2, 2023

Dolt now supports creating and executing MySQL Scheduled Events.

Jason Fulghum

September 29, 2023

A quick Golang project to generate an ICS calendar feed for an on-call schedule managed by AWS Incident Manager

Taylor Bantle

September 27, 2023

A demonstration, complete with sample code, on how to use Knex.js with Dolt, the world's first version controlled SQL database.

Tim Sehn

September 25, 2023

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 Server, MySQ...

Zach Musgrave

September 22, 2023

Tips for running a Discord server for an open-source software project

James Cor

September 20, 2023

Dolt is now able to produce a diff from the resulting table sets from two queries, again.

Tim Sehn

September 18, 2023

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. Data bountie...

Tim Sehn

September 15, 2023

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 working from home dur...

Taylor Bantle

September 13, 2023

Hosted Dolt now supports SAML single sign-on for your organizations. Choose your third-party identity provider and configure SSO directly from the Hosted website.