Local First Development

Created: by Pradeep Gowda Updated: Sep 21, 2023 Tagged: local-first-development

Some notes on Local-First Development

Show HN: ElectricSQL, Postgres to SQLite active-active sync for local-first apps

It’s an open source, local-first sync layer that can be used to build reactive, realtime, offline-capable apps directly on Postgres with two way active-active sync to SQLite (including with WASM in the browser).

Electric comprises a sync layer (built with Elixir) placed in front of your Postgres database and a type safe client that allows you to bidirectionally sync data from your Postgres to local SQLite databases. This sync is CRDT-based, resilient to conflicting edits from multiple nodes at the same time, and works after being offline for extended periods.

Some good links to get started:

Local-first software: You own your data, in spite of the cloud