New best story on Hacker News: Show HN: ElectricSQL, Postgres to SQLite active-active sync for local-first apps

Show HN: ElectricSQL, Postgres to SQLite active-active sync for local-first apps
406 by samwillis | 118 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/5dfyOHY - docs: https://ift.tt/DBU5ESn - code: https://ift.tt/L0gr34c - introducing post: https://ift.tt/IbFoOTY... You can also see some demo applications: - Linear clone: https://ift.tt/QRwZI5m - Realtime demo: https://ift.tt/6QUMx3y - Conflict-free offline: https://ift.tt/Nk0cESX 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.