1. REFERENCE
    9 min read

    So you want Database Versioning?

    Tim Sehn|

    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
Found 20 matching articles.
  1. FEATURE RELEASEDOLTLAB
    6 min read

    Announcing DoltLab Enterprise Edition

    We launched DoltLab , the self-hosted version of DoltHub.com back in January 2022 as a way to support users who wanted to harness the power of Dolt, but not push their data to the public internet. From that point on, we've consistently impr...

    Read More
  2. REFERENCE
    10 min read

    AUTO_INCREMENT vs UUID Primary Keys

    Dolt is the first and only version controlled SQL database . Dolt supports branches, merges, and clones. Astute Dolt users have long noticed that Dolt branches and clones do not play well with AUTO_INCREMENT primary keys. The Dolt recommende...

    Read More
  3. REFERENCE
    15 min read

    Getting Started: Dolt with Docker

    For a long time, Dolt resisted Docker . Here at DoltHub , we take a lot of pride in the fact that Dolt is a single program with no external dependencies. To use Dolt, you simply download the current build for your operating system, put th...

    Read More
  4. SQL
    12 min read

    Transactions in Dolt? Hold My Beer

    Here at DoltHub, we strive to ensure the Dolt database can be a drop in replacement for MySQL . We've written a lot about this , and this particular post continues this tradition. The tool of this round is called FusionAuth , which is a...

    Read More
  5. GOLANG
    10 min read

    They're called Slices because they have Sharp Edges: Even More Go Pitfalls

    On my last Golang post , I suggested that the main source of confusion in Golang is the fact that the language presents itself as a C-like object oriented language, and dresses itself in C-like syntax, while differing from C-like languages in…

    Read More
  6. FEATURE RELEASE
    6 min read

    Recovering Dropped Databases with dolt_undrop()

    DoltDB is the world's first fully-versioned relational database. It gives you the versioning semantics of Git with all the power and expressiveness of SQL. One of Dolt's greatest strengths is keeping your data safe. You can trace how every bit...

    Read More
  7. FEATURE RELEASEWEB
    3 min read

    Pull Request Diff Comments

    DoltHub is a place on the internet to share, discover, and collaborate on Dolt databases. We're committed to making data collaboration seamless and effective for you, which is why we're excited to share an exciting addition to our pull request...

    Read More
  8. 9 min read

    A bug in MySQL, or working as intended? You decide

    Introduction We're writing Dolt , the world's first version controlled SQL database. Dolt advertises itself as a drop-in replacement for MySQL, so if your current application works on MySQL you can swap in Dolt on the backend with no code c...

    Read More
  9. SQL
    17 min read

    Four 9's of Correctness

    sqllogictests is a collection of around 6 million sql correctness tests, designed to be used a as benchmark for SQL engine implementations. Although sqllogictests was made by the sqlite team, it can check for compatibility with several differ...

    Read More
  10. SQL
    6 min read

    Why SQL?

    In the mid-2000s SQL was having a rough time. NoSQL was all the rage. A chorus of senior engineers shouted: "SQL doesn't scale." "Oracle...Microsoft...waaaaaah! "DBAs are expensive and get in developer's way" "$10,000 per core for a...

    Read More
  11. SQLFEATURE RELEASE
    5 min read

    How to Use Lateral Joins

    Dolt is the first SQL database that versions data with Git semantics. Using Dolt is as easy as downloading the binary , picking a directory for your data ( mydb ), running dolt sql-server , and using a MySQL client to connect mysql -h 0.0.0....

    Read More
  12. FEATURE RELEASEHOSTED
    11 min read

    Replication Updates

    Dolt supports three types of replication : Remote-based replication launched October 2021 Standby replication launched October 2022 Replicate from MySQL to Dolt launched February 2023 Hosted Dolt launched read replicas in...

    Read More
  13. SQLFEATURE RELEASE
    7 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
  14. GOLANG
    9 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
  15. INTEGRATION
    20 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
  16. REFERENCE
    8 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
  17. TECHNICAL
    10 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
  18. FEATURE RELEASESQL
    5 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
  19. BOUNTY
    7 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
  20. REFERENCEINTEGRATION
    11 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
JOIN THE DATA EVOLUTION

Get started with Dolt

Or join our mailing list to get product updates.