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.
Your applicationON DEVICE
A new idea, saved.✓ Local write
PostgreSQL
Your central backend
SERVER
Local operations finish first. Synchronization follows.
Feel the difference
SAVE AN EDIT
Local SQLite✓ Saved
Server round tripNetwork wait
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.
FIELD NOTESOfflineConnected
✓ Site inspected Local
✓ Report updated Local
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.
INDEPENDENT EDITS. SHARED RESULT.
Device ATask: Review
Device BDone: Yes
Review✓ Done
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.
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.