# vlcn-io/cr-sqlite

Convergent, Replicated SQLite. Multi-writer and CRDT support for SQLite

Repository: https://github.com/vlcn-io/cr-sqlite
Canonical: https://ross.abutalabs.com/products/cr-sqlite
Homepage: https://vlcn.io
Language: Rust
License: MIT
License Family: permissive
Topics: crdt, database, sqlite
Last push: 2026-08-10T10:55:49+00:00

## Health v2 (maintenance only)
Score: 66/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 97, release rhythm 8, longevity 100
- inputs: {"age_days": 1502, "days_push": 23, "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 3774, forks 121 (observed 2026-08-28T04:08:18.230076+00:00)

## What it is
cr-sqlite is a run-time loadable extension for SQLite and libSQL, written in Rust, that adds multi-master replication and CRDT-based conflict-free merging to SQLite databases. It lets independently written offline databases converge when synced, functioning like 'Git for your data' in local-first and collaborative applications.

## Use cases
- sync sqlite data between devices
- build offline-first apps with local writes
- implement realtime collaboration without a conflict resolution layer
- merge two sqlite databases that took independent writes
- make apps resilient to network partitions
- build local-first p2p applications with sqlite

## When to choose
- your app needs offline editing with automatic conflict-free merging
- you want multi-writer replication on top of SQLite or libSQL
- you're building local-first, collaborative, or P2P software
- you need device-to-device sync without a central server

## When to avoid
- you need a traditional single-writer client-server database with strict consistency
- your data model requires server-side validation of every write
- you're not using SQLite and can't adopt it
- you need heavy transactional guarantees across distributed writes

## Facets
- artifact type: library
- maturity: active
- function: database, orm, concurrency, p2p
- domain: databases, microservices, web-development, developer-tools
- platform: cross-platform, wasm, browser, python, rust, cli
- tags: crdt, sqlite-extension, local-first, offline-first, multi-master-replication, data-sync, collaborative-editing, loadable-extension, nodejs

## Member repositories
- vlcn-io/cr-sqlite (main) score 66

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:08:18.230076+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-29T18:27:51.274154+00:00, confidence not recorded.
  - readme: https://github.com/vlcn-io/cr-sqlite (fetched 2026-08-28T04:08:18.230076+00:00, sha 7bc1de412922)
  - homepage: https://vlcn.io (fetched 2026-08-29T09:22:36.562108+00:00, sha 5a24437614b2)
  - site_page: https://vlcn.io/docs (fetched 2026-08-29T09:22:36.571519+00:00, sha 684e709d380c)
  - site_page: https://vlcn.io/about (fetched 2026-08-29T09:22:36.574649+00:00, sha 52ca17a6a8ba)
  - site_page: https://vlcn.io/docs/cr-sqlite/intro (fetched 2026-08-29T09:22:36.577093+00:00, sha 3dd308ab48b7)
  - site_page: https://vlcn.io/docs/cr-sqlite/js/first-app (fetched 2026-08-29T09:22:36.578887+00:00, sha 3855c36c1ba9)
- Data as of 2026-08-30T08:39:29.467469+00:00.
