Empirical Reference Matrix

Database & Synchronization Technologies

A formal comparative specification evaluating client engines, backend targets, synchronization protocols, and primary architectural strengths across the ecosystem.

Ecosystem Comparison Reference Table

Technology	Category	Client Engine	Backend Target	Sync Protocol	Key Strengths
Zero (Rocicorp)	Relational Sync Engine	IndexedDB / Memory	PostgreSQL	WebSocket / ZQL Incremental	Sub-millisecond query execution, scale to millions of rows, declarative ZQL authorization
ElectricSQL	Relational Sync Layer	SQLite WASM / Client DB	PostgreSQL	Postgres Logical Replication	Pure SQL client execution, open-source Postgres sync, shape-based partial sync
Automerge	JSON/Text CRDT Library	Memory / Local Storage	Any (Peer-to-Peer / Relay)	Binary Change Sync Logs	Complex collaborative documents, rich text intent preservation, offline-first data structures
Yjs	Structural CRDT Engine	Memory / IndexedDB	Any (WebSocket / WebRTC)	Compact Delta Encoding	Ultra-fast document editing, robust rich-text bindings, extensive ecosystem integration
PowerSync	Relational Sync Engine	SQLite WASM / Native	Postgres, MySQL, Mongo	Streaming Sync Gateway	Multi-database backend support, client SQL execution, dynamic access control rules
RxDB	Reactive Database	IndexedDB, RxStorage	CouchDB, GraphQL, REST	Push/Pull Replication Plugins	Reactive query subscriptions, flexible storage adapters, encryption and schema validation
PouchDB	Document Database	IndexedDB / WebSQL	Apache CouchDB / Cloudant	CouchDB Multi-Master Replication	Battle-tested document sync pioneer, robust offline replication protocol
InstantDB	Graph-Relational Sync	Client Memory Cache	PostgreSQL (Triple Store)	Server-pushed subscriptions	Firebase-like simplicity with relational graphs, instant optimistic updates

Zero (Rocicorp)

Relational Sync Engine

General-purpose relational sync engine combining client-side IndexedDB caching with zero-cache Postgres replication for sub-millisecond queries.

Client Engine: IndexedDB / Memory

Backend Target: PostgreSQL

Sync Protocol: WebSocket / ZQL Incremental

Empirical Strengths

Sub-millisecond query execution, scale to millions of rows, declarative ZQL authorization

ElectricSQL

Relational Sync Layer

Open-source sync layer bringing local-first reactivity to Postgres and client-side SQLite database engines.

Client Engine: SQLite WASM / Client DB

Backend Target: PostgreSQL

Sync Protocol: Postgres Logical Replication

Empirical Strengths

Pure SQL client execution, open-source Postgres sync, shape-based partial sync

Automerge

JSON/Text CRDT Library

Data structures library in JavaScript and Rust for building collaborative, local-first applications with full history.

Client Engine: Memory / Local Storage

Backend Target: Any (Peer-to-Peer / Relay)

Sync Protocol: Binary Change Sync Logs

Empirical Strengths

Complex collaborative documents, rich text intent preservation, offline-first data structures

Yjs

Structural CRDT Engine

High-performance CRDT framework supporting rich text, shared types, and editor bindings for ProseMirror, Monaco, and Slate.

Client Engine: Memory / IndexedDB

Backend Target: Any (WebSocket / WebRTC)

Sync Protocol: Compact Delta Encoding

Empirical Strengths

Ultra-fast document editing, robust rich-text bindings, extensive ecosystem integration

PowerSync

Relational Sync Engine

Sync engine connecting client-side SQLite to PostgreSQL, MySQL, or MongoDB with real-time streaming updates.

Client Engine: SQLite WASM / Native

Backend Target: Postgres, MySQL, Mongo

Sync Protocol: Streaming Sync Gateway

Empirical Strengths

Multi-database backend support, client SQL execution, dynamic access control rules

RxDB

Reactive Database

Reactive, client-side NoSQL database for JavaScript applications with pluggable storage adapters and sync plugins.

Client Engine: IndexedDB, RxStorage

Backend Target: CouchDB, GraphQL, REST

Sync Protocol: Push/Pull Replication Plugins

Empirical Strengths

Reactive query subscriptions, flexible storage adapters, encryption and schema validation

PouchDB

Document Database

Battle-tested JavaScript database designed to emulate CouchDB and synchronize seamlessly over HTTP.

Client Engine: IndexedDB / WebSQL

Backend Target: Apache CouchDB / Cloudant

Sync Protocol: CouchDB Multi-Master Replication

Empirical Strengths

Battle-tested document sync pioneer, robust offline replication protocol

InstantDB

Graph-Relational Sync

Client-side graph database that syncs automatically with server storage for relational data handling with Firebase simplicity.

Client Engine: Client Memory Cache

Backend Target: PostgreSQL (Triple Store)

Sync Protocol: Server-pushed subscriptions

Empirical Strengths

Firebase-like simplicity with relational graphs, instant optimistic updates