- 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
- GOLANG10 min read
Go import cycles: three strategies for how to deal with them, and a plea for a fourth
Everybody has their pet issues with their daily driver language. For Gophers, a lot of us complain about the verbosity of error handling. Me, I don't mind that so much. No, for me, my biggest complaint about th...
Read More - SQL11 min read
Introducing the Dolt Debug Command
DoltDB is a version controlled relational database built from the ground up. The storage format is novel. The execution engine is novel. Both are increasingly Postgres and MySQL compatible. And it is all open source and written in GoLang. ...
Read More - AI8 min read
How to Provision an EC2 GPU Host on AWS
AI is all the rage right now, and if you're like me, you're probably looking for quick and easy ways to try out this new technology yourself. There are some great ways to get started using AI locally on your own machine; I've personally been using ...
Read More - FEATURE RELEASECOMMAND LINE2 min read
Announcing Dolt SQL Shell Pager Support
Dolt, the world's first SQL Database which can version control every revision of data within it, has a variety of ways to interact with it. One of which is our home grown SQL Shell, which is a terminal based interface to the database, similar to ...
Read More - REFERENCE8 min read
Dolt for Beginners: Branches
The Dolt for Beginners series focuses on topics people getting started with Dolt will likely be interested in. Most of our other blog articles go pretty deep so we want a space to talk about topics that experts may find boring. ...
Read More - GOLANG2 min read
Archiving the dolthub/swiss GitHub Repository
At DoltHub, we're building Dolt, the world's first SQL database that supports Git-like version control, including branch, merge, diff, clone, push and pull. Dolt is written in Go. Almost two years ago, my colleague Andy released an implementation...
Read More - WORKBENCHFEATURE RELEASE4 min read
The Dolt Workbench Now Ships With a Built-In Dolt Server
We’re excited to announce that the Dolt Workbench , a modern, open-source SQL workbench for MySQL and PostgreSQL compatible databases, now bundles Dolt servers directly within the desktop application. No more jumping between terminals and GUI — n...
Read More - 11 min read
MySQL Foreign Keys: How and why with examples
Foreign keys are a tool to make your SQL table data accurate and safe. In this tutorial, learn what a foreign key is, how to use them, and what they're good for. What's a foreign key? A foreign key is a way to declare that values in one ta...
Read More - AI13 min read
Robot Blogs Suck
Well, we tried. If you're unaware, my last few posts have been about learning RAG and building a tool called Robot Blogger to generate blog posts for our company. We were hoping to see some real improvements in the quality of the generated...
Read More - REFERENCE8 min read
Dolt for Beginners: Commits
The Dolt for Beginners series focuses on topics people getting started with Dolt will likely be interested in. Most of our other blog articles go pretty deep so we want a space to talk about topics that experts may find boring. ...
Read More - SQL6 min read
Coordinating Goroutine Listeners
We use Golang to build DoltDB , a version-controlled SQL database. In the process we frequently run into language peculiarities and trade-offs. The Go runtime thread manager makes many things possible, but also sometimes gives us too many options...
Read More - FEATURE RELEASE4 min read
Announcing automatic garbage collection in Dolt sql-server
At DoltHub, we are building Dolt is the world's first version-controlled SQL database, supporting operations like branch , diff , merge , rebase , and blame as well as interactions with remotes such as clone , push and fetch . Tod...
Read More - 13 min read
MySQL Secondary Indexes: How and why with examples
One of the most important concepts in SQL is the index. This tutorial will teach you what an index is, how to use it, and what it's good for. What's an index? An index is a way for a database to quickly locate a particular set of rows. Ind...
Read More - AI6 min read
Announcing DoltHub Robot Blogger
Today we're excited to share our open-source Robot Blogger tool 🤖! If you've not been following along, I wrote about my experience learning about RAG to get a robot blogger prototype working. Our goal was to build something that we could ...
Read More - GENERATEDAI3 min read
Comparing Dolt and Git: `clone`, `pull`, and `push`
In the world of software development, Git revolutionized how teams manage and share code. Dolt , often described as "Git for data," takes that same transformative philosophy and applies it to relational databases. But what does this mean in pr...
Read More - REFERENCE7 min read
Dolt for Beginners: Schemas
The Dolt for Beginners series focuses on topics people getting started with Dolt will likely be interested in. Most of our other blog articles go pretty deep so we want a space to talk about topics that experts may find boring. ...
Read More - 12 min read
MySQL Primary Keys: How and why with examples
One of the most important concepts in SQL is the primary key. This tutorial will teach you what a primary key is, how to use it, and what it's good for. What's a primary key? A primary key is a way to identify exactly one record in a SQL t...
Read More - DOLTGRES3 min read
We need your pgdumps
Here at DoltHub we're hard at work on Doltgres , our Postgres-flavored version of Dolt . Dolt is the world's first version controlled database but it's MySQL-flavored. After years of customer feedback requesting a Postgres version, we caved ...
Read More - AI10 min read
Learning About RAG
Dolt recently added support for vector indexes , which are a type of index used commonly in RAG (Retrieval-Augmented Generation) applications. These applications are all the rage in the AI world right now, and for good reason. They enable de...
Read More