Liu Liu

October 16, 2023

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

Zach Musgrave

October 13, 2023

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

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

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

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

Brian Hendriks

October 4, 2023

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

Jason Fulghum

October 2, 2023

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

Jason Fulghum

September 29, 2023

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

Taylor Bantle

September 27, 2023

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

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

Zach Musgrave

September 22, 2023

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

James Cor

September 20, 2023

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

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

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

Taylor Bantle

September 13, 2023

Hosted DoltDB is for running online, production Dolt databases. We recently received a feature request for SAML integration for a single sign-on (SSO) solution to hosted.doltdb.com , which is available now! What is SAML? SAML (...

Jason Fulghum

September 11, 2023

Dolt DB is the world's first fully-versioned SQL relational database. It allows you to track the history of your data in every row and every column of all your tables. In the same way that Git enables you to branch, merge, fork, and diff your sou...

Nick Tobey

September 8, 2023

Previously, I wrote an article about pitfalls befouling Go newcomers. These were each lessons that I personally learned while working on go-mysql-server , a drop-in replacement for MySQL written entirely in Go. We made it to be the best pure-G...

Max Hoffman

September 6, 2023

Dolt is a SQL database with a custom storage layer designed for Git semantics. Dolt supports fast branching, diffing, and merging, plus all of the features MySQL provides. One of the ways we track our compatibility with MySQL are sqllogictests...

Stephanie You

September 1, 2023

Dolt's CLI has been getting a bit of a revamp recently. With more CLI commands migrated to use SQL to retrieve results, it's easier than ever to access your remote data this way. Our most recently migrated command is dolt log ! $ dolt -...

Dustin Brown

August 30, 2023

For growing software startups offering online products and services, there comes a time when having on-call engineers becomes a necessity. As customers and service level agreements begin to increase, someone needs to always be available to address…...