- 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
- SQLFEATURE RELEASE7 min read
Announcing: Scheduled Events
We're excited to announce support for executing scheduled events on a Dolt sql-server! Scheduled Events is a MySQL feature that lets you define SQL statements that run on a set schedule. You can think of it as the SQL server equivalent of cron j...
Read More - GOLANG9 min read
Using AWS Lambda with Golang to Generate On-call Calendars
We love developing in Go here at DoltHub. Our core product is DoltDB – an open-source, versioned, relational database that combines Git's distributed versioning features with all the power and expressiveness of a SQL database. Dolt is built from...
Read More - INTEGRATION20 min read
Getting Started with Dolt and Knex.js
Dolt is the world's first version controlled SQL database . Dolt is MySQL-compatible so all the tools you use with MySQL work the same way with Dolt, including Knex.js (which is surprisingly pronounced /k'nex/ instead of /nex/ - Tim wo...
Read More - REFERENCE8 min read
Python `autocommit` Off By Default
The snake doesn't like to commit. In Python autocommit is off by default in the Database API . This is different than other standard database connectors like ODBC and JDBC. Most common databases have autocommit on by default including SQL...
Read More - TECHNICAL10 min read
Running an open-source project Discord server
We are writing Dolt , the world's first and only version-controlled SQL database. It's free and open source software, and we've been using Discord to connect with our users for a little over 3 years. This blog is about why we picked Discord an...
Read More - FEATURE RELEASESQL5 min read
Reannouncing Dolt Query Diff
A couple years ago, we announced a version of query-diff . The feature always made us nervous. Dolt's storage engine promises fast diff based on content-addressed prolly trees . However, query-diff doesn't take advantage of Prolly trees; ra...
Read More - BOUNTY7 min read
Bye Bye Data Bounties
We're saying Good Bye to one of DoltHub 's most unique experiments, Data Bounties . DoltHub started with a data marketplace mission. Data Bounties were our best idea to bootstrap a virtuous cycle between data producers and data consumers. Da...
Read More - REFERENCEINTEGRATION11 min read
Dolt + Google Sheets
Dolt , DoltHub , and Hosted Dolt can be used for Spreadsheet Version Control . Many of our customers migrated to Dolt from a really complicated, heavily edited spreadsheet . I first tested Dolt against Google Sheets in fall of 2020 wor...
Read More - HOSTEDWEB3 min read
Single Sign-On for your organizations on Hosted Dolt
Hosted DoltDB is for running online, production Dolt databases. We recently received a feature request for SAML integration for a single sign-on (SSO) solution to hosted.doltdb.com , which is available now! What is SAML? SAML (...
Read More - SQL9 min read
Will it merge?
Dolt DB is the world's first fully-versioned SQL relational database. It allows you to track the history of your data in every row and every column of all your tables. In the same way that Git enables you to branch, merge, fork, and diff your sou...
Read More - GOLANG9 min read
Much Ado About Nil Things: More Go Pitfalls
Previously, I wrote an article about pitfalls befouling Go newcomers. These were each lessons that I personally learned while working on go-mysql-server , a drop-in replacement for MySQL written entirely in Go. We made it to be the best pure-G...
Read More - SQL3 min read
Three 9's of Correctness
Dolt is a SQL database with a custom storage layer designed for Git semantics. Dolt supports fast branching, diffing, and merging, plus all of the features MySQL provides. One of the ways we track our compatibility with MySQL are sqllogictests...
Read More - FEATURE RELEASECOMMAND LINE4 min read
Introducing Dolt Profiles
Dolt's CLI has been getting a bit of a revamp recently. With more CLI commands migrated to use SQL to retrieve results, it's easier than ever to access your remote data this way. Our most recently migrated command is dolt log ! $ dolt -...
Read More - 13 min read
How to create automated paging and on-call at your startup
For growing software startups offering online products and services, there comes a time when having on-call engineers becomes a necessity. As customers and service level agreements begin to increase, someone needs to always be available to address…...
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