- 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
- TECHNICAL12 min read
How we can Build a Vector Index from Prolly Trees
Dolt is the first version controlled SQL database, built on Prolly Trees. Prolly Trees are the novel data structure that power's Dolt's unique storage layer, making it possible to manage multiple branches in a space-efficient way. Here at Dolthub, ...
Read More - REFERENCE7 min read
Dolt for SOX Compliance
In 2017 Snap Inc went public which meant that there was a rush to become Sarbanes Oxley (SOX) compliant. At that time I was the lead developer on the ad delivery team which was directly responsible for one of Snap's revenue streams. As a result I…...
Read More - GOLANG5 min read
Reflecting on Go Reflection
Dolt is a database with branching and merging written in Go, and this post is one our many Go related blog posts Despite my 20 plus years of writing code for a living, I've never been a programming languag...
Read More - DOLTLAB10 min read
How to run DoltLab without egress
DoltLab is the self-hosted version of DoltHub , a web-based remote for your Dolt databases. In recent weeks, we had a DoltLab customers reach out to us looking to run their DoltLab instances from within a closed, internal network where eg...
Read More - WORKBENCH7 min read
How to Submit an Electron App to the Mac App Store
We are excited to be nearing the release of the Dolt Workbench desktop application! If you're curious about how we built our desktop app, check out our previous blogs about building an Electron app and adding custom menus . When distribu...
Read More - USE CASE7 min read
How to Restore a Dropped Database
Dolt is the world's first version-controlled relational database. It gives you all the power of Git to branch , fork , merge , diff , and even rebase your relational data. When you use Dolt, you have confidence that your data is safe – e...
Read More - SQL2 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 . We've been receiving fewer customer issues lately, so there was a focus on adding more features and expanding on existing…
Read More - USE CASE6 min read
Dolt + post-no-preference: Open Data
We built Dolt and DoltHub for data sharing. These products were our answer to the question, "Why is there no place on the internet to get access to interesting, maintained data?" A few other people answered the question at about the same ti...
Read More - 3 min read
The Plan for Vectors in Dolt
Lately, I keep hearing about vector databases. Even databases that weren't originally made for vectors are getting vector capabilities added via plugins: MariaDB Vector , announced in July, is in preview. Sqlite has sqlite-vec , which o...
Read More - WORKBENCH3 min read
How to Create Custom Desktop Menus in Electron
Here at DoltHub , we've been working hard turning our Dolt Workbench web application into a desktop app using Electron. In my previous blog , I talked about how to build an Electron app with Next.js. There may be situations where you need to...
Read More - REFERENCE8 min read
So you Want Git for Data? 2024 Edition.
It's hard to believe it's been over four years since I first mused about Git for Data . Let's revisit the topic. What is “Git for Data” in practice? Many products have come to market with some relation to the "Git for data" theme. Dolt and ...
Read More - SQL12 min read
JSON Showdown: Dolt vs Postgres
Dolt is the first truly version controlled database . It's "Git, but for SQL data." But it's not just Git for SQL data. The same techniques Dolt uses for efficient version control also make it really good at handling JSON. That's why I've been...
Read More - REFERENCE15 min read
Getting Started: Flutter and Dolt
We're on a mission to show that Dolt works with all your favorite tools in all your favorite languages . Today we show you how to build a Dolt-backed desktop application with Flutter , an open source framework powered by Dart for building...
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