- 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
- GOLANG10 min read
Writing yacc parsers with golang: tips and tricks
How to write and debug yacc parsers in golang
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
Dolt commands can now connect to remote servers allowing for git like feel for shared servers
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
Announcement of European deployment regions for hosted Dolt.
Read More - REFERENCEDOLTGRES5 min read
Have Postgres. Want Dolt. 2023 Edition.
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.
Read More - REFERENCE23 min read
Getting Started: SQLAlchemy and Dolt
A demonstration, complete with sample code, on how to use SQLAlchemy with Dolt, the world's first version controlled SQL database.
Read More - DOCSWEB3 min read
Embedded SQL Console in DoltHub's Documentation
Explore the new feature in our documentation that allows users to execute queries and interact with DoltHub databases without leaving the page.
Read More - GOLANG8 min read
Coming Soon: Golang 1.21 🚀
Go 1.21RC2 is out and there's a bunch of small, but helpful new features and changes that are worth learning
Read More - DOLTLAB6 min read
How to Run DoltLab on Hosted Dolt
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. Today, I'll cover how you can su...
Read More - FEATURE RELEASEHOSTED2 min read
CSV Support for the Hosted Dolt Workbench
The Hosted Dolt SQL workbench now supports CSV file uploads and exporting SQL query results as a CSV.
Read More - BOUNTY10 min read
How to use our hospital price database
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 medical bills than trying to make sense o...
Read More - USE CASE8 min read
Transferring Data In and Out of Air-Gapped Networks
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
Read More - SQL18 min read
Dolt Vs MySQL Vs Postgres
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 with Git semantics but increasingly in a…
Read More - REFERENCE21 min read
So you want Slowly Changing Dimension?
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 built in slowly changing dimension.
Read More - SQL10 min read
Automatic Dolt Commits with @@dolt_transaction_commit
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().
Read More - 14 min read
Initializing Large Static Maps in Go
Runtime costs and strategies for static initialization in Go
Read More - HOSTED4 min read
Running a Production Database
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 as analytics, machine learning, and…
Read More - 5 min read
The Future of the Dolt Command Line Interface
Dolt's Command Line Interface is being modernized to integrate better with our SQL Server. A little history, and a plan for the future.
Read More