1. REFERENCE
    13 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
  1. BOUNTY
    8 min read

    Where is dynamite hidden in the US housing market?

    I'm currently staring at what I think might be the biggest open database of housing sales records ever. It's 50GB of uncut housing sales records straight from the government coffers. Tens of millions of them. Good chance to dig around and play with a…

    Read More
  2. SQL
    9 min read

    Dolt Diff Magic: Part 2 – Viewing data diffs

    Welcome back to the second post in this blog series exploring the magic that makes Dolt so unique and powerful. Dolt DB is a MySQL-compliant SQL database that also provides the distributed versioning features of Git. The result is a powerful database…

    Read More
  3. WEBFEATURE RELEASE
    2 min read

    Your Database Can Now Be Downloaded As CSVs

    For those new to Dolt and DoltHub, Dolt is Git for data. Git versions files. Dolt versions SQL tables. DoltHub is a place on the internet to share Dolt databases. Recently we received a feature request from one of our customers asking us to support…

    Read More
  4. SQL
    8 min read

    Schema Versioning Puzzle: A Three Part Act

    Today we're going to discuss a series of schema bugs discovered in our version-controlled database, Dolt. It manifested in three related ways, from the display layer, into the storage layer, and finally the execution engine. We will unravel the…

    Read More
  5. VIDEO
    2 min read

    Dolt, The Easy Database

    What Makes Dolt Easy? We think one of the big advantages of Dolt is that it can be downloaded and running on your machine in under a minute. Maybe a little bit longer when you set up your DoltHub login so you can push or pull from DoltHub. This…

    Read More
  6. RELEASE
    3 min read

    Announcing DoltLab v0.3.1

    Download the latest DoltLab here and head over to https://docs.dolthub.com/guides/doltlab for the latest documentation Today we are excited to announce the release of DoltLab v0.3.1, the product that lets you self-host your own DoltHub! Hopefully you've been following along with our DoltLab announcements and related blog posts, but if this is your first time hearing…

    Read More
  7. TECHNICALGOLANG
    11 min read

    Generics and Value Types in Golang

    Go 1.18 has been released and along with it comes long-awaited support for Generics! Generics are the most significant change to the language in years. They add a new dimension to what is otherwise a minimalist type system. From the very beginning…

    Read More
  8. SQL
    4 min read

    Dolt and SQLAlchemy: A tale of growth

    Introduction We have been working hard towards making Dolt a production-grade, MySQL compatible database. Last year, we discussed MySQL compatibility in the form of SQLLogictests where we hit 99% correctness. Now, we are very focused on compatibility…

    Read More
  9. REFERENCE
    6 min read

    Have Postgres. Want Dolt.

    Dolt is the first version controlled SQL database. DoltHub is a place on the internet to share Dolt databases. DoltLab is a self-hosted version of DoltHub. Dolt brings Git-style version control to the relational database. Dolt supports the MySQL wire protocol and thus MySQL flavored SQL. PostgreSQL (or Postgres for short) is another popular open source SQL database with a different wire protocol and SQL flavor. If you have a Postgres…

    Read More
  10. VIDEO
    1 min read

    What Can You Do with a Version Control Database?

    Version Control your Existing Database One of the best use cases to get started using Dolt is to version control your existing database in Dolt. This is additive to your existing environment and won't require changes to your existing infrastructure…

    Read More
  11. SQL
    11 min read

    Dolt Diff Magic: Part 1 – The dolt_diff system table

    Here at DoltHub, we’re building Dolt DB – a new type of distributed, versioned database that gives you all the power and expressivity of a SQL relational database, combined with the ability to time travel through your data to understand exactly when…

    Read More
  12. USE CASE
    9 min read

    A Database of One's Own

    The software development world vs. the database admin world Why is the way we make changes to software so different from the way we make changes to databases? It's impossible not to notice. In one world we have source control and a whole…

    Read More
  13. REFERENCE
    8 min read

    So you Want an Immutable Database?

    Immutable databases offer history and audit to your database. Immutable databases are becoming a popular alternative to blockchain. No survey of the category exists. This blog attempts to explain what an immutable database is, why you might want to…

    Read More
  14. WEB
    12 min read

    Migrating our Monorepo to Yarn 2

    DoltHub is a web-based UI built in React to share, discover, and collaborate on Dolt databases. We recently migrated our monorepo to Yarn 2 (or Yarn Modern). It took us some extra steps to make Yarn 2 work with our monorepo and other infrastructure…

    Read More
  15. VIDEO
    1 min read

    Version Control your Database with Dolt

    One of the best use cases to get started using Dolt is to version control your existing database in Dolt. This is going to be very additive to your existing environment and won't require changes to your existing infrastructure. Once you have stored…

    Read More
  16. 15 min read

    Deploying a Production Ready DoltLab Instance, An Example

    This year we launched DoltLab the self-hosted version of DoltHub. In February, we released the latest version of DoltLab, version v0.2.0, which included a number of features and bug fixes. We are actively working on DoltLab's next release which is focused…

    Read More
  17. SQL
    3 min read

    Improving Dolt's First Hour Experience

    Introduction Dolt is on its way to becoming a production grade version-controlled MySQL database. Most developers associate "production grade" software with performance, but to us, it includes user experience (UX). Our current UX challenge is getting…

    Read More
  18. BOUNTY
    10 min read

    What did we learn from our housing prices home run?

    About this bounty For our latest bounty we've been pretty ambitious. We asked our community to go out and scrape as many housing sales records as they can find, and after the bounty finished, we topped out at 50 GB of sales data. That is a lot of…

    Read More
  19. TECHNICALGOLANG
    10 min read

    Debugging strange http.Response Read() behavior in Golang

    With Dolt, you can push and pull a local MySQL compatible database to and from a remote. Remotes can be managed with the dolt remote CLI command and it supports many types of remotes. You can use a separate directory as a Dolt remote, an s3 bucket, or any grpc service…

    Read More
  20. USE CASE
    5 min read

    Dolt for Military Applications

    If any of you are like me, you've been distracted for the past couple weeks with the Russian invasion of Ukraine. This event has fundamentally changed the perspectives of many in the world. I foresee a bigger focus and investment on defense in the…

    Read More
JOIN THE DATA EVOLUTION

Get started with Dolt

Or join our mailing list to get product updates.