Show HN: ElectricSQL, Postgres to SQLite active-active sync for local-first apps https://ift.tt/ouxhfvP

Show HN: 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 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/mk1WnQS - docs: https://ift.tt/DR03QH8 - code: https://ift.tt/Q78uACa - introducing post: https://ift.tt/JiHhgD2... You can also see some demo applications: - Linear clone: https://ift.tt/DygYT2V - Realtime demo: https://ift.tt/pUzruGa - Conflict-free offline: https://ift.tt/hMRH2ET 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. https://ift.tt/20cTSpY September 20, 2023 at 02:46PM