# Local First Development - Page: https://shared.btbytes.com/p/local-first-development - Date: 2023-09-13 - Tags: local-first-development [Some notes on Local-First Development](http://web.archive.org/web/20230912204818/https://bricolage.io/some-notes-on-local-first-development/) [Show HN: **ElectricSQL, Postgres to SQLite active-active sync for local-first apps**](https://news.ycombinator.com/item?id=37584049) 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](https://electric-sql.com/) - docs: [https://electric-sql.com/docs](https://electric-sql.com/docs) - code: [https://github.com/electric-sql/electric](https://github.com/electric-sql/electric) - introducing post: [https://electric-sql.com/blog/2023/09/20/introducing-electri...](https://electric-sql.com/blog/2023/09/20/introducing-electricsql-v0.6) You can also see some demo applications: - Linear clone: [https://linear-lite.electric-sql.com](https://linear-lite.electric-sql.com/) - Realtime demo: [http://web.archive.org/web/20230929164756/https://electric-sql.com/docs/intro/multi-user](http://web.archive.org/web/20230929164756/https://electric-sql.com/docs/intro/multi-user) - Conflict-free offline: [http://web.archive.org/web/20230929164756/https://electric-sql.com/docs/intro/offline](http://web.archive.org/web/20230929164756/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. --- [Local-first software: You own your data, in spite of the cloud](https://www.inkandswitch.com/local-first/) article by *Ink and Switch*. [A Local-First Case Study | jakelazaroff.com](https://jakelazaroff.com/words/a-local-first-case-study/#is-it-local-first), where Jake talks about the story behind [Waypoint](https://waypoint.jakelazaroff.com/), a local-first web app for planning trips; it takes inspiration from Ink and Switch's [Embark](https://www.inkandswitch.com/embark/); [via HN](https://news.ycombinator.com/item?id=41712593). [Local-First Software](https://localfirstweb.dev/) special interest group; they have youtube videos of their meetups.