Go to Cloud
Cloud
Go to Cloud

ElectricSQL Blog

The latest news and updates from the ElectricSQL project.

Community
GitHub

Expressive subqueries without resyncs — the engineering deep dive

Rob A'Court

We shipped a major upgrade to Electric's subquery support. More expressive cross-table filtering, no unnecessary resyncs when data moves in and out of shapes. This post dives into the engineering.

Read post →

StreamDB — a reactive database in a Durable Stream

James Arthur

StreamDB turns a Durable Stream into a reactive database. You provide a Standard Schema, StreamDB gives you type‑safe, durable state with sync.

Read post →

Electric apps get persistence and includes with TanStack DB 0.6

Sam Willis

TanStack DB 0.6 is a major update for Electric users. Persistence and includes make the Electric + TanStack DB stack more app-ready while staying incrementally adoptable.

Read post →

Announcing PGlite v0.4: PostGIS, connection multiplexing, and a new architecture

Tudor Zaharia

PGlite v0.4 ships PostGIS, connection multiplexing, and a major architecture refactor. This post covers what changed and what comes next for embedded Postgres.

Read post →

Durable Transports for your AI SDK

James Arthur

We've released Durable Streams based transport and session integrations for TanStack AI and the Vercel AI SDK. With turnkey hosting on Electric Cloud.

Read post →

Agent skills now shipping in our npm packages

Kyle Mathews

We've been collaborating with TanStack to ship agent skills in our npm packages. Run one command to give your agent deep knowledge of Electric, TanStack DB and Durable Streams.

Read post →

Amdahl's law for AI agents

Kyle Mathews

Multi-agent systems are delivering real throughput gains — but the teams seeing the biggest speedups share a pattern. A law from 1967 explains why.

Read post →

Configurancy: keeping systems intelligible when agents write all the code

Kyle Mathews

AI makes code cheap. The scarce asset is the system's self-knowledge. Configurancy is the layer that lets agents coherently co-evolve a system.

Read post →

Announcing Hosted Durable Streams

Kyle Mathews

Hosted durable streams are live on Electric Cloud. You can now sync and stream AI sessions and low-latency real-time data alongside structured database changes.

Read post →

From fiction to reality, you can now build difficult things

Sam Willis

Four years ago, building a collaborative parametric CAD app was completely out of reach for a solo developer. I built one in a week, using the Electric stack and coding agents.

Read post →

Durable Sessions — the key pattern for collaborative AI

James Arthur

As the world moves to getting things done through agents, products need to combine AI with team-based collaboration. Durable Sessions are the best way to do that.

Read post →

Durable Streams 0.1.0 and State Protocol

Kyle Mathews

The first official npm release of Durable Streams, introducing the State Protocol for database-style sync semantics, improved conformance tests and community experiments.

Read post →

Announcing Durable Streams

Kyle Mathews

Introducing Durable Streams, an open protocol for persistent, addressable, real-time streams, based on a generalization of the battle-tested Electric sync protocol.

Read post →

Electric 1.1: new storage engine with 100x faster writes

Ilia Borovitinov

A behind‑the‑scenes look at Electric's new storage engine: why we built it, how it works, and how it improves performance in production.

Read post →

Bringing agents back down to earth

James Arthur

Agentic AI, beneath all the hype, is actually just normal software. You can build agentic systems with a database, standard web tooling and real-time sync.

Read post →

120 days of hardening – the post‑1.0 reliability sprint

Kyle Mathews

Our last quarter was a reliability sprint. We set one goal: make ElectricSQL so boring‑reliable that you stop thinking about it and just build.

Read post →

Super-fast apps on sync with Electric and TanStack DB

James Arthur

Tanstack DB is a reactive client store for building super fast apps on sync. Paired with Electric, it provides an optimal end-to-end sync stack for local-first app development.

Read post →

Vibe coding with a database in the sandbox

James Arthur

More play less infra. With PGlite you can vibe code with a database built into the sandbox.

Read post →

Untangling the LLM spaghetti

James Arthur

LLMs are generating code. That code is imperatively fetching data. That leads to a big ball of spaghetti.

Read post →

Building AI apps? You need sync

Sam Willis

AI apps are collaborative. Building them requires solving resumability, interruptibility, multi‑tab, multi‑device and multi‑user.

Read post →

Electric Cloud public BETA: Sync in 30 seconds

Kyle Mathews

Electric Cloud is now in public BETA! This means it's open to everyone for immediate access.

Read post →

Electric 1.0 released

James Arthur

With version 1.0 Electric is now in GA. The APIs are stable and the sync engine is ready for mission critical, production apps.

Read post →

Electric BETA release

Kyle Mathews

With version 1.0.0-beta.1, the Electric sync engine is now in BETA! If you haven't checked out Electric recently, it's a great time to take another look.

Read post →

Local-first with your existing API

James Arthur

Local-first is often seen as eliminating your API. But what if you like your API or need to keep it as part of your stack? This post shows how you can develop local-first apps incrementally, using your existing API.

Read post →

A new approach to building Electric

James Arthur

Electric Next is a new approach that we've adopted to building Electric. One that's informed by the lessons learned building the previous system and inspired by new insight from Kyle Mathews.

Read post →

Electric v0.11 released with support for Postgres in the client

Sam Willis

Version 0.11 of ElectricSQL. This is the first release with support for syncing to Postgres in the client.

Read post →

Electric v0.10 released with shape filtering

James Arthur

We've published version 0.10 of Electric. This is the first release that properly supports where-clause and include-tree filtering with Shape-based sync.

Read post →

Electrify, Ignition, Liftoff!

James Arthur

ElectricSQL was selected by Intel as one of 10 startups to participate in batch #6 of it's Intel Ignite accelerator programme in Munich.

Read post →

Local AI with Postgres, pgvector and llama2, inside a Tauri app

Sam Willis

Local AI with Postgres, pgvector and llama2, running inside a Tauri app with realtime sync powered by ElectricSQL 🤯 This is the architecture of the future!

Read post →

ElectricSQL v0.9 released

Oleksii Sholik

We're kicking off the year with a fresh release of Electric that introduces a whole slew of improvements to the experience of configuring, deploying, and developing with Electric.

Read post →

Secure transactions with local-first

James Arthur

One of the most common questions we get asked about developing on ElectricSQL is how to do secure, confirmed transactions like bookings and payments.

Read post →

ElectricSQL v0.8 released with JSON and Supabase support

Sam Willis

Improved data model and deployment compatibility including JSON support and integration with popular Postgres hosts like Supabase and Digital Ocean.

Read post →

Use ElectricSQL with the Ionic Framework and Capacitor

Sam Willis

Introducing Electric Appointments, a demo mobile app built with the Ionic Framework and Capacitor.

Read post →

ElectricSQL v0.7 released

Sam Willis

We're thrilled to have published version 0.7 of ElectricSQL, which includes the new migration proxy and extended type support.

Read post →

ElectricSQL hosted the first "Local-first Software London" meet-up

Sam Willis

Last Thursday, the Electric team was excited to host the first Local-first Software London meet-up.

Read post →

Linearlite - A local-first app built with ElectricSQL and React

Sam Willis

Introducing Linearlite, a simplified, lightweight clone of Linear.app built with Electric.

Read post →

Welcome Sam Willis!

Purva Gujar

Sam Willis has joined the team as a Founding Engineer.

Read post →

Local-first sync for Postgres from the inventors of CRDTs

James Arthur

Introducing the v0.6 release of ElectricSQL. A local-first sync layer that you can use to build reactive, realtime, offline-capable apps directly on Postgres.

Read post →

Welcome Andrei and Oleksii!

Purva Gujar

Electric is now backed by Andrei Miulescu and Oleksii Sholik has joined us as a Founding Engineer.

Read post →

Developing local-first software

James Arthur

Local-first software is the natural evolution of state-transfer. It enables a modern, realtime multi-user experience, with built in offline support, resilience, privacy and data ownership.

Read post →

Welcome José, Kevin and Garry!

Purva Gujar

José Valim, the creator of Elixir, distributed systems expert Kevin De Porre and startup engineering veteran Garry Hill have joined Electric.

Read post →

The evolution of state transfer

James Arthur

Web development has been progressing through an evolution of state transfer. Local-first is the natural endgame and the vision we're working towards with Electric.

Read post →

Relativity and causal consistency

James Arthur

In this post we explore the assumptions that distributed databases are based on and investigate how causal consistency fits the reality of a relativistic universe.

Read post →

Introducing Rich-CRDTs

Valter Balegas

Rich-CRDTs are conflict-free data types (“CRDTs”) extended to provide additional (“Rich”) database guarantees. These guarantees, such as constraints and referential integrity, make building local-first applications much simpler.

Read post →