- 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
- 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 ...
Read More - REFERENCE5 min read
How We Benchmark Dolt
Dolt is a MySQL-compatible version-controlled database. It's the only SQL database with branches that you can diff, merge and sync. Performance has been a major focus of Dolt development over the past year, and we've made substantial progress on th...
Read More - BOUNTY3 min read
Data, Deaths, and the Damn Prison System
Steal this (note)book If you want to reproduce the charts from this notebook, clone this repository which has everything you need including the CSV files. The data comes from DoltHub's jails data bounty . Check it out. The data analysis ...
Read More - REFERENCE4 min read
So you want Database Forks?
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 us. Dolt is a lot of things. Dolt is a version controlled database , a Git database , Git for ...
Read More - FEATURE RELEASEDOLTLAB5 min read
DoltHub and DoltLab now support SQL uploads
Today we're excited to announce that DoltHub and DoltLab now support .sql file uploads. Prior to this change, users could only upload a .csv , .psv , .xlsx , or .json file using DoltHub and DoltLab's web UI. Although these are ...
Read More - INTEGRATION5 min read
Embedding Dolt in your Golang Application
Dolt is a version controlled database . When run as a server, Dolt is MySQL compatible, so you can connect to it with any MySQL tools or clients. Running Dolt as a server is perfect to back applications, just like you would with MySQL or Pos...
Read More - SQL4 min read
Benchmarking Dolt's Import Performance
Introduction If you want to work with a database, you probably want to get some data into it first. At DoltHub, we've spent a good chunk of time working on our table import feature which lets you import CSV, JSON, XLSX, and Parquet data...
Read More - TECHNICAL8 min read
Don't change your open-source database's storage engine
Want a technical challenge? Find an open source database and change its storage engine. You'll have to rewrite hundreds if not thousands of functions, validate your changes against test suites, and continuously ru...
Read More - FEATURE RELEASE1 min read
How to set up branch protection rules on DoltHub
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. Dolt has Git-like functionality, includ...
Read More - REFERENCE5 min read
So you want Spreadsheet Version Control?
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 us. Dolt is a lot of things. Dolt is a version controlled database , a Git database , Git for ...
Read More - HOSTEDREFERENCE6 min read
Sleepless in Seattle: Wake up with AWS Incident Manager
Dolt is a MySQL compatible database with Git like features. On May 18th, we launched Hosted Dolt , a cloud-hosted Dolt database with built-in logs and monitoring. If you're not familiar with Hosted Dolt, here ...
Read More - USE CASE8 min read
Dolt Case Studies
This is our annual update on how our customers are using Dolt, the world's first and only SQL database that you can branch and merge, fork and clone, push and pull just like a git repository. Last year's update included a lot more speculat...
Read More - SQL8 min read
Relational Database Design: A Step-By-Step Guide
Introduction As an engineer working on Dolt, I spend most of my time working on the internals of a database system. Recently, I worked on using Dolt as a product to create a dataset that stored the entire Bitcoin blockchain's history. As I...
Read More - 4 min read
Dolt now supports Column Statistics
Dolt is a version controlled database that combines the features of Git and functionality of MySQL. In this release, we added column statistics, getting us one step closer to MySQL's feature set. Our analyzer can utilize these statistics to improve...
Read More - BOUNTY6 min read
I analyzed 1835 hospital price lists so you didn't have to
I analyzed 1835 hospital price lists so you didn't have to. But if you're a data scientist, you can do it too! This article was written in part for python-centric data scientists and programmers, and comes with a follow-along notebook where w...
Read More - REFERENCE6 min read
Working with JSON in Dolt
Document databases like MongoDB rose to prominence because of their ability to store data in a hierarchical format like Javascript Object Notation, aka JSON . Some applications just make more sense when you persist the JSON your application is...
Read More - FEATURE RELEASE4 min read
Dolt now supports cherry-pick
Looking for a way to manage versions and work with history of your structured data? Dolt is a version controlled relational database that combines the version control features of Git with the relational database features of MySQL. Today, we're…
Read More - 7 min read
How to Chunk Your Database into a Merkle Tree
Dolt is a next-generation SQL database with Git-like version control features. It's the only SQL database with branches that you can diff , merge , and sync . The core of Dolt's data model is a Merkle Tree index called a Prolly Tree. Proll...
Read More - SQL9 min read
Grammar Crawler
Intro Testing a database management system is a challenging endeavor for many reasons. DBMSs are large, complex applications with a lot of focus on code optimization and performance. SQL syntax is sprawling, with lots of dark corners, no lack...
Read More - SQL3 min read
Importing MySQL Dumps to Dolt
Need version control on your existing database? Dolt is a SQL database that can replace your current database but gives you version control features just like Git. The easiest way to migrate a MySQL database is to dump and import to Dolt. We alw...
Read More