LogoLogo
BlogDiscordGitHubDoltgres
  • Introduction
    • What is Doltgres?
    • Installation
    • Getting Started
  • Concepts
    • Git
      • Commits
      • Log
      • Diff
      • Branch
      • Merge
      • Conflicts
      • Remotes
      • Working Set
    • SQL
      • Databases
      • Schema
      • Tables
      • Primary Keys
      • Types
      • Indexes
      • Views
      • Constraints
      • Triggers
      • Functions
      • Procedures
      • Users/Grants
      • Transactions
      • System Variables
    • RDBMS
      • Server
      • Backups
      • Replication
  • Guides
    • Cheat Sheet
    • Replication from Postgres
  • Reference
    • Running the Server
      • Configuration
      • Access Management
      • Branch Permissions
      • Backups
      • Garbage Collection
      • Metrics
      • Replication
      • Troubleshooting
    • Version Control Features
      • Using Branches
      • Merges
      • Querying History
      • Using Remotes
      • Functions
      • System Tables
      • System Variables
    • SQL Language Support
      • Supported Functions and Operators
      • Supported Types
      • Supported SQL Commands
      • System Catalog Schema
    • Supported Clients
      • Programmatic
    • Benchmarks
      • Correctness
      • Latency
Powered by GitBook
On this page
  1. Reference

Version Control Features

PreviousTroubleshootingNextUsing Branches

Last updated 1 month ago

Unlike other relational databases, Doltgres has multiple branches and stores all data in a commit graph, like git. This makes it possible to efficiently diff any two commits, as well as merge one branch into another. All the git-like version control functionality is exposed as system tables, system variables, functions, and stored procedures.

Version control overview

  • explains how to work with different branches in a running server.

  • explains how to merge branches into one another and resolve merge conflicts using SQL.

  • describes how to query past revisions or different branches of a database.

  • describes how to use remotes to coordinate between Doltgres clones.

  • documents all the system functions that implement version control operations such as DOLT_COMMIT, DOLT_CHECKOUT, DOLT_MERGE, etc. Also documents Doltgres-provided functions that aren't part of standard Postgres, including table functions that produce diffs of any table at two points in its history.

  • describes the system tables that provide read access to version control information, such as branches, commit log, diffs, and conflicts.

  • documents all the Doltgres-provided system variables that expose and control various aspects of Doltgres's behavior.

  • documents a Doltgres feature to save queries for later execution.

Using Branches
Merges
Querying History
Using Remotes
Functions
System tables
System variables
Saved Queries