Using SQL Alchemy to create backups in Dolt

Dolt is a version controlled SQL database. It behaves like a traditional relational database in that it offers a SQL interface for data and… | Continue reading


@dolthub.com | 3 years ago

Show HN: Dolthub SQL API

Dolt is Git for data, a relational database built to create, publish and consume datasets. DoltHub hosts a growing collection of public… | Continue reading


@dolthub.com | 3 years ago

Using Cypress to testing our Next.js web app

Dolt is Git for data and DoltHub is our web application that houses Dolt repositories. At the beginning of Dolt, we adopted Bash Automated… | Continue reading


@dolthub.com | 3 years ago

The Anatomy of Open Data Projects

A core motivation for building DoltHub was to empower organizations to collaboratively create and maintain high quality data assets that… | Continue reading


@dolthub.com | 3 years ago

Username and Password Login on DoltHub

DoltHub is a web application for hosting and collaborating on Dolt repositories. Until now, DoltHub has only supported creating accounts and… | Continue reading


@dolthub.com | 3 years ago

Foreign Keys in a Versioned Database?

Dolt is a SQL database with Git-style versioning.With each new version of Dolt, we increase the number of supported SQL features, moving… | Continue reading


@dolthub.com | 3 years ago

Diff Queries Between Database Commits

Dolt is a SQL database built to wrangle datasets. Its tables are versioned, queryable, and shareable. We've recreated Git's functionality… | Continue reading


@dolthub.com | 3 years ago

How and why we rewrote our SQL engine's integration tests with harnesses

Introduction Dolt is Git for Data, and its built-in SQLengine is an open source project we recently adopted,go-mysql-server.The engine is… | Continue reading


@dolthub.com | 3 years ago

Cell History Inspection on DoltHub

Dolt and DoltHub are Git and GitHub for data. Having a versioned database makes collaborating on data more fluid and reliable in the same… | Continue reading


@dolthub.com | 3 years ago

We implemented secondary indexes in Dolt, our version controlled database

Dolt is a SQL database with Git-style versioning. We're constantly adding new and exciting SQL features, and secondary indexes are one of… | Continue reading


@dolthub.com | 3 years ago

APIs suck for sharing data on the Internet

Application Programming Interfaces (APIs) are the dominant mode of distributing data on the internet. Twitter debates in the data science… | Continue reading


@dolthub.com | 3 years ago

GraphQL Saved Us from the gRPC Dumpster Fire We Created

DoltHub is the online data community powered byDolt, the version-controlled SQL database. In theprevious article in thisseries, we took… | Continue reading


@dolthub.com | 3 years ago

Which companies received Covid Stimulus in SQL form

Continue reading


@dolthub.com | 3 years ago

Dolt, a SQL database with Git-like features, shares storage across commits

Dolt is a SQL database thatprovides Git-like functionality, including clone, push, pull, branch,and merge. This post is part of a series… | Continue reading


@dolthub.com | 3 years ago

Using a versioned database to manage your train/test splits

Twitter is wonderful sometimes. We don't know Aaron. He finds us on Twitter, asks a great question, makes us think, and prompts a blog… | Continue reading


@dolthub.com | 3 years ago

Getting Multiple Datasets and Joining Them

In our blogs we have shown over and over again how easy it is to clone data from DoltHub and immediatelystart querying it with SQL. We are… | Continue reading


@dolthub.com | 4 years ago

We are adopting go-MySQL-server, SQL execution engine that powers Dolt

go-mysql-server isthe SQL query execution engine that powersDolt andDoltHub. Today we are excited to announce thatwe are adopting the… | Continue reading


@dolthub.com | 4 years ago

Using “Git for data” to find and analyze test regressions

Dolt is Git for data. It's adatabase that lets you clone, fork, branch, merge and diff. This is areally cool technology that has a lot of… | Continue reading


@dolthub.com | 4 years ago

CVE Database in a Git-Like Repository

TLDR: The NVD is a lot more useful when you can simply clone it and query it. The National Vulnerability Database (NVD) is the… | Continue reading


@dolthub.com | 4 years ago

Python profanity filter uses most up to date bad words dataset on the internet

Dolt is to DoltHub as Git is to GitHub - except with Dolt, the unit of versioning is SQL tables. Dolt also has Git-like semantics such as… | Continue reading


@dolthub.com | 4 years ago

We implemented MySQL types in Dolt

When we started on Dolt, our goal was to apply Git's idea of versioning to data. Whereas Git versions files, Dolt versions tables. As the… | Continue reading


@dolthub.com | 4 years ago

Coronavirus State Actions Dataset

As COVID-19 continues to affect the lives of millions of people around the world, having the most recent and accurate information is an… | Continue reading


@dolthub.com | 4 years ago

Continuous Integration for Data with DoltHub Webhooks

Dolt and DoltHub are Git and GitHub for data. The same way that GitHub enables collaboration on source code repositories in Git format… | Continue reading


@dolthub.com | 4 years ago

Tracking SQL Correctness and Performance Regressions in Dolt

Tracking Dolt's SQL regressions As part of our journey to make Dolt a great SQL database, we set out to track the correctness of Dolt’s SQL… | Continue reading


@dolthub.com | 4 years ago

Dolt for Git Noobs

TL;DR Dolt is a SQL database with built-in Git versioning, branching, and distribution semantics that makes collaborating on and… | Continue reading


@dolthub.com | 4 years ago

How Dolt, a SQL database with Git-like functionality, stores table data

Dolt is Git for data. It's aSQL database that lets you clone, branch, diff, merge, and fork yourdata just like you can with a filesystem… | Continue reading


@dolthub.com | 4 years ago

Dolt is Git for data

Dolt is Git for data. Instead of versioning files, Dolt versions tables. DoltHub is a place on the internet to share Dolt repositories. As… | Continue reading


@dolthub.com | 4 years ago

Testing Dolt using BATS (Bash Automated Testing System)

We adopted Bash Automated Testing System (Bats) to test the Dolt command-line. As of March 10, 2020 we are up to 473 tests, though 55 are… | Continue reading


@dolthub.com | 4 years ago

Implementing AS OF clauses with Git refs (HEAD~) in our open-source database

Dolt is Git for data. It's aSQL database that lets you branch, merge, and fork your data just likeyou would a Git repository. In previous… | Continue reading


@dolthub.com | 4 years ago

Assembled the most comprehensive open individual Novel Coronavirus case dataset

On Saturday, February 29, this transpired in our company chat room: A project was born. We had time series data for confirmed cases, deaths… | Continue reading


@dolthub.com | 4 years ago

So you want Git for data

People have been asking for a Git and GitHub for data for a while. That thread on Stack Exchange is almost seven years old and is the number… | Continue reading


@dolthub.com | 4 years ago

Optimized Map Iteration for Custom SQL Engine

In this blog post I want to give an introduction to some core concepts used to implement fast querying of databases.These techniques were… | Continue reading


@dolthub.com | 4 years ago

Visualizing 70 years of temperature data at 236 stations around the world

In the first part of this two part blog Icovered NOAA's "Global Hourly Surface Data" dataset and how it ismodeled in Dolt. Dolt is git for… | Continue reading


@dolthub.com | 4 years ago

120 years of NOAA's global hourly surface data in an easily queryable format

The National Oceanic and Atmospheric Administration, NOAA, publishes weather measurements taken from stations around theworld. It started… | Continue reading


@dolthub.com | 4 years ago

How we implemented indexed joins in our custom SQL engine

Happy Valentines Day from all of us at DoltHub!You are the reason we do what we do! In honor of the holiday, we want to talk about how… | Continue reading


@dolthub.com | 4 years ago

Mapping Income Inequality in the US Using IRS SOI Data

In a previous blog I showed how the historyof a dataset can be queried using the dolt history tables, and in the first part of this 2 part… | Continue reading


@dolthub.com | 4 years ago

Query the diffs in your data, and track how it changes over time with Dolt

When we started developing Dolt our vision was to deliver git functionality for data. Where git versions files, Dolt versions tables. We… | Continue reading


@dolthub.com | 4 years ago

Dolt. Git for data. Announcing private beta

Dolt and DoltHub let users collaborate on databases in the same way they collaborate on source code. Dolt is a relational database combined with the version control concepts of Git. DoltHub provides a central place to store and share data in Dolt format. | Continue reading


@dolthub.com | 4 years ago