- 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
- TECHNICAL14 min read
Deep Dive on MySQL's Replication Protocol
MySQL's replication protocol is widely used to help systems achieve high availability, load balancing, and data redundancy. The replication protocol was originally introduced waaaay back in 2000, and in the more than two decades since then, the…
Read More - SQL5 min read
Dolt Is 25% Faster Running TPC-C
Dolt is the first relational database that versions data the same way Git versions source code. Dolt is 100% MySQL compliant and implements Git's interface with the same "proportional to diff" runtime. We spend a lot of time making sure we compe...
Read More - DOLTLAB16 min read
DoltLab Cloud Storage
We recently released DoltLab v2.1.6 which allows DoltLab Enterprise to use cloud storage, instead of disk storage on the DoltLab host. At the time of this writing, only AWS cloud resources are supported. This blog will walk you through set...
Read More - SQLFEATURE RELEASE5 min read
The Exciting Future of JSON on Dolt
tl;dr: Querying JSON documents in Dolt is about to get a huge performance boost. Beginning with Dolt 1.40, we're changing the way that Dolt writes JSON documents to disk. This will allow us to greatly improve performance when working with JSON. T...
Read More - TECHNICALDOLTGRES4 min read
pg_catalog: read only, or read-write?
Introduction We're hard at work building Doltgres , a Postgres-compatible database with git-inspired version control features. Our long-term goal is to be a drop-in replacement for Postgres, so that application developers can use Doltgres w...
Read More - USE CASE2 min read
Dolt + FJA: Version Control in 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? Are you loo...
Read More - REFERENCE4 min read
Pandas DataFrames Works With Dolt
Today's blog we will go over a simple way to utilize Pandas Dataframes using Dolt's version control features. Pandas Dataframes simplify data manipulation and analysis. Dolt simplifies data sharing and collaboration. Combining the two, a user can…
Read More - DOLTLABREFERENCE7 min read
Getting Started: DoltLab + GCP
We're on a DoltLab documentation tear. A few weeks ago, I wrote a Getting Started blog that outlined how to get DoltLab installed on an AWS EC2 host . Upon customer request, Dustin wrote a blog on how to get DoltLab set up on Azure . Toda...
Read More - FEATURE RELEASE5 min read
Introducing Embedded Dolt Commands in `dolt sql`
In the SQL universe, there are many tools which people use to interact with their data. There are applications like DBeaver which is a full GUI Application, or Dolt's WorkBench which uses a browser for its GUI components. On the other end of ...
Read More - DOLTGRESSQL4 min read
Announcing Sequences Support
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 about Dolt , it's built as a drop-in replacement for MySQL that is built, from the ground...
Read More - REFERENCE4 min read
Which Dolt is Right for You?
Here at DoltHub, we build a surprisingly large number of products all built around the "version controlled database" theme. We have Dolt , Doltgres , Hosted Dolt , DoltHub , DoltLab , and the Dolt Workbench . We know this is a daz...
Read More - GOLANG16 min read
Sentinel errors and errors.Is() slow your code down by 500%
In this blog post, we benchmark different strategies for handling errors in Go and discuss their relative performance and other tradeoffs. The difference in performance between different strategies was very surprising to us, and we'd like to share…...
Read More - DOLTLAB13 min read
Getting Started with Microsoft Azure and DoltLab
In a recent blog post , Tim provided new DoltLab users a helpful "getting started" guide that explained how to start running a DoltLab instance on AWS . Admittedly, we are an AWS shop here at DoltHub , so providing tutorials about using...
Read More - SQL5 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. SQLAcidTests A user on our Discord pointed our attention towards SQLAcidTests , which is e...
Read More - 9 min read
How Large is a 160 Bit Number?
When we combined SQL and Git to make Dolt, the world's first version controlled database, we took a lot of inspiration from Git's use of content addressed storage. Merkle Trees and DAGs allow us to continually add content to the database and not...
Read More - 3 min read
The Dolt 24 Hour Pledge. Wait. There's more...
If you find a correctness bug in Dolt, we'll fix it in 24 hours or less. We even wrote a blog about how we do it . The blog did well on HackerNews , generated some internal discussion, and now I have an addendum. The nature of Dolt as a vers...
Read More - DOLTLAB5 min read
Customizing the look of your DoltLab
DoltLab is Dolt 's self-hosted remote with a built-in web interface. We've been publishing more DoltLab content recently to make it easier for you to get started with your own DoltLab. If you're new to DoltLab, I'd recommend starting w...
Read More - REFERENCE3 min read
DoltHub is SOC2 Compliant
Service Organization Controls 2 or SOC2 is a security certification. DoltHub recently received our SOC2. We even have a Trust page to show for it. You'll have to request access but we're happy to provide it. This blog will walk you through ...
Read More - TECHNICALDOLTGRES10 min read
psql's Hidden Queries
Introduction We're hard at work building Doltgres , a Postgres-compatible database with git-inspired version control features. Before we built Doltgres we built Dolt , which is MySQL-compatible instead. One of the first things we needed t...
Read More - USE CASE4 min read
Dolt + Scorewarrior: Version Controlled Game Configuration
Dolt is a version controlled SQL database . How would you use such a thing? A popular Dolt use case is version controlling configuration . Modern games have a ton of configuration. Managing megabytes or gigabytes of configuration across ma...
Read More