# aergoio/litetree

SQLite with Branches

Repository: https://github.com/aergoio/litetree
Canonical: https://ross.abutalabs.com/products/litetree
Language: C
License: MIT
License Family: permissive
Topics: database, sqlite3, aergo
Last push: 2026-04-27T05:21:53+00:00

## Health v2 (maintenance only)
Score: 58/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 79, release rhythm 8, longevity 100
- inputs: {"age_days": 2949, "days_push": 128, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1638, forks 40 (observed 2026-08-28T04:05:15.074270+00:00)

## What it is
LiteTree is a modified SQLite engine that supports database branching, allowing multiple connections to read or write separate branches or commits of the same database, similar to git. It was built as the storage core for the Aergo blockchain.

## Use cases
- run sqlite queries against a specific branch of a database
- read a database at a previous point in time
- test schema changes on a branch without affecting master
- store blockchain state with branching support
- have multiple connections writing to separate branches of one database

## When to choose
- you need git-like branching or time-travel queries in an embedded SQL database
- you are building blockchain or ledger systems that need forkable state
- you want SQLite compatibility with point-in-time reads

## When to avoid
- you need a standard, unmodified SQLite with broad tooling support
- you need distributed or networked database branching
- you require heavy write concurrency across many nodes

## Facets
- artifact type: library
- maturity: maintenance
- function: database, database-driver
- domain: databases, blockchain, developer-tools
- platform: windows, cross-platform, c
- tags: sqlite, branching, versioned-database, time-travel, fork, linux, macos

## Member repositories
- aergoio/litetree (main) score 58

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:05:15.074270+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T03:46:32.933796+00:00, confidence not recorded.
  - readme: https://github.com/aergoio/litetree (fetched 2026-08-28T04:05:15.074270+00:00, sha a04d3c08c549)
- Data as of 2026-08-30T08:39:29.467469+00:00.