PowerSync: Backend DB - SQLite sync engine | For Postgres, MongoDB, MySQL

2 min read Original article ↗

Connects to these backend databases

Client SDKs available for these frameworks

SYNC MADE SIMPLE

What is PowerSync?

PowerSync is a sync engine that consists of two components: a service that enables high-scalability partial data syncing and a set of client SDKs that manage client-side persistence, consistency, reactivity and syncing write operations back.

PowerSync
Service

PowerSync SDK

In-app
SQLite

auto-synced

real-time

reactive

State transfer managed for you

Fast, reactive, local-first apps

BRING YOUR OWN backend, sync with SQLite

A sync engine built to use powerful open tech

Connect the most capable open database technologies: Postgres, MySQL, MongoDB or SQL Server on the backend and SQLite on the client-side.

PowerSync itself is also open-source and source-available.

The Power of SQLite on the Client-Side

In-app SQLite

Extensible

Many extensions available

ORM Support

Works with popular ORMs

Versatile

Works well with both document data (with strong JSON support) and relational data

Bi-directional automatic partial syncing

Real-time reactivity
with live queries

Painless schema
evolution

SYNC ENGINES ENABLE INSTANTLY-RESPONSIVE USER EXPERIENCES

Today’s best apps use sync

Syncing apps provide an unmatched user experience: app interactions are instant, data updates fan out to all users in real-time, and apps are always available — even while offline.

AVOID GETTING BOGGED DOWN IN STATE MANAGEMENT

Make app dev more fun

Sync engines change the way data flows between client and server, taking the network off the user interaction path and cutting complexity.

Stop spending energy on micromanaging data and network calls, and let the sync engine take care of state transfer and state management for you.

Backend DATABASE, meet SQLite

How PowerSync works

The PowerSync Service connects to your source database.

PowerSync is non-invasive to your backend database, with minimal permissions required.

Learn more

The PowerSync Service continuously replicates data by tracking changes in the source database.

PowerSync Service

Dynamic data partitioning

Data is dynamically partitioned based on rules that you define, giving each user just the data they need.

Updates are streamed to clients in real-time.

The PowerSync Service elastically scales horizontally to large numbers of concurrent clients.

Learn more

PowerSync Client SDK

In-app SQLite

App data tables

Upload queue

The PowerSync client SDK keeps an in-app SQLite database updated, enabling full offline-first functionality.

PowerSync uses JWTs for authentication.

Learn more

Writes are applied locally, and queued for upload to your backend API.

You have full control over logic for applying writes to your backend database.

Learn more

Live demo app

React Multi-Client Demo App (PowerSync + Supabase)

Implement sync today

Key features