Writes made to the local SQLite database are queued for upload by the PowerSync SDK.
You control how those writes are applied to the Postgres database through your existing backend API.
Local reads and writes with a performance-optimized SQLite database make your apps responsive and always available:
Users can access and modify data even when their network connection is unreliable or offline.
No client-side migrations are ever necessary.
Automatically stream data update events from your backend Postgres to users.
Live queries on the local database listen to changes and update your UI in real-time,
PowerSync was spun off from a product that's been in production for over 10 years.
Our sync rules approach to dynamic partial replication is battle-tested at scale.
We use a proven server reconciliation architecture with a default of last write wins. Developers
can customize conflict resolution if required, and are in full control of the write process.