Dev tools · September 20, 2023
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…
ElectricSQL, Postgres to SQLite active-active sync for local-first apps launched on September 20, 2023 with 617 votes, #33 of 4,228 launches that month and more than 99% of that year's launches. The site was still online in September 2026, 3 years on.
In plain words
ElectricSQL is an open source sync layer that enables bidirectional data synchronization between Postgres databases and local SQLite instances, including in web browsers via WebAssembly. Built with Elixir, it uses CRDT-based technology to handle conflicts from multiple simultaneous edits and maintains functionality during offline periods. The tool is designed for developers building reactive, realtime applications that work offline-first, providing type-safe clients for syncing data between server and local databases.
written from the facts on this page · September 2026
From the sources
Electric provides the data primitives and infra to build collaborative, multi-agent systems. Including Postgres Sync, Durable Streams, TanStack DB and PGlite.
Agents are long-lived entities that live in the data layer. The substrate for them is a sync engine. Agents are long-lived entities in the data layer. The substrate for them is a sync engine. Electric is the first agent platform built on sync. Scale out multi-user, multi-agent systems with humans in the loop. Agents live as durable, synced entities — resumable across devices, observable across teams, forkable for review and experimentation. Persistent, addressable, real-time streams — a flexible, swiss-army-knife data primitive for agent session data. Composable sync primitives that power end-to-end reactivity and collaboration for multi-agent systems. Drop in Electric next to your existing…from electric-sql.com
In the maker’s words, at launch
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…
Does a similar job
all alternatives →
Bi-directional sync between Postgres and SQLite2023 · powersync.com · ▲356Hi HN, Today we’re launching PowerSync, a Postgres<>SQLite bi-directional sync engine that enables an offline-first app architecture. It currently supports Flutter, React Native and web (JavaScript) using Wasm SQLite in the browser, with more client SDKs on the way. Conrad and I (Ralf) have been working on our sync engine since 2009, originally as part of a full-stack app platform. That version of the system is still used in production worldwide and we’ve learnt a lot from its use cases and scaling. About a year ago we started on spinning off PowerSync as a standalone product that is…
Replicate App-Embedded DuckDBs into PostgreSQL with SyncLite OSS2024 · github.com · ▲73Hi HN, We have been building SyncLite, an open-source platform to simplify offline-first application development. If your application uses SQLite or DuckDB, SyncLite lets it continue using the local database as usual while synchronization happens in the background. For SQL-based applications, SyncLite records transactions into transactionally consistent .sqlog files using SQLite as an open replication format. A background consolidator replays those transactions, derives row-level CDC and schema changes, and applies them transactionally to destination databases like PostgreSQL. The same…
- MDMultiplayer Demo Built with Elixir2022 · multiplayer.dev · ▲221
Hey HN, I’m an engineer at Supabase [0] and one of the creators of this demo. My team and I have been working hard to bring developers the next version of Supabase Realtime. The current version of Realtime [1] is a Change Data Capture (CDC) server for a PostgreSQL database that broadcasts changes via WebSockets to authorized subscribers. It’s written in Elixir/Phoenix. The server utilizes PostgreSQL’s logical replication functionality, which writes database changes to Write-Ahead Logging (WAL) segment files, and a replication slot, responsible for managing and retaining WAL files.…
Syncular – offline-first SQL sync with TypeScript and Rust coresAug 2026 · github.com · ▲79Offline-first SQL sync with Typescript and Rust cores - syncular/syncular
Embed an SQLite database in your PostgreSQL table2024 · github.com · ▲180pglite-fusion is a PostgreSQL extension that allows you to embed SQLite databases into your PostgreSQL tables by enabling the creation of columns with the `SQLITE` type. This means every row in the table can have an embedded SQLite database. In addition to the PostgreSQL `SQLITE` type, pglite-fusion provides the `query_sqlite`` function for querying SQLite databases and the `execute_sqlite` function for updating them. Additional functions are listed in the project’s README. The pglite-fusion extension is written in Rust using the pgrx framework [1]. ---- Implementation Details The PostgreSQL…
More dev tools this month
the category →
open-source IDE for thoughtful software design. Contribute to devdotfast/whiteboard development by creating an account on GitHub.
Dev tools · 28d ago · github.com
Contribute to reladraw/reladraw development by creating an account on GitHub.
Dev tools · 26d ago · github.com
OpenBot▲362Grok Bot alternative: free, local, open-source, multiplayer
Dev tools · 23d ago · openbot.run
Talanoa▲346Hi HN, I’m a fullstack developer, and honestly, I’ve lost count of how many side projects I’ve worked on over the years. But one idea kept coming back to me: a different kind of email client. It first came to me in 2014: “What if we could handle emails more like conversations?” Every year, I’d revisit this concept in my “Build Notes.” Ten years later, no one had built exactly what I had in mind — so I finally decided to do it myself. That’s how Talanoa was born. I wanted something focused on people, not timelines. I was tired of marking messages as unread just to remember to reply later, or…
Dev tools · 21d ago · talanoa.email
CoreSpeed▲332One MCP for everything your agents need: apps, memory, tools
Dev tools · 28d ago · corespeed.io
Source: Show HN post ↗ · launch text quoted in part
