SQLite Sync + PostgreSQL
Your favorite backend. An instantly responsive frontend. Read and write locally with SQLite, then sync with PostgreSQL when the network is ready.
Zero network round trips for local reads and writes.
Local first. Postgres connected.
PostgreSQL
Your central backend
Local operations finish first. Synchronization follows.
Feel the difference
Illustration · actual timings vary
01 / Instant interaction
Query and update the SQLite database on the device. Your interface can respond without waiting for a request to reach PostgreSQL and come back.
02 / Offline continuity
Keep reading and writing local data in the field, on a flight, or through a dropped connection. Sync accumulated changes when connectivity returns.
03 / Coordinated data
Let devices make changes independently. CRDT-based replication merges updates deterministically so replicas converge when they synchronize.
Built around your stack
PostgreSQL stays your central backend for shared data and existing workflows. SQLite gives each client a local database for the work that cannot wait.
Explore the extension on GitHub ↗Connect your PostgreSQL backend to CloudSync and configure the tables you want to synchronize.
Add SQLite Sync to your local database. Read and write with SQL, right on the device.
Run synchronization when connected. Local and remote changes converge through CRDT-based replication.
Your next local-first app
Add SQLite Sync to your stack and bring your data closer to every user, device, and agent.