Database on the device
Developing against an embedded SQLite database gives you immediate reads and writes with
Sync via the cloud
ElectricSQL extends SQLite with conflict-free, active-active replication. Data syncs via the cloud and optionally with/into a Postgres database.
Sync across devices
You can sync your users' data across their devices, so that data they write locally is automatically available wherever they login.
Sync between users
And you can sync data between users (by room, workspace, region or globally) using SQLite as a realtime multi-user database.
ElectricSQL provides live queries you can bind to your reactive components, so changes are picked up and re-rendered in realtime.
Opting in to the cloud Postgres database allows you to aggregate and query data that would otherwise be spread out across local devices.
Use the ElectricSQL control plane to propagate DDL migrations and data changes out to your apps wherever they're running.
We're working on systems for dynamic partial replication and authorization for fine grained control over data synchronization.
Overall, it's a new paradigm where you develop local-first apps and we provide the cloud sync, wrapped up into a turnkey service.