Skip to content

CommitDB

A Git-backed SQL database engine written in Go. Every transaction is a Git commit, providing built-in version control, complete history, branching, and the ability to restore to any point in time.

  • 🔄 Version Control – Every change is tracked, nothing is lost
  • 🌿 Git Branching – Experiment in branches, merge when ready
  • ⏪ Time Travel – Restore any table to any previous state
  • 🔗 Remote Sync – Push/pull to GitHub, GitLab, or any Git remote
  • 📡 Shared Databases – Query and JOIN across external repositories

Quick Start

# Install
go install github.com/nickyhof/CommitDB/v2/cmd/commitdb@latest

# Run with in-memory storage
commitdb

# Run with file persistence
commitdb -dir=/path/to/data

import (
    commitdb "github.com/nickyhof/CommitDB/v2"
    "github.com/nickyhof/CommitDB/v2/core"
    "github.com/nickyhof/CommitDB/v2/persistence"
)

p, _ := persistence.NewFilePersistence("./mydata", nil)
instance := commitdb.Open(&p)
e := instance.Engine(core.Identity{Name: "Alice", Email: "alice@example.com"})

e.Execute("CREATE DATABASE myapp")
e.Execute("CREATE TABLE myapp.users (id INT, name STRING)")
e.Execute("INSERT INTO myapp.users VALUES (1, 'Alice')")
result, _ := e.Execute("SELECT * FROM myapp.users")
result.Display()

Features

Category Features
SQL SELECT, INSERT, UPDATE, DELETE, CREATE/DROP TABLE/DATABASE/INDEX, VIEWS
Queries WHERE, ORDER BY, LIMIT, OFFSET, DISTINCT, GROUP BY, HAVING
Aggregates SUM, AVG, MIN, MAX, COUNT
JOINs INNER, LEFT, RIGHT
Bulk I/O COPY INTO for CSV import/export
Version Control Branching, merging, snapshots, time-travel restore
Remote Push, pull, fetch with token/SSH/basic auth

Documentation

Getting Started

Guides