- 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
- REFERENCE4 min read
Postgres vs MySQL Sysbench Latency
What open source database is faster? Postgres or MySQL ? It's surprisingly hard to find latency benchmark comparisons between these two databases. Here at DoltHub, we're building the world's first version controlled SQL database, Dolt . D...
Read More - TECHNICALSQL10 min read
Achieving Efficient Version Control of JSON with Prolly Trees
Last month we announced that we were making changes to how Dolt stores JSON documents , in order to make Dolt best-in-class for manipulating JSON within a SQL database. Today, we're going to explore exactly what that means, how we accomplished it...
Read More - GOLANG8 min read
Go range iterators demystified
Introduction We're using Go to write Dolt , the world's first version-controlled SQL database. Like most large Go codebases, we have a lot of collection types that we iterate over. New in Go 1.23 , you can now use the range keyword to ...
Read More - DOLTLAB4 min read
Announcing DoltLab v2.2.0
Today we're announcing the release of DoltLab v2.2.0 that contains some important new changes that make getting started with DoltLab much easier. This year our focus with DoltLab has been improving the first-time user experience. So far, we'v...
Read More - REFERENCE18 min read
Three-way Merge in a SQL Database Examples
As promised in Three-way Merge Opus , I've come with a plethora of examples of three-way merge in a SQL database. Dolt is the only SQL database to support three-way merge of both data and schema. Getting Started Start with the database w...
Read More - TECHNICALDOLTGRES5 min read
Quoting differences between MySQL and PostgreSQL, and converting between them
Introduction We're hard at work building Doltgres , a Postgres-compatible database with git-inspired version control features. Doltgres is built on top of Dolt , which uses MySQL's syntax and wire protocol. Dolt has tens of thousands of t...
Read More - SQL5 min read
Are Git Branches MVCC?
Multiversion concurrency control (MVCC) is a technique relational databases use to avoid concurrent transactions blocking one another. This is how databases move beyond the performance limitations of two-phase locking . Most databases have conv...
Read More - FEATURE RELEASE9 min read
Dolt to MySQL Replication
Introduction Dolt DB is the world's first, and only, version-controlled SQL database. Dolt is a drop-in replacement for MySQL, so any tools or applications that work with MySQL will work with Dolt (if they don't... let us know so we can fix...
Read More - REFERENCE6 min read
Why People Don't Use Dolt
When you build a database from scratch , you hear a lot of reasons why potential customers choose not to use it. Dolt adds compelling Git-like version control features to the classic SQL database. These features are enough to get a lot of people…...
Read More - DOLTGRES5 min read
Update on pg_catalog Support in Doltgres
It's our goal to make Doltgres , a Postgres-flavored version of Dolt , a drop-in replacement for Postgres. A few weeks ago Zach wrote a blog about our design dilemma for implementing the pg_catalog schema: should we diverge from Postgr...
Read More - GOLANG12 min read
Writing generic collection types in Go: the missing documentation
Introduction Go generics were released in Go 1.18, over two years ago. We're using Go to write Dolt , the world's first version-controlled SQL database, and while we have hundreds of thousands of lines of Go code, we haven't used generics v...
Read More - INTEGRATION13 min read
Getting Started with Dolt and Prisma
Dolt is the world's first version controlled SQL database , offering full MySQL compatibility. This means that all tools you typically use with MySQL, including Prisma , work seamlessly with Dolt. Prisma ORM is an open-source toolkit desig...
Read More - DOLTLAB5 min read
How to set up AWS SES for DoltLab
DoltLab is the self-hosted version of DoltHub that lets you manage and customize a web-based Dolt remote complete with pull-request style workflows for seamless database collaboration. If you're looking to try DoltLab for the first time,...
Read More - SQL3 min read
Correctness Update
Welcome back to another installment of Dolt's monthly correctness updates! Here's last month's update , in case you missed it. This month, a couple new Dolt customers came to us with a variety of issues; they uncovered panics, syntax errors, and ...
Read More - SQL11 min read
Choosing a Database Schema for Polymorphic Data
Designing a schema for your relational database is a daunting task that has long term implications for the database's performance, maintainability, and correctness. And it often requires making decisions before having a clear picture of the exact…
Read More - USE CASE3 min read
Dolt + Threekit: Add Version Control to Your Application
Dolt is a version controlled SQL database . How would you use such a thing? Are you building a data curation application for your customers? Are your customers asking for version control features like branches, merges, and diffs on the data ...
Read More - SQL8 min read
Three Ways To Think About Channels
One of Golang's steepest learning curves is how to use channels. At the practical level, channels are locked, buffered queues. Their API matches that of a queue, the implementation is a queue, and I find it easiest to write and read channel code...
Read More - FEATURE RELEASEWEB3 min read
Start earning achievements on DoltHub!
Introducing Badges on DoltHub: Celebrate Your Milestones As DoltHub continues to grow, we’re excited to see more users actively engaging — creating databases, merging pull requests, and opening issues. Following our previous blog about ...
Read More - TECHNICALREFERENCE24 min read
Three-way Merge in a SQL Database
Dolt implements a Git-style commit graph on top of a Prolly-tree -based storage engine . This architecture makes Dolt the world's first and only version controlled SQL database . One of the major capabilities a version controlled SQL ...
Read More - DOLTGRESINTEGRATION2 min read
Doltgres SQL Server Postgres Client Support
Doltgres is a version-controlled, PostgreSQL-compatible database. This means any standard Postgres client should connect to the Doltgres server. Today’s blog shares an update on how far we are to support the standard Postgres SQL clients. We r...
Read More