- 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
- VIDEO1 min read
What Can You Do with a Version Control Database?
Version Control your Existing Database One of the best use cases to get started using Dolt is to version control your existing database in Dolt. This is additive to your existing environment and won't require changes to your existing in...
Read More - SQL9 min read
Dolt Diff Magic: Part 1 – The dolt_diff system table
Here at DoltHub, we’re building Dolt DB – a new type of distributed, versioned database that gives you all the power and expressivity of a SQL relational database, combined with the ability to time travel through your data to understand exactly ...
Read More - USE CASE7 min read
A Database of One's Own
The software development world vs. the database admin world Why is the way we make changes to software so different from the way we make changes to databases? It's impossible not to notice. In one world we have source control and a whole…
Read More - REFERENCE5 min read
So you Want an Immutable Database?
Immutable databases offer history and audit to your database. Immutable databases are becoming a popular alternative to blockchain. No survey of the category exists. This blog attempts to explain what an immutable database is, why you might want to...
Read More - WEB9 min read
Migrating our Monorepo to Yarn 2
DoltHub is a web-based UI built in React to share, discover, and collaborate on Dolt databases. We recently migrated our monorepo to Yarn 2 (or Yarn Modern). It took us some extra steps to make Yarn 2 work with our monorepo and other infras...
Read More - VIDEO1 min read
Version Control your Database with Dolt
One of the best use cases to get started using Dolt is to version control your existing database in Dolt. This is going to be very additive to your existing environment and won't require changes to your existing infrastructure. Once you have sto...
Read More - DOLTLAB12 min read
Deploying a Production Ready DoltLab Instance, An Example
This year we launched DoltLab the self-hosted version of DoltHub . In February, we released the latest version of DoltLab , version v0.2.0 , which included a number of features and bug fixes. We are actively working on DoltLab's next relea...
Read More - SQL2 min read
Improving Dolt's First Hour Experience
Introduction Dolt is on its way to becoming a production grade version-controlled MySQL database. Most developers associate "production grade" software with performance, but to us, it includes user experience (UX). Our current UX challenge is...
Read More - BOUNTY9 min read
What did we learn from our housing prices home run?
About this bounty For our latest bounty we've been pretty ambitious. We asked our community to go out and scrape as many housing sales records as they can find, and after the bounty finished, we topped out at 50 GB of sales data. That is a lo...
Read More - TECHNICALGOLANG8 min read
Debugging strange http.Response Read() behavior in Golang
With Dolt , you can push and pull a local MySQL compatible database to and from a remote. Remotes can be managed with the dolt remote CLI command and it supports many types of remotes . You can use a separate directory as a Dolt remote...
Read More - USE CASE4 min read
Dolt for Military Applications
If any of you are like me, you've been distracted for the past couple weeks with the Russian invasion of Ukraine. This event has fundamentally changed the perspectives of many in the world. I foresee a bigger focus and investment on defense in the…...
Read More - BOUNTY2 min read
US Housing Prices Bounty Retrospective
US Housing Prices Bounty Retrospective A year ago we launched DoltHub data bounties . If you're unfamiliar, we use Dolt to create open databases that don't exist anywhere else on the internet. We use Dolt's cell ancestry capability to fi...
Read More - VIDEO1 min read
Using Dolt with Tableplus
About At DoltHub we are laser focused on improving Dolt's UX across the database stack. A key part of this is integrating with SQL Editors that offer an elegant SQL reading and writing experience. Below is a video that teaches you how to s...
Read More - SQL4 min read
Eliminating SQL Engine Redundancies
We aim to make Dolt 100% MySQL compliant, but we are also committed to making Dolt fast. My colleagues are hard at work adding new optimizations to our storage layer — inlining functions, minimizing memory allocations, dovetailing cache locality…
Read More - TECHNICALGOLANG10 min read
Dolt Storage Layer Memory Optimizations and Pushing a 1TB Dolt Database
Dolt is an open-source version-controlled database. It lets you push and pull databases just like you can push and pull source code with git. You can make changes on a local clone, commit, and then dolt push them to a remote with a single CLI ...
Read More - DOLTLAB8 min read
DoltLab 101: Services Overview and 2022 Roadmap
We launched our latest product DoltLab earlier this year to provide users who don't want to push their data to the public internet a self-hosted DoltHub . Since DoltLab's launch, we've been working to make deploying and operating DoltLab sm...
Read More - VIDEO1 min read
Getting Started with Privileges Video
We recently landed users and privileges in Dolt. This video shows how to get started using them in your own database! If you need any additional help to get set up, or just want to chat, head over to our Discord !
Read More - VIDEODOLTLAB1 min read
Getting Started with DoltLab Video
We recently launched our latest product DoltLab , the self-hosted version of DoltHub . In the announcement blog I detailed the instructions for getting up and running with DoltLab on a Linux host and today's video demonstrates just how qu...
Read More - WEB4 min read
Lessons learned building mobile pages
For those new to Dolt and DoltHub , Dolt is Git for data. Git versions files. Dolt versions SQL tables. DoltHub is a place on the internet to share Dolt repositories. Just a bit of context We've been working on making DoltHub more mob...
Read More - BOUNTY2 min read
$15,000 US Hospital Price Transparency Bounty
At DoltHub we never like to go a day without a bounty. Having just wrapped up our US Housing Prices Bounty we announce without further ado... $15,0000 US Hospitals Bounty: "third time's the charm" If you haven't been following us, our ...
Read More