timsehn

timsehn / doltlite

Public

A fork of SQLite that has Dolt storage and features

database-version-control dolt sqlite version-controlled-database
24
2
100% credibility
Found Mar 26, 2026 at 24 stars -- GitGems finds repos before they trend. Get early access to the next one.
Sign Up Free
AI Analysis
C
AI Summary

Doltlite is a version-controlled SQLite database that adds Git-like features such as commits, branches, and merges directly into SQL.

How It Works

1
🔍 Discover Doltlite

You're building a small app and need a simple database that tracks every change like a photo album of your data over time.

2
📥 Get it running

Download and launch Doltlite with a single command, just like starting any other database tool.

3
💾 Load your data

Connect your existing data or create new tables using everyday SQL, and it feels familiar right away.

4
✨ Save your first snapshot

Make changes to your data and save a 'commit' – now you have a permanent record of this moment.

5
🌿 Try new ideas safely

Create a 'branch' to experiment with updates without touching your main data, like a sandbox.

6
🔄 Review or combine

Look back at past versions, compare changes, or merge your experiments back into the main story.

🎉 Your data has a history

Every change is tracked forever, so you can always go back, see what happened, and never lose your work.

Sign up to see the full architecture

5 more

Sign Up Free

Star Growth

See how this repo grew from 24 to 24 stars Sign Up Free
Repurpose This Repo

Repurpose is a Pro feature

Generate ready-to-use prompts for X threads, LinkedIn posts, blog posts, YouTube scripts, and more -- with full repo context baked in.

Unlock Repurpose
AI-Generated Review

What is doltlite?

Doltlite is a new SQLite fork in C that replaces the B-tree storage with Dolt's prolly trees, adding Git-like version control to any SQLite database in a single file. Developers get SQL functions like dolt_commit(), dolt_branch(), dolt_merge(), and virtual tables for diffs, history, and schema changes, enabling branching, time-travel queries, and remotes over file:// or HTTP. It's a drop-in libsqlite3 replacement—no code changes needed for existing C, Python, or Go apps.

Why is it gaining traction?

It stands out as a lightweight SQLite fork with Dolt features, delivering near-parity read/write performance (many benchmarks 1x SQLite) while packing Git ops into SQL. Users notice instant diffs (dolt_diff('table')), point-in-time reads (dolt_at_table('branch')), and row-level merges without external tools. The single-file format and embeddable HTTP server for collaboration hook devs tired of bolting Git onto SQLite.

Who should use this?

SQLite embedders building auditable apps, like config DBs in IoT devices or user data versioning in mobile/desktop tools. Data engineers prototyping with SQL who need cheap branching/merging, or solo devs tracking schema evolution without Dolt's Go overhead.

Verdict

Grab it for SQLite projects needing version control—docs and examples shine, tests pass SQLite's 87k suite. At 1.0% credibility (24 stars), it's early but stable enough for experiments; monitor for production.

(198 words)

Sign up to read the full AI review Sign Up Free

Similar repos coming soon.