Blog

Improving engine performance is like solving a murder mystery.

How to write and debug yacc parsers in golang

Today, we are proud to announce the initial release of Full-Text indexes! This is very important for us, as Dolt is a drop-in replacement for MySQL, that gives you all the versioning features that you're used…

While cleaning our hospital price database, I learned that GPT-4's function calling could quickly crack one of our hardest nuts. The context Since 2021, hospitals have been required to publish tables of:…

Dolt commands can now connect to remote servers allowing for git like feel for shared servers

Dolt is the first SQL database that branches, diffs, and merges data the way Git version controls text. We expected versioning data to be different than versioning code. But as the first database with struct…

Announcement of European deployment regions for hosted Dolt.

A 2023 update on Dolt for Postgres users. Dolt works with the Postgres mysql_fdw. We're getting started on a Postgres-flavored Dolt named Doltgres.

A demonstration, complete with sample code, on how to use SQLAlchemy with Dolt, the world's first version controlled SQL database.

Explore the new feature in our documentation that allows users to execute queries and interact with DoltHub databases without leaving the page.

Go 1.21RC2 is out and there's a bunch of small, but helpful new features and changes that are worth learning

In June of this year we released DoltLab v1.0.0 which uses Dolt as its default application database instead of PostgreSQL, providing out-of-the-box, version-controlled data for all of our DoltLab customers. …

The Hosted Dolt SQL workbench now supports CSV file uploads and exporting SQL query results as a CSV.

I'm staring down 400M rows of hospital prices that, to my knowledge, haven't been seen before by the public. At least not all in one place, and definitely not by someone like me, who's more used to avoiding me…

Explains what an air gapped network is, where they are generally deployed, and some tools to make managing the software and data inside them easier

Dolt was originally designed as a standalone CLI tool for supporting distributed asynchronous data sharing with the same primitives as Git. But we are now a database company. We still support data sharing wi…

Understand slowly changing dimension definitions, methods, and tools. Outlines the business benefits of using slowly changing dimension for database versioning. Introduces Dolt, the first SQL database with bui…

The `@@dolt_transaction_commit` system variable turns all SQL commits into Dolt commits, enabling you to have a versioned history of your data without having to explicitly call dolt_commit().

Runtime costs and strategies for static initialization in Go

The database is the heart of most applications. It's where the data that drives your web applications lives. It's where your users' data is stored. The data in your database may be used in countless ways such…