- 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
- 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 - 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