Blog

I'm currently staring at what I think might be the biggest open database of housing sales records ever. It's 50GB of uncut housing sales records straight from the government coffers. Tens of millions of them. …

Welcome back to the second post in this blog series exploring the magic that makes Dolt so unique and powerful. Dolt DB is a MySQL-compliant SQL database that also provides the distributed versioning featur…

For those new to Dolt and DoltHub, Dolt is Git for data. Git versions files. Dolt versions SQL tables. DoltHub is a place on the internet to share Dolt databases. Recently we received a feature request from…

Today we're going to discuss a series of schema bugs discovered in our version-controlled database, Dolt. It manifested in three related ways, from the display layer, into the storage layer, and finally the…

Today we are excited to announce the release of DoltLab v0.3.1, the product that lets you self-host your own DoltHub! Hopefully you've been following along with our DoltLab announcements and related blog po…

What Makes Dolt Easy? We think one of the big advantages of Dolt is that it can be downloaded and running on your machine in under a minute. Maybe a little bit longer when you set up your DoltHub login so y…

Go 1.18 has been released and along with it comes long-awaited support for Generics! Generics are the most significant change to the language in years. They add a new dimension to what is otherwise a minimal…

Introduction We have been working hard towards making Dolt a production-grade, MySQL compatible database. Last year, we discussed MySQL compatibility in the form of SQLLogictests where we hit 99% correctne…

Note: We released a Postgres version of Dolt called DoltgreSQL. Dolt is the first version controlled SQL database. DoltHub is a place on the internet to share Dolt databases. DoltLab is a self-hosted ve…

Version Control your Existing Database One of the best use cases to get started using Dolt is to version control your existing database in Dolt. This is additive to your existing environment and won't requi…

Here at DoltHub, we’re building Dolt DB – a new type of distributed, versioned database that gives you all the power and expressivity of a SQL relational database, combined with the ability to time travel …

The software development world vs. the database admin world Why is the way we make changes to software so different from the way we make changes to databases? It's impossible not to notice. In one world we…

Immutable databases come in three flavors: ledgers, blockchains, and version controlled databases. This is a survey of immutable databases, excluding blockchains. Dolt is an immutable SQL database with version…

DoltHub is a web-based UI built in React to share, discover, and collaborate on Dolt databases. We recently migrated our monorepo to Yarn 2 (or Yarn Modern). It took us some extra steps to make Yarn 2 work …

One of the best use cases to get started using Dolt is to version control your existing database in Dolt. This is going to be very additive to your existing environment and won't require changes to your existi…

This year we launched DoltLab the self-hosted version of DoltHub. In February, we released the latest version of DoltLab, version v0.2.0, which included a number of features and bug fixes. We are actively work…

Introduction Dolt is on its way to becoming a production grade version-controlled MySQL database. Most developers associate "production grade" software with performance, but to us, it includes user experie…

About this bounty For our latest bounty we've been pretty ambitious. We asked our community to go out and scrape as many housing sales records as they can find, and after the bounty finished, we topped out …

With Dolt, you can push and pull a local MySQL compatible database to and from a remote. Remotes can be managed with the dolt remote CLI command and it supports many types of remotes. You can use a separate…

If any of you are like me, you've been distracted for the past couple weeks with the Russian invasion of Ukraine. This event has fundamentally changed the perspectives of many in the world. I foresee a bigger …