- 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
- SQL6 min read
Disk Storage Read Planning
Dolt is the first and only database that versions structured data the way Git versions code. Our users use Dolt either as a relational database running on cloud hardware, like Hosted Dolt , or as a web collaboration tool like DoltHub or Dolt...
Read More - 5 min read
Deconfusing How To Use Gmail's SMTP server in 2024
I'm old enough to remember when writing an app to send emails from a Gmail account was cool. You click a couple things in your Google account console, you provide your username and password to your app, and zing , you're in business. Now, i...
Read More - DOLTLABREFERENCE11 min read
Getting Started: DoltLab
DoltLab is Dolt 's self-hosted remote with a built-in web interface. You get all the features of DoltHub , a built in SQL Workbench, Pull Requests, Issues, etc, on infrastructure deployed in your own network. This blog will walk through...
Read More - GOLANGTECHNICAL10 min read
Dolt Gets a cgo Dependency
At DoltHub, we're building Dolt, a MySQL-compatible SQL database with Git-like functionality, including branch, diff, merge, push, pull and clone. Dolt is written in Go. For a variety of reasons, we have traditionally avoided cgo dependencies in Do...
Read More - DOLTGRES1 min read
Introducing doltgres.com
We're serious about Doltgres , the Postgres-compatible version of Dolt. We're bringing Git-style version control to the Postgres ecosystem just like we brought it to the MySQL ecosystem with Dolt. We're just a couple years behind on Doltgres. ...
Read More - TECHNICAL5 min read
Dolt Storage: Introducing Archives
This is the third in a series about how Dolt stores bytes on disk. The first two parts provide a lot of context about what today's blog is about: A new storage format! Two weeks ago we reviewed the existing storage system and its index lookup...
Read More - REFERENCE9 min read
Shiny using R Works With Dolt
Dolt is a combination of MySQL and Git, creating the first ever version controlled database . Today's blog we will build a simple Shiny app using Dolt to branch, commit, push, and pull a database. What we nee...
Read More - REFERENCE9 min read
Why you need a Git-style Remote for your Database
Dolt is the world's first version-controlled SQL database . It merges, pun intended, all the features of a SQL database like MySQL with the version control functionality of Git. Git has the concept of a remote . Remotes are the things you ...
Read More - SQL4 min read
Correctness Update
About a month ago, we provided an update to Dolt's correctness . Since then, we've continued to make improvements; here's what we've been up to. Bug Fixes As usual, we're always trying to make a dent in our bug queue . Here are some no...
Read More - DOLTGRESFEATURE RELEASE5 min read
Announcing Postgres to Doltgres Replication
Introduction Last month we published a deep dive on how to build a Postgres logical replication system in Go . Today we're excited to announce the release of this feature, available in the latest version of Doltgres . ...
Read More - TECHNICAL11 min read
Dolt Storage: The Case For Dictionary Compression
Last week, I reviewed the storage system used to store bytes on disk for Dolt databases. As I mentioned at the time, it's not perfect, and we are considering changes to the format. I've been researching this primarily through the lense of space…...
Read More - GOLANG22 min read
Golang PGO builds using GitHub Actions
In February of this year, I announced that Dolt releases are now built as profile-guided optimized (pgo) binaries, levering this powerful feature of Golang 1.20 to increase Dolt's read performance by 5.3%. Prior to my announcement, Z...
Read More - REFERENCE6 min read
Schema Migrations in Dolt
Dolt is the world's first version controlled SQL database. You can build applications with Git-style branches and merges on top of Dolt using all the frameworks you know and love: Laravel , Ruby on Rails , Django , .NET , Knex.js , etc. T...
Read More - TECHNICAL7 min read
Dolt Storage: A Review
Storage of information is the bedrock of every Database in existence. The logical application concepts by which you store that information is where a lot of Database discussion occurs. In Dolt's case, we talk abou...
Read More - DOLTGRESSQLTECHNICAL5 min read
Exploring DoltgreSQL through Type Compatibility
We're steadily making progress on DoltgreSQL , which is a version of Dolt built to be a drop-in replacement for PostgreSQL. For those that may not know, Dolt is the world's first database that is built, from the ground up, with version cont...
Read More - 7 min read
What I Wish I'd Known About Writing Extensions for Unreal Editor
In a previous blog , I announced a plugin for the Unreal Editor that allows for importing and exporting table data to and from Dolt , our version-controlled SQL database with Git-like semantics. You can find that plugin here . I've already...
Read More - REFERENCE13 min read
A Study in Structural Sharing in a Dolt Prolly Tree
Dolt is a MySQL-compatible SQL database with Git-like versioning features. It supports branching, merging, diff, push, pull and clone of the entire database — schema and data. Dolt's data versioning features are based on a unique sorted index…
Read More - DOLTLAB19 min read
Announcing DoltLab v2.1.0 and its new Installer
We recently released DoltLab v2.1.0 , that contains a brand new tool for configuring a DoltLab instance: the installer . The DoltLab installer is a single binary that will generate all the assets DoltLab needs to run. For those familiar with...
Read More - FEATURE RELEASE5 min read
Feature: last_insert_uuid()
DoltDB is the world's first fully-versioned relational database . You can branch, merge, diff, push, and pull your relational data in the same ways Git allows you to work with source code files. If you're curious what sorts of use cases that en...
Read More - REFERENCEDOLTGRES4 min read
Cataloguing SQL Support in DoltgreSQL
Dolt is version controlled relational database combining features from Git and MySQL. Not a fan of MySQL ? No problem. We are now developing DoltgreSQL , Doltgres for short, which has features of PostgreSQL instead of MySQL . In this blo...
Read More