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.
CREATE TABLE projects (
id SERIAL PRIMARY KEY,
title TEXT UNIQUE
);
CREATE TABLE issues (
id SERIAL PRIMARY KEY,
project_id INTEGER
REFERENCES projects(id)
);function Component({ project }) {
const { data } = useShape({
params: {
table: 'issues',
where: `project_id = ${project.id}`
}
})
return <List issues={data} />
}Sync is the magic ingredient behind fast, modern software. From apps like Figma and Linear to multi-user, multi-agent AI apps.
Electric is a Postgres sync engine. It?solves the hard?problems of sync for you, including partial?replication, fan-out, and data?delivery.
So you can build awesome software — without rolling your own sync.
Electric works with any any Postgres, any data model and any web framework. that speaks HTTP and JSON It syncs data out of Postgres into anything you like, from a Javascript state variable to a local SQL database.
So you can adopt sync incrementally, one route at a time, into both greenfield and brownfield applications.
Electric uses standard CDNs to scale high-throughput data?delivery to millions of users.
The chart below shows latency and memory-use stay low and flat as we scale up-to an 80Gb/s workload to?a million concurrent users from a single commodity Postgres.
You can host it yourself or use the Electric Cloud?platform for managed sync with a built-in data delivery network.
Just real-time sync, solved. It’s all open source and it’s all just Postgres and HTTP.
Built into developer tools like Firebase and Supabase. Used in production by products like Trigger.dev, Otto and Doorboost.
Built by devtools and database experts. Backed by industry leading founders.
With a thriving open source community and over 600,000 downloads a week.
Electric also develops PGlite, a lightweight WASM Postgres with real-time, reactive?bindings.
Subscribe to the Electric Blog for the latest news and updates.
Follow @electric-sql.com on Bluesky and? @ElectricSQL on X:
Start with the Quickstart. Dive deeper with the Docs and Demos.
