- 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
- DOLTGRES4 min read
Failing 100 Real World Postgres Dumps
We loaded 100 real world Postgres dumps and failed almost all of them. Read more to find out why we did this, and how we're solving these issues.
Read More - REFERENCE11 min read
- INTEGRATION12 min read
Vercel v0 Works with Dolt
We've been exploring generative AI tooling and in this blog post we take a look at Vercel's v0.app tool that gives you a conversational interface for generating web apps. We build a small web app that loads data from a Dolt database, and use Dolt's version-control features to expose that version information in the web application.
Read More - TECHNICAL13 min read
Multi-stage Docker Builds for Dolt
How multi-stage Docker builds enable faster builds for release and source Dolt images.
Read More - REFERENCE8 min read
Common Table Expressions in MySQL: How and Why with Examples
Learn how to use common table expressions (CTEs) in MySQL, what they're good for, and try out some examples.
Read More - GOLANG7 min read
We tried Go's experimental Green Tea garbage collector and it didn't help performance
Go 1.25 includes support for an experimental new garbage collector called Green Tea. We tried it out with Dolt's main performance benchmarks and summarize what difference it made (not much).
Read More - GOLANGFEATURE RELEASE5 min read
Grafana's metrics backend for go-mysql-server
Grafana recently launched support for SQL queries in their metrics dashboards. We describe how they used go-mysql-server, a SQL query engine written in Go, to implement this feature.
Read More - AI4 min read
Agents Need Branches: UC Berkeley CS Edition
The world is starting to realize agents need branches, specifically database branches. This article dives deep into what Supporting Our AI Overlords: Redesigning Data Systems to be Agent-First says about database branches and acts as DoltHub's formal response.
Read More - WORKBENCH4 min read
How to Run Tests in the Dolt Workbench
Learn how to use Dolt's built-in test engine entirely within the Dolt Workbench.
Read More - SQL6 min read
When CLI Meets SQL: Building Unified Interfaces in Dolt
Strategies for building options across both CLI commands and SQL table functions in Dolt.
Read More - AI10 min read
Developing an AI Agent
Developing an AI agent is a new experience for most software developers. Here is my experience developing an AI agent
Read More - AI4 min read
Three Cheers for AI Image Generation
Creating good marketing copy is hard, specifically the imagery associated with the copy. The good news is that AI image generation is getting really good. It's not good enough to make production images but it is good enough to help with the creative process. I use it to send more fleshed out ideas to our designers. This article walks through two examples
Read More - FEATURE RELEASE7 min read
Foreign Keys Referencing System Tables
Dolt now supports declaring foreign keys that reference the name field on the dolt_branches system table. This allows you to create tables that track additional data for the branches in your database, and helps ensure consistency with the referenced data in the dolt_branches system table.
Read More - FEATURE RELEASESQL4 min read
Focused Diffs: New --skinny and --include-cols Options for DOLT_DIFF() table function
The DOLT_DIFF() table function now supports --skinny and --include-cols options for more focused diff output!
Read More - GOLANG6 min read
Go channels to solve interface impedance mismatch
Learn how Go channels can solve a particular form of interface mismatch common in application development.
Read More - WEBWORKBENCH6 min read
Automating the Release Process for a Desktop Application
We recently automated the release process for the Dolt Workbench desktop application using GitHub Actions. This article discusses how we did it.
Read More - TECHNICAL7 min read
Challenges with Prolly Trees and Columnar Storage
Columnar storage is widely used in industry-leading OLAP databases and provides many benefits for analytic workloads. If we wanted columnar storage in Dolt, what are some challenges we would face?
Read More - FEATURE RELEASE7 min read
Announcing Dolt SQL Server MCP
We've added Dolt MCP directly to Dolt! This blog will show you how spin up both the Dolt SQL server and Dolt MCP server with a single command.
Read More - AI4 min read
The Three Pillars of Agentic AI
Having spent the past six months diving deep on agentic artificial intelligence, it became clear agents need three pillars to operate correctly: a capable model, version control, and testing. This article explains.
Read More - INTEGRATION10 min read
Maxwell's Daemon Works with Dolt
Maxwell's Daemon is a change data capture tool that reads from a MySQL binary log stream and publishes the data changes to a variety of endpoints such as Redis, RabitMQ, Amazon SNS, Kafka, Amazon Kinesis, and many more. Because Dolt is a MySQL-compatible database, you can easily connect Maxwell's Daemon to a Dolt SQL server to intercept data changes.
Read More