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
402 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/N4K6PzV - docs: https://ift.tt/BvTMi1S - code: https://ift.tt/QRTjgxt - introducing post: https://ift.tt/7jxVcMO... You can also see some demo applications: - Linear clone: https://ift.tt/GjiPo8D - Realtime demo: https://ift.tt/ECvl8Rx - Conflict-free offline: https://ift.tt/t96KRjZ 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.

Comments

Post a Comment

Popular posts from this blog

New best story on Hacker News: Tell HN: Triplebyte reverses, emails apology

Tell HN: Triplebyte reverses, emails apology 610 by trianx | 387 comments on Hacker News. This just landed in my inbox. The discussion on hackernews ( https://ift.tt/3c2KiNO ) surely helped Triplebyte understand that it was a mistake to create public profiles of their users by default: Email by Triplebyte CEO, Ammon: --- Hi xxxxx, There’s no other way to put this--I screwed up badly. On Friday evening, I sent an email to you about a new feature called public Triplebyte profiles. We failed to think through the effects of this feature on our community, and made the profiles default public with an option to opt out. Many of you were rightfully angry. I am truly sorry. As CEO, this is my fault. I made this decision. Effective immediately, we are canceling this feature. You came to us with the goal of landing a great software engineering job. As part of that, you entrusted us with your personal, sensitive information, including both the fact that you are job searching as well as the resu
Read more

New best story on Hacker News: Launch HN: OutSail (YC W23) – Wingsails to reduce cargo ship fuel consumption

Launch HN: OutSail (YC W23) – Wingsails to reduce cargo ship fuel consumption 447 by jmoorebeek | 211 comments on Hacker News. Hi HN! I’m Joseph, and along with Arpan and Bailey we are the founders of OutSail Shipping ( https://ift.tt/8PBRduF ). We’re building a sail the size of a 747 that rolls up into a shipping container. When deployed, it will generate thrust from the wind to reduce the fuel consumption of a cargo ship. An array of these devices will reduce fuel consumption on ships by up to 20%. These sails are easily stowed and removed to cause no interference with cargo operations. Here’s a short video showing our prototype: https://www.youtube.com/watch?v=VUpVqzpym54 . Sails powered ships for millennia; but then the convenience of energy-dense fuels displaced sails. As ship speeds eventually exceeded wind speeds, the consensus became that sails had no place in shipping and were relegated to hobbyists and sport. Fast forward a century and a half, and maritime shipping, like a
Read more