Dev tools · September 20, 2023
ElectricSQL, Postgres to SQLite active-active sync for local-first apps
Hi HN, James, Valter, Sam and the team from ElectricSQL here. We're really excited to be sharing ElectricSQL with you today. 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…
In plain words
ElectricSQL is an open source sync layer that enables bidirectional data synchronization between Postgres databases and local SQLite instances, including in web browsers via WebAssembly. Built with Elixir, it uses CRDT-based technology to handle conflicts from multiple simultaneous edits and maintains functionality during offline periods. The tool is designed for developers building reactive, realtime applications that work offline-first, providing type-safe clients for syncing data between server and local databases.
written from the facts on this page · September 2026
From the sources
In the maker’s words, at launch
Hi HN, James, Valter, Sam and the team from ElectricSQL here. We're really excited to be sharing ElectricSQL with you today. 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: - website: https://electric-sql.com - docs: https://electric-sql.com/docs - code: https://github.com/electric-sql/electric - introducing post: https://electric-sql.com/blog/2023/09/20/introducing-electri... You can also see some demo applications: - Linear clone: https://linear-lite.electric-sql.com - Realtime demo: https://electric-sql.com/docs/intro/multi-user - Conflict-free offline: https://electric-sql.com/docs/intro/offline The Electric team actually includes two of the inventors of CRDTs, Marc Shapiro and Nuno Preguiça, and a number of their collaborators who've pioneered a lot of tech underpinning local-first software. We are privileged to be building on their research and delighted to be surfacing so much work in a product you can now try out.
More dev tools this month
the category →
Open-source GTM skills for technical founders
Dev tools · 29d ago · gtmcofounder.com
OpenTrailPaper is open-source bike computer firmware for the LilyGO T5S3 4.7" E-Paper PRO. It supports offline maps, GPX routes, FIT recording and Bluetooth sensors.
Dev tools · 1d ago · opentrailpaper.com
