- 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
- USE CASE6 min read
Dolt for Drone Surveillance
Here at DoltHub we believe in military and intelligence applications of Dolt . Harpoon Ventures , a venture capital firm that helps companies like ours get connected with the US military, invested in our last round of financing. In-Q-Te...
Read More - REFERENCE3 min read
Dolt Replication Options
Dolt is the world's first and only version controlled SQL database . An important feature of modern databases is replication: enabling writes to multiple database instances. Replication is used for scalability, performance, and disaster recover...
Read More - GOLANG9 min read
Testing Go Applications Using Dolt
Testing database logic, and applications that use databases can be difficult. In order to do it properly every test that is run needs to be run against a clean database. This is because tests can leave the database in an unknown state, and cause…
Read More - INTEGRATION13 min read
XCA on Dolt
Dolt is the world's first fully-versioned SQL relational database. It allows you to track the full history of the data in every row and every column of all your tables. Although Dolt doesn't share any code with MySQL, it is MySQL-compatible – meani...
Read More - WEBUSE CASE9 min read
Designing a Pull Request Workflow in React
Dolt is Git for data . One of the most useful Git features is the ability to create pull requests, see their diff, and merge them from the browser. Both DoltHub ( GitHub for Dolt ) and the SQL workbench on Hosted Dolt ( AWS RDS fo...
Read More - GOLANG8 min read
Avoiding Pitfalls in Go
Go is relatively young, as far as programming languages go; it will be 14 years old this November. For comparison, C++, which Go directly competes with in the space of compiled general-purpose programming languages, is 38. Go brings a lot of e...
Read More - REFERENCETECHNICALGOLANG10 min read
Implementing Full-Text Indexes
A few weeks ago, we announced our initial implementation of Full-Text indexes . Dolt uses a bespoke SQL engine , which allows us to have a Git-influenced versioned database with the performance that would be expected of a production-rea...
Read More - FEATURE RELEASEWEB4 min read
Fine-Grained Permissions and Enhanced DoltHub API
For those of you that are new, Dolt is a database that supports Git-style versioning. DoltHub is a place on the internet to share and collaborate on Dolt databases. We are excited to introduce a great enhancement to DoltHub , offering you e...
Read More - TECHNICAL14 min read
Designing a Coherent Product
All software is terrible, as we all know. But some software is more terrible than others. Why is that? What is the property that makes some software frustrating or confusing to use? And more importantly, what i...
Read More - REFERENCE12 min read
So you want a Temporal Database?
When I was writing my opus on Slowly Changing Dimension , I came across the term "temporal database" . I had not heard of a "temporal database" before. I had heard of "temporal tables" but not a "temporal database". After doing a bit of researc...
Read More - INTEGRATION10 min read
WordPress on Dolt
Here at DoltHub, we strive to ensure the Dolt database can be a drop in replacement for MySQL . There are almost 3 decades of development on MySQL, and we occasionally hear that we are crazy to attempt a full re-write. We're fine being called cra...
Read More - USE CASEHOSTED7 min read
The RGD Stack: An Example Inspired by the Hosted Dolt Workbench
Welcome to the RGD (React + GraphQL + Dolt) stack! As Dolt , the world's first version controlled database, has grown from a better way to share data to a MySQL-compatible OLTP SQL database with Git fea...
Read More - TECHNICALSQL15 min read
Dolt Noir: Solving Performance Mysteries
Dolt is a MySQL-compatible server with Git-style version control. Users want to use Dolt as a drop-in replacement for MySQL or as a replica for their MySQL database. For this to work, we need to be correct : all user queries should have t...
Read More - GOLANG10 min read
Writing yacc parsers with golang: tips and tricks
This article discusses the technical details of writing yacc grammars / parsers using the goyacc tool. It's part of our our technical Golang blog series. We publish a new article in the series every 3 weeks. We're writing Dolt , a version-con...
Read More - FEATURE RELEASE5 min read
Announcing Full-Text Indexes
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 to from Git . As we're developin...
Read More - BOUNTY6 min read
GPT-4 function calling can label messy hospital price data
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: billing codes, representin...
Read More - COMMAND LINEHOSTED6 min read
Dolt CLI Discovers the Network
Git for Data is at the root of DoltHub's DNA, and we believe that the Dolt Command Line Interface (CLI) should behave similarly to git. People familiar with git sit down to use the Dolt CLI, and it's impossible to miss the similarities. Data is n...
Read More - TECHNICAL7 min read
Data Merge is Different
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 structural sharing at the storage layer, Dolt i...
Read More - HOSTED1 min read
Hosted Dolt Launches European Deployment Regions
Introduction We are excited to announce that Hosted Dolt , the fully managed SQL database with Git-style versioning, has expanded its offering to include European regions on multiple cloud platforms. With this expansion, Hosted Dolt user...
Read More - REFERENCEDOLTGRES5 min read
Have Postgres. Want Dolt. 2023 Edition.
Note: We released a Postgres version of Dolt called DoltgreSQL . It's been over a year since I published the original Have Postgres. Want Dolt. article. Interest in a Postgres-flavored version of Dolt has not waned. On average, about o...
Read More