- 11 min read
So you want an AI Database?
Here at DoltHub, we built the world's first version-controlled SQL database: Dolt. What do version control and databases have to do with Artificial Intelligence (AI)? It turns out, a lot. At first, we were skeptical about the AI revolution, but then...
Read More
- 8 min read
Doltgres System Tables Update
As Doltgres is being rapidly developed, we needed Postgres-specific solutions to certain version control features that are implemented in Dolt. This blog walks through how we converted MySQL-flavored system tables in Dolt to Postgres-flavored system tables that account for different schemas and types in Doltgres.
Read More - 14 min read
What's Missing From Golang Generics?
Last time, I discussed a specific design problem that I encountered while writing generic code in Go, and how I eventually solved it. I was proud that I had found a solution, although less proud that it wasn't the cleanest. "I'm not proud of it. I a...
Read More - 5 min read
Dolt Configuration
Dolt configuration is a bit of a mess. To start, it's a union of Git and MySQL styles of configuration. Then, Dolt specific configuration is sprinkled on top. It's been on our list for a long time to consolidate and rationalize Dolt configuration wit...
Read More - 3 min read
Dolt SSL Authentication
Dolt is the world's first and only version controlled SQL database. Dolt is fully MySQL-compatible. You connect to it with any MySQL client. Some MySQL clients require connection authentication using Transport Layer Security (TLS). TLS is often refer...
Read More - 6 min read
Workbenches are Better with a Version Controlled Database
The Dolt Workbench illustrates how much better the workbench experience can be when using a version controlled database. Find out how and why in this blog.
Read More - 8 min read
Using Perl to Query Dolt Databases
Perl is still alive and well and works beautifully with Dolt databases.
Read More - 9 min read
Productionizing Dolt
So you've been using Dolt for a while, and you are ready to take the next step and use it in production. Whether you are running your production environment on prem, or in the cloud, there are several steps you should take to ensure that your Dolt da...
Read More - 6 min read
History independence, what it is and why it matters
Dolt is the world's first and only version-controlled SQL database. It's a SQL database that you can fork, clone, branch, merge, push and pull just like a Git repository. Like files in Git, tables and other data in Dolt are content-addressed by a cry...
Read More - 5 min read
Balancing Perf Trade-offs
I ran into a performance trade-off last week attempting to improve long-running queries by changing the ways rows are structured. A more general row interface increases memory overhead but lets us skip encoding overhead. Unfortunately, joins create s...
Read More - 11 min read
Are Golang Generics Simple or Incomplete? A Design Study
"Go is an incomplete language masquerading as a simple one." This comment on ycombinator lives rent-free in my head. Nothing before or since has captured my feelings on Go quite as succinctly. Take for instance, generics. Or its more precise name: ...
Read More - 7 min read
Designing CI on DoltHub
Get a glimpse into the design process for DoltHub's latest feature, continuous integration testing.
Read More - 6 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 collects so...
Read More - 5 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 Postgres. So ...
Read More - 14 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 also m...
Read More - 2 min read
DoltHub is HIPAA Compliant
DoltHub is HIPAA compliant. This blog will walk you through what HIPAA is, why it matters, and how we got certified.
Read More - 10 min read
Continuous integration testing on data
Continuous integration (CI) testing on data is now possible on DoltHub. Read more to learn how to add CI to your database today.
Read More - 7 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 t...
Read More - 7 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 Doltgres in the first quarter of 2025, and one of the most important m...
Read More - 7 min read
What's up with all these Hashes?
Dolt is the only content addressed SQL database. Dolt uses specific algorithms to generate immutable content addresses for most internal objects in your database. This article explains how that works and how you can access and use those content addresses.
Read More - 4 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.Sprintf("%s+%s", gf.tableName, gf.ColN...
Read More