Show HN: ElectricSQL, Postgres to SQLite active-active sync for local-first apps
419 by samwillis | 121 comments on Hacker News.
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://ift.tt/Xqw9xa6 - docs: https://ift.tt/h16uDvp - code: https://ift.tt/9vPT4t6 - introducing post: https://ift.tt/yDfOiZ8... You can also see some demo applications: - Linear clone: https://ift.tt/ZKXlyTk - Realtime demo: https://ift.tt/Fy1vGzT - Conflict-free offline: https://ift.tt/zAqEpMQ 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.