- 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
- REFERENCE4 min read
Dolt Pro Tips
Dolt is the world's first and only version controlled SQL database . We've been iterating on the concept for over six years now . We're the world's experts in database version control. Along the way we've learned a few things. This article...
Read More - SQLDOLTGRES5 min read
Postgres's missing quality of life features
We are hard at work building Doltgres , the Postgres-compatible version of Dolt . Dolt is the world's first and only version-controlled SQL database and is MySQL compatible, and most of us at DoltHub are more familiar with MySQL than with Postg...
Read More - SQL14 min read
JSON Showdown: Dolt vs Sqlite
Dolt was created to be the world's first truly version controlled database . We think it does a great job at that. And in the process of making Dolt, we realized that the same data structures that make Dolt fast and efficient at version control a...
Read More - REFERENCE2 min read
DoltHub is HIPAA Compliant
HIPAA certification is a security and privacy certification for organizations. HIPAA is generally required by customers dealing with health care data in the United States. This certification is very similar to Service Organization Controls 2 (SOC...
Read More - FEATURE RELEASE11 min read
Continuous integration testing on data
Continuous integration (CI) testing is a software development practice where automated tests are run against incoming code changes pushed by software developers collaborating on a code repository. If a developer pushes changes that fail to pass the...
Read More - REFERENCESQL7 min read
Old School DBT
Relational databases are an organizational step change improvement over flat files like Excel or JSON. Strict typing improves data quality and maintainability over time. Schema mutations, data versioning, lineage are tracked. And you get all of the...
Read More - SQLDOLTGRES7 min read
Doltgres Correctness Update
We are hard at work building Doltgres , the Postgres-compatible version of Dolt , the world's first and only version-controlled SQL database. We are planning a public Beta launch of Doltrgres in the first quarter of 2025 , and one of the most...
Read More - REFERENCE7 min read
What's up with all these Hashes?
When you are using Dolt, you'll come across a lot of 32 character random strings like k0j5gejn5ebnoqa3jr4pdkb6etbbrfri . For instance, each entry in your Dolt log has one. $ dolt log -n 3 commit o9vdhp8fj78nhoa2ul9fm5s7nkks5ovv ( HEA...
Read More - SQL4 min read
fmt.Sprintf vs String Concat
String concatenation isn't the most elegant looking code: getFieldName := gf . tableName + "+" + gf . ColName But it's quite a bit faster than fmt.Sprintf , which arguably looks more organized: getFieldName := fmt ....
Read More - DOLTGRESSQL6 min read
Doltgres Now Supports Users
We're continuing to make progress on DoltgreSQL , which is a version of Dolt built to be a drop-in replacement for PostgreSQL. Dolt , is a MySQL compatible database is built from the ground up with Git-influenced version control features. Th...
Read More - 7 min read
Building at Scale, Amazon style
A couple weeks ago, I discussed how Amazon was migrated to Git , and I mentioned the Brazil build system briefly. Brazil is a specialized version control system, which, in the past, was built on top of a SQL database. Today I'll talk a little ...
Read More - TECHNICAL15 min read
Multi-Source Replication From Dolt to MySQL
One of MySQL's greatest features is its robust replication support. MySQL replication provides scalability, reliability, and high availability benefits for MySQL-based systems and is extremely widely used in production deployments of MySQL. Here...
Read More - REFERENCE10 min read
An Ooey GUI Guide to Using Dolt
Dolt is inspired by Git and MySQL, two deeply command-line oriented software programs. Thus, Dolt started as a command line utility, matching almost all of Git's capabilities . We then added a MySQL-compatible server component so you could connec...
Read More - INTEGRATION6 min read
Use Dolt With MySQL Connector in Python
Dolt is a version controlled MySQL compatible database. It means you can commit, diff and merge along with other Git-like version control actions. You can use Dolt with most workbenches, ORMs and SQL connectors that are available on the Internet....
Read More - 10 min read
Sleuthing resource leaks in Dolt
Recently, users running SQL queries against their databases hosted on DoltHub has led us to uncovering some really interesting bugs in Dolt itself. In today's post, I'll take you on a journey as I recount our investigation of these bugs, and ...
Read More - REFERENCE3 min read
Dolt Roadmap update
Introduction At DoltHub, we ship features, a lot. We fix bugs in 24 hours , but we also have a lot of long-term projects we're working on at any given time. We keep track of these goals on our roadmap , which just got its periodic update ...
Read More - WORKBENCH2 min read
How to Publish a Microsoft Windows Application
We recently released the Dolt Workbench desktop application for both Mac and Windows . In our previous blog , we covered how to submit an Electron application to the Mac App store. Now, we will guide you through the process of publishing ...
Read More - REFERENCE13 min read
Anatomy of a Dolt Database
While writing about how to tune Dolt for large databases , it dawned on me that we don't have documentation on the internal file structure of a Dolt database. What does Dolt look like on the inside? Let's dissect a database and find out. ...
Read More - GOLANG4 min read
A Useful Pattern for Nil Channel Values in Go
At DoltHub we're building Dolt , a SQL database that supports Git-like version control, including branch, merge, diff, clone, push, and pull. Dolt is written in Go. This post is part of a series of blog posts about programming in Go . I f...
Read More - SQL4 min read
Automatic Statistics
DoltDB is the first relational database that supports Git-like version control primitives like branch , diff , and merge . All our versioning features exist alongside full MySQL compatibility and near MySQL latency parity . The latest re...
Read More