I work on the local-first that scales.

https://www.evolu.dev/blog/scaling-local-first-software

It looks very similar to Evolu (https://github.com/evoluhq/evolu)

cr-sqlite https://github.com/vlcn-io/cr-sqlite :

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

From "SQLedge: Replicate Postgres to SQLite on the Edge" (2023) https://news.ycombinator.com/item?id=37063238#37067980 :

>> In technical terms: cr-sqlite adds multi-master replication and partition tolerance to SQLite via conflict free replicated data types (CRDTs) and/or causally ordered event logs

Evolu has subscribe with useQuery or separated.

Evolu (a local-first platform designed for privacy, ease of use, and no vendor lock-in) has been using Effect for many months, and I'm close to releasing a refactoring that will embrace Effect even more (some modules didn't exist when Evolu switched from fp-ts to the Effect).

Effect is a great library, but it has one probably unresolvable issue. Once you use it, you will never want to write TypeScript code without it.

I made a local-first platform designed for privacy, ease of use, and no vendor lock-in to sync and backup precious data using SQLite and CRDT.

https://github.com/evoluhq/evolu

React Hooks library for local-first software with end-to-end encrypted backup and sync using SQLite and CRDT

https://github.com/evoluhq/evolu