# orbitinghail/sqlsync

SQLSync is a collaborative offline-first wrapper around SQLite. It is designed to synchronize web application state between users, devices, and the edge.

Repository: https://github.com/orbitinghail/sqlsync
Canonical: https://ross.abutalabs.com/products/sqlsync
Homepage: https://sqlsync.dev
Language: Rust
License: Apache-2.0
License Family: permissive
Topics: collaborative, database, local-first, offline-first, relational-database, sql, sqlite, sqlsync
Last push: 2025-11-19T20:47:39+00:00

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

## Adoption (not part of the score)
Stars 2913, forks 41 (observed 2026-08-28T04:07:29.337531+00:00)

## What it is
SQLSync is a collaborative offline-first wrapper around SQLite that synchronizes web application state between users, devices, and the edge. It provides optimistic reads and writes, reactive query subscriptions, and real-time collaboration on top of an eventually consistent SQLite database.

## Use cases
- build a local-first collaborative web app like Figma with per-file SQLite databases
- sync app state across devices and browsers offline-first
- run SQLite on the edge with tolerance for unreliable networks
- enable optimistic mutations on SQLite read replicas
- share a collaborative to-do list across tabs and devices
- subscribe reactively to SQL query results in a React app

## When to choose
- you need offline-first, multi-user collaboration over structured relational data
- you want optimistic local reads/writes with eventual consistency backed by SQLite
- your app benefits from per-document databases with real-time sync and cross-tab sharing

## When to avoid
- you need strict transactional consistency or a mature production-grade database
- your project requires a traditional client-server SQL database with strong guarantees
- you are not building a web/edge application and cannot adopt the reducer model

## Facets
- artifact type: library
- maturity: experimental
- function: database, orm, concurrency, wasm
- domain: databases, web-development, frontend, microservices
- platform: browser, wasm, rust, cross-platform
- tags: sqlite, local-first, offline-first, collaborative, eventual-consistency, reactive-queries, edge-computing, web-server

## Member repositories
- orbitinghail/sqlsync (main) score 53

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:07:29.337531+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-30T07:34:13.579471+00:00, confidence not recorded.
  - readme: https://github.com/orbitinghail/sqlsync (fetched 2026-08-28T04:07:29.337531+00:00, sha 3c06114368c1)
  - homepage: https://sqlsync.dev (fetched 2026-08-29T09:49:26.015529+00:00, sha 1d9326e94c9e)
  - registry_crates: https://crates.io/api/v1/crates/sqlsync (fetched 2026-08-29T09:49:26.018164+00:00, sha 26714d47ca19)
- Data as of 2026-08-30T08:39:29.467469+00:00.