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. REFERENCEDOLTGRES
    5 min read

    Have Postgres. Want Dolt. 2023 Edition.

    A 2023 update on Dolt for Postgres users. Dolt works with the Postgres mysql_fdw. We're getting started on a Postgres-flavored Dolt named Doltgres.

    Read More
  2. REFERENCE
    23 min read

    Getting Started: SQLAlchemy and Dolt

    A demonstration, complete with sample code, on how to use SQLAlchemy with Dolt, the world's first version controlled SQL database.

    Read More
  3. DOCSWEB
    3 min read

    Embedded SQL Console in DoltHub's Documentation

    Explore the new feature in our documentation that allows users to execute queries and interact with DoltHub databases without leaving the page.

    Read More
  4. GOLANG
    8 min read

    Coming Soon: Golang 1.21 🚀

    Go 1.21RC2 is out and there's a bunch of small, but helpful new features and changes that are worth learning

    Read More
  5. DOLTLAB
    6 min read

    How to Run DoltLab on Hosted Dolt

    In June of this year we released DoltLab v1.0.0 which uses Dolt as its default application database instead of PostgreSQL , providing out-of-the-box, version-controlled data for all of our DoltLab customers. Today, I'll cover how you can su...

    Read More
  6. FEATURE RELEASEHOSTED
    2 min read

    CSV Support for the Hosted Dolt Workbench

    The Hosted Dolt SQL workbench now supports CSV file uploads and exporting SQL query results as a CSV.

    Read More
  7. BOUNTY
    10 min read

    How to use our hospital price database

    I'm staring down 400M rows of hospital prices that, to my knowledge, haven't been seen before by the public. At least not all in one place, and definitely not by someone like me, who's more used to avoiding medical bills than trying to make sense o...

    Read More
  8. USE CASE
    8 min read

    Transferring Data In and Out of Air-Gapped Networks

    Explains what an air gapped network is, where they are generally deployed, and some tools to make managing the software and data inside them easier

    Read More
  9. SQL
    18 min read

    Dolt Vs MySQL Vs Postgres

    Dolt was originally designed as a standalone CLI tool for supporting distributed asynchronous data sharing with the same primitives as Git. But we are now a database company. We still support data sharing with Git semantics but increasingly in a…

    Read More
  10. REFERENCE
    21 min read

    So you want Slowly Changing Dimension?

    Understand slowly changing dimension definitions, methods, and tools. Outlines the business benefits of using slowly changing dimension for database versioning. Introduces Dolt, the first SQL database with built in slowly changing dimension.

    Read More
  11. SQL
    10 min read

    Automatic Dolt Commits with @@dolt_transaction_commit

    The `@@dolt_transaction_commit` system variable turns all SQL commits into Dolt commits, enabling you to have a versioned history of your data without having to explicitly call dolt_commit().

    Read More
  12. 14 min read

    Initializing Large Static Maps in Go

    Runtime costs and strategies for static initialization in Go

    Read More
  13. HOSTED
    4 min read

    Running a Production Database

    The database is the heart of most applications. It's where the data that drives your web applications lives. It's where your users' data is stored. The data in your database may be used in countless ways such as analytics, machine learning, and…

    Read More
  14. 5 min read

    The Future of the Dolt Command Line Interface

    Dolt's Command Line Interface is being modernized to integrate better with our SQL Server. A little history, and a plan for the future.

    Read More
  15. 8 min read

    MySQL Triggers: How and why with examples

    In this tutorial, learn how to define triggers in MySQL and what they're good for, with examples

    Read More
  16. 2 min read

    Better JSON Support

    In case you haven't heard, we're now Dolt 1.0 !. However, we're not finished. In this blog, we'll go over some recent improvements to Dolt's JSON handling. Additionally, I'll go through some examples of JSON handling to showcase the new functiona...

    Read More
  17. DOLTLAB
    5 min read

    Announcing DoltLab v1.0.0, now backed by Dolt

    In early May we announced Dolt v1.0.0 , the first stable release of Dolt, signaling that Dolt is ready for production use. Shortly thereafter we revealed that DoltHub.com now runs on Dolt. In my previous blog post I explain how we transitio...

    Read More
  18. REFERENCEGOLANG
    7 min read

    Replicating Unexpected Behavior

    I'm an engineer at DoltHub , and for the past month, I've been working on matching Dolt 's regular expression capabilities with MySQL. This is important for us, as Dolt is a drop-in replacement for MySQL, that gives you all the versioning ...

    Read More
  19. HOSTEDFEATURE RELEASE
    4 min read

    Hosted DoltDB Launches Replicas

    Dolt is Git for Data. It's a MySQL compatible database with Git-style versioning and branching built in. We launched Hosted Dolt a little over a year ago and since then we've released additional metrics, improved logs, created a sql workbench,...

    Read More
  20. FEATURE RELEASESQL
    5 min read

    Introducing Dolt Events

    Dolt is a version-controlled relational database that supports MySQL features. Today, we are excited to announce that we are adding support for MySQL Events . These are tasks that run on a specific schedule, such as executing a query statemen...

    Read More
JOIN THE DATA EVOLUTION

Get started with Dolt

Or join our mailing list to get product updates.