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/fSncUe1 - docs: https://ift.tt/Vykq3jR - code: https://ift.tt/7TdYW6D - introducing post: https://ift.tt/iVPtaAU... You can also see some demo applications: - Linear clone: https://ift.tt/i1ySVNm - Realtime demo: https://ift.tt/TaxMt1p - Conflict-free offline: https://ift.tt/AF345qX 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. September 20, 2023 at 06:46PM