- 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
- COMMAND LINE4 min read
Dolt SQL Shell
Dolt is a SQL Database which allows for the full branching and merging of tabular data. Being SQL based, we can interoperate with many existing tools and platforms which exist and are familiar to users. There are many ways to interact with SQ...
Read More - REFERENCE8 min read
So you Want Database Branches?
Here at DoltHub, we've published a series of "So you want..." articles to help people find Dolt, the world's first version controlled SQL database , when they are looking for it but just don't know it yet. Today's article focuses on databas...
Read More - TECHNICALDOLTGRES7 min read
PostgreSQL's COPY Protocol
We're excited to announce that you can now import tabular data files into Doltgres using the COPY ... FROM STDIN statement. In this blog post, we'll examine how the PostgreSQL wire protocol supports importing bulk data, look at how we impleme...
Read More - FEATURE RELEASE11 min read
Dolt Signed Commits
Introducing Signed Commits in Dolt At the core of Dolt is a commit graph which tracks the changes made to your database over time. Just like a Git commit, a Dolt commit is a snapshot of the database at a point in time. Dolt commits are immuta...
Read More - GOLANG15 min read
Building package-level, runtime configurable logging ala log4j in Go
Introduction We're using Go to write Dolt , the world's first version-controlled SQL database. Before I joined DoltHub, I had been a backend Java developer for over a decade. I love Go, and I vastly prefer it to Java. I'm on record as sayin...
Read More - SQL6 min read
Scanner Retries & Import Streaming
Dolt is the only version controlled SQL database that supports Git semantics. We have added a lot of performance gains to the SQL side this year to mostly predictable places. For example, adding statistics for costed join planning guards against...
Read More - WORKBENCH10 min read
Building an Electron App with Next.js
Last year, we launched the Dolt Workbench , an open-source SQL workbench for MySQL and PostgreSQL databases. It has become a popular tool among our users, offering a modern UI for viewing and editing your data with powerful version control featur...
Read More - FEATURE RELEASE4 min read
Announcing `dolt add --patch`
SQL and Git had a baby, and we named this bundle of joy Dolt . My last couple posts here on the blog have been about Git Workspaces and Dolt Workspaces , and that was to lay the groundwork for today's announcement: Dolt now supports add --...
Read More - SQL11 min read
JSON Showdown: Dolt vs MySQL
UPDATE: The original version of this post accidentally used an outdated SQL client when benchmarking Dolt, which introduced additional latency. With the updated metrics, Dolt is even faster. The previous version of this post concluded that Dolt…...
Read More - SQL3 min read
Correctness Update
Welcome back to another installment of Dolt's monthly correctness updates! If you missed it, here's last month's update . This month, we tackled several dolt-specific issues and make improvements to long-standing trouble areas. Dolt-Specifi...
Read More - FEATURE RELEASE9 min read
Dolt Rebase Conflict Resolution
Dolt is the world's first SQL database with Git-style version control. You can branch, merge, diff, and even rebase your relational data, in all the same ways Git allows you to manage your source code. Dolt's novel data storage layer enables a...
Read More - SQL7 min read
How We Count Faster Than MySQL
Dolt is the first version controlled database with Git semantics. We often compare ourselves to MySQL because that was the first wire protocol we achieved drop-in compatibility with. But , with the release of Doltgres , we also have a Postgres…
Read More - DOLTGRES1 min read
TablePlus Works with Doltgres
Doltgres is a SQL database with Git-style versioning, a Postgres version of Dolt . We've been working to make Doltgres compatible with PostgreSQL by supporting database workbenches such as TablePlus and DBeaver. Today, we share our progress of ...
Read More - REFERENCE3 min read
DoltHub Blog: Greatest Hits
Here at DoltHub, we've published over 750 blog articles . That's a lot of content. Which blog articles should you read? This article lists the DoltHub blog's greatest hits. They are divided into helpful categories so you can get the lay of the la...
Read More - REFERENCE14 min read
Dolt runs on Diesel
Hello Rustaceans , welcome to the world of Dolt and Diesel! Dolt is a version controlled database that is a drop-in MySQL replacement. We've demonstrated Dolt's compatibility with a plethora of tools and ORMs . Diesel is an ORM and query bui...
Read More - FEATURE RELEASE6 min read
Introducing Workspace Updates
A couple weeks ago I reviewed the Git Workspace, and I also covered how Dolt has the same feature. If you are unfamiliar with what the Workspace is, I suggest you read the review . Today, I'm pleased to annou...
Read More - REFERENCEUSE CASE7 min read
Dolt for Data Engineers
Dolt is MySQL-compatible. When data engineers hear "MySQL", they think "this is not for me". Data engineers work with "Big Data" in databases like Databricks or Snowflake . MySQL is not for big data. In database parlance, Snowflake and Da...
Read More - DOLTGRESSQL3 min read
Enhancing Index Support
We're continuing to make progress on DoltgreSQL , which is a version of Dolt built to be a drop-in replacement for PostgreSQL. For those that may not know about Dolt , it's built as a drop-in replacement for MySQL that is built, from the gro...
Read More - TECHNICAL9 min read
Why I Threw Away Perfectly Good Code
This blog post is inspired by the video essay This Problem Changes Your Perspective On Game Dev by Jonas Tyroller. As the title of the video suggests, Jonas is drawing from his own experience as a game developer, and so he approaches the v...
Read More - GOLANG4 min read
The 4-chan Go programmer
Introduction We're using Go to write Dolt , the world's first version-controlled SQL database. Like most Go codebases, we use channels and goroutines to implement concurrent execution. Usually we use these constructs in the most borin...
Read More