1. 11 min read

    So you want an AI Database?

    Tim Sehn|

    Here at DoltHub, we built the world's first version-controlled SQL database: Dolt. What do version control and databases have to do with Artificial Intelligence (AI)? It turns out, a lot. At first, we were skeptical about the AI revolution, but then...

    Read More
0 matching articles.
  1. 7 min read

    Costing Index Scans

    Max Hoffman

    Dolt is the first version controlled SQL database. We have made many correctness and performance improvements over the last couple of years. But one of the things we have never been good at are queries that need to adapt to underlying table data. We ...

    Read More
    Max Hoffman
  2. 15 min read

    Hibernate on Dolt, A Sample App

    Neil Macneale

    Leverage Hibernate with Dolt for fun and science

    Read More
    Neil Macneale
  3. 8 min read

    Getting stack traces for errors in Go

    Zach Musgrave

    Techniques and libraries for getting stack traces for your errors in Go

    Read More
    Zach Musgrave
  4. 7 min read

    Building Single Sign-On for your Web Application

    Taylor Bantle

    We recently released single sign-on (SSO) for two of our web products, Hosted Dolt and DoltLab Enterprise. Administrators can configure an Identity Provider (IdP), where their users can authenticate and authorize access to their organization (Hosted)...

    Read More
    Taylor Bantle
  5. 8 min read

    Sensible User Privileges and Dolt Procedures

    Neil Macneale

    Keeping your version controlled data safe just got easier

    Read More
    Neil Macneale
  6. 4 min read

    Virtual column support in Dolt

    Zach Musgrave

    Announcing support for virtual columns in Dolt

    Read More
    Zach Musgrave
  7. 4 min read

    Announcing DoltgreSQL

    Daylon Wilkins

    We are pleased to announce that we have started development on DoltgreSQL! Dolt has grown significantly over the past few years, however it uses MySQL's syntax. Many users have asked us if we would support PostgreSQL's syntax, and we are finally deve...

    Read More
    Daylon Wilkins
  8. 6 min read

    Announcing DoltLab Enterprise Edition

    Dustin Brown

    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 improved DoltL...

    Read More
    Dustin Brown
  9. 8 min read

    AUTO_INCREMENT vs UUID Primary Keys

    Tim Sehn

    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 recommended alternat...

    Read More
    Tim Sehn
  10. 15 min read

    Getting Started: Dolt with Docker

    Tim Sehn

    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 the directory yo...

    Read More
    Tim Sehn
  11. 13 min read

    Transactions in Dolt? Hold My Beer

    Neil Macneale

    Dolt is a drop in replacement for MySQL, but beware because transactions behave differently

    Read More
    Neil Macneale
  12. 11 min read

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

    Nick Tobey

    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 surprisi...

    Read More
    Nick Tobey
  13. 7 min read

    Recovering Dropped Databases with dolt_undrop()

    Jason Fulghum

    The new dolt_undrop() stored procedure allows you to easily restore dropped databases

    Read More
    Jason Fulghum
  14. 4 min read

    Pull Request Diff Comments

    Liu Liu

    After you open a pull request in a database, users can comment on the comparison of table cells between the two specified branches.

    Read More
    Liu Liu
  15. 9 min read

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

    Zach Musgrave

    Fixing a bug in Dolt that MySQL still has and will not fix

    Read More
    Zach Musgrave
  16. 16 min read

    Four 9's of Correctness

    Nick Tobey

    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 different SQL ...

    Read More
    Nick Tobey
  17. 7 min read

    Why SQL?

    Tim Sehn

    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 <bleep> Oracle l...

    Read More
    Tim Sehn
  18. 6 min read

    How to Use Lateral Joins

    Max Hoffman

    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.0 -u root. T...

    Read More
    Max Hoffman
  19. 10 min read

    Replication Updates

    Brian Hendriks

    Dolt now supports replicated permissions, database drops

    Read More
    Brian Hendriks
  20. 7 min read

    Announcing: Scheduled Events

    Jason Fulghum

    Dolt now supports creating and executing MySQL Scheduled Events.

    Read More
    Jason Fulghum