Brian Hendriks

December 16, 2024

In my last blog I talked about a lot of aspects of taking your Dolt database to production. One of the things I mentioned was the importance of securing your database, but didn't cover the acquisition and deployment of SSL certificates. In th...

James Cor

December 13, 2024

Dolt is a drop in-replacement for MySQL, which means it can be used with any MySQL-compatible tool. One such tool is Mydumper and its counterpart Myloader. Mydumper is a MySQL Logical Backup tool that emphasizes parallelism and performance. I...

Dustin Brown

December 12, 2024

In November, we announced support for continuous integration (CI) testing on DoltHub , which lets users programmatically run checks on their databases. At the time of the announcement, these checks were limited to push events, but today we'...

Jason Fulghum

December 11, 2024

Lately, we've seen customers install the latest innovation release of MySQL (i.e. MySQL-9.0) and then have problems connecting to a Dolt SQL server due to MySQL-9.0 removing mysql_native_password auth support. In this post, we'll explain what...

Tim Sehn

December 10, 2024

Hot on the heels of my overview of Dolt configuration , I'm going to do a deep dive on config.yaml , the configuration file for a Dolt SQL Server. As I was writing the configuration overview, I realized our documentation on our main configurati...

Tim Sehn

December 9, 2024

Dolt is a decentralized database . In the past ten years or so decentralization has gone through a few hype cycles. I think we're in a pro-decentralization hype period right now. Decentralization hype tracks the price of Bitcoin and last I checke...

Taylor Bantle

December 6, 2024

We've been hard at work getting Doltgres , a Postgres-flavored version of Dolt , ready for its beta release in Q1 . This includes making sure all the version control features you know and love from Dolt also work properly in a Postgres enviro...

Nick Tobey

December 5, 2024

Last time, I discussed a specific design problem that I encountered while writing generic code in Go, and how I eventually solved it. I was proud that I had found a solution, although less proud that it wasn't the cleanest. ...

Tim Sehn

December 4, 2024

Dolt configuration is a bit of a mess. To start, it's a union of Git and MySQL styles of configuration. Then, Dolt specific configuration is sprinkled on top. It's been on our list for a long time to consolidate and rationalize Dolt configuration...

Tim Sehn

December 3, 2024

Dolt is the world's first and only version controlled SQL database. Dolt is fully MySQL-compatible. You connect to it with any MySQL client. Some MySQL clients require connection authentication using Transport Layer Security (TLS) . TLS is ofte...

Taylor Bantle

December 2, 2024

The Dolt Workbench is a modern, open-source SQL workbench that works with any MySQL and PostgreSQL compatible database, including version controlled databases like Dolt and DoltgreSQL . We think that the workbench experience is vastly impro...

Jason Fulghum

November 29, 2024

A couple of decades ago, as a brand-new CS grad just entering the world of big tech, I was given the Programming Perl book – also affectionately known as the "Camel Book". 🐪 I was told that I was now officially a Perl programmer and should lear...

Brian Hendriks

November 27, 2024

So you've been using Dolt for a while, and you are ready to take the next step and use it in production. Whether you are running your production environment on prem, or in the cloud, there are several steps you should take to ensure that your Dol...

Zach Musgrave

November 26, 2024

Dolt is the world's first and only version-controlled SQL database. It's a SQL database that you can fork, clone, branch, merge, push and pull just like a Git repository. Like files in Git, tables and other data in Dolt are content-addressed by a...

Max Hoffman

November 24, 2024

I ran into a performance trade-off last week attempting to improve long-running queries by changing the ways rows are structured. A more general row interface increases memory overhead but lets us skip encoding overhead. Unfortunately, joins create...

Nick Tobey

November 22, 2024

This comment on ycombinator lives rent-free in my head. Nothing before or since has captured my feelings on Go quite as succinctly. Take for instance, generics. Or its more precise name: parametric polymorp...

Dustin Brown

November 21, 2024

We recently announced support for continuous integration (CI) testing on DoltHub . This is a feature we're excited about since it allows our users to programmatically test changes on their data, instead of relying solely on human review. Fo...

Tim Sehn

November 20, 2024

Dolt is the world's first and only version controlled SQL database . We've been iterating on the concept for over six years now . We're the world's experts in database version control. Along the way we've learned a few things. This article...

Zach Musgrave

November 19, 2024

We are hard at work building Doltgres , the Postgres-compatible version of Dolt . Dolt is the world's first and only version-controlled SQL database and is MySQL compatible, and most of us at DoltHub are more familiar with MySQL than with Postg...

Nick Tobey

November 18, 2024

Dolt was created to be the world's first truly version controlled database . We think it does a great job at that. And in the process of making Dolt, we realized that the same data structures that make Dolt fast and efficient at version control a...