Lightnews — Scholar-powered news

Reposted by ElectricSQL

Adam Wiggins @adamwiggins.bsky.social · Sep 4

Sync seems to be having a moment among web developers!

3 7 19

Reposted by ElectricSQL

Filipe Cabaço @filipecabaco.com · Aug 23

using bun and pglite from @electric-sql.com I'm able to create in memory or persisted postgres instances (one per bun process) available to use with Postgrex via `socket_dir`

in theory I could have a "cheap read replica" or simpler testing #myelixirstatus

2 2 19

Reposted by ElectricSQL

James Arthur @thruflo.com · Aug 19

One day boutique conference for the sync era of the web. Hear from the world's top builders about how to develop systems in the era of agentic software and real-time sync.

Sync Conf @syncconf.bsky.social · Aug 19

Announcing Sync Conf 2025. Join us in SF on Nov 12th.

4 8

Reposted by ElectricSQL

Valter Balegas @balegas.bsky.social · Aug 14

That's 168ms -> 1.6ms! and we have a lot of good ideas how to make it even faster.

ElectricSQL @electric-sql.com · Aug 14

We've just delivered a 100x write performance bump with our latest release of Electric. How? We threw away our storage engine and built a new one designed for sync 🧵

electric-sql.com/blog/2025/08...

Electric 1.1: new storage engine with 100x faster writes | ElectricSQL

How we built a new storage engine for Electric, why we did it now, and how it delivers lower latency, higher throughput, and zero‑downtime deploys.

electric-sql.com

2 5

ElectricSQL @electric-sql.com · Aug 14

The lesson: by shipping a system that works into production early and learning from it, allowed us to design a much better solution based on real-world requirements.

1

ElectricSQL @electric-sql.com · Aug 14

We've been running Electric in production for a year so we knew exactly what we needed: fast append-only writes and no data processing on reads.

The performance gains exceeded our expectations.

1 1

ElectricSQL @electric-sql.com · Aug 14

We're already syncing data to millions of clients in real-time behind a CDN, but our write path was heavily under-optimized.

The result: high CPU usage, accumulating WAL on Postgres, and high end-user p95 latencies.

1 1

ElectricSQL @electric-sql.com · Aug 14

We've just delivered a 100x write performance bump with our latest release of Electric. How? We threw away our storage engine and built a new one designed for sync 🧵

electric-sql.com/blog/2025/08...

Electric 1.1: new storage engine with 100x faster writes | ElectricSQL

How we built a new storage engine for Electric, why we did it now, and how it delivers lower latency, higher throughput, and zero‑downtime deploys.

electric-sql.com

1 4 12

Reposted by ElectricSQL

James Arthur @thruflo.com · Aug 14

LangChain, vector databases, instruction routing, specialized memory stores.

You'd be forgiven for thinking you need a whole new stack to build agentic systems. However, that isn't actually the case: electric-sql.com/blog/2025/08...

Bringing agents back down to earth | ElectricSQL

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.

electric-sql.com

1 1 3

ElectricSQL @electric-sql.com · Aug 14

How to build agentic systems on real-time sync.

James Arthur @thruflo.com · Aug 14

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.

1 4

ElectricSQL @electric-sql.com · Aug 4

We're just magic good sleep enablers! 😎

2

ElectricSQL @electric-sql.com · Aug 4

electric-sql.com/blog/2025/08...

120 days of hardening – the post‑1.0 reliability sprint | ElectricSQL

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.

electric-sql.com

1 6

ElectricSQL @electric-sql.com · Aug 4

We fixed IPv6 fallbacks, WAL slot recovery, memory leaks, file handle exhaustion, replication races, and dozens more issues.

The boring stuff that makes infrastructure work. Because when AWS launched S3, they didn't lead with features — they led with eleven nines. 🎯

1 3

ElectricSQL @electric-sql.com · Aug 4

Some highlights from our sprint:

• Connection recovery: 18s → 1.2s median recovery time
• Zero-downtime operations: clients stay connected through restarts
• Live schema changes: Electric adapts as your database evolves
• Better observability: see exactly what's happening

1 1

ElectricSQL @electric-sql.com · Aug 4

The results? @triggerdotdev.bsky.social achieved 20,000 updates/sec with sub-100ms latency handling 500GB+ daily Postgres traffic using Electric. Our Cloud syncs data to devices in 100+ countries monthly.

How? Postgres + HTTP foundation + serious reliability engineering.

1 2

ElectricSQL @electric-sql.com · Aug 4

Infrastructure software can't have bugs. Your sync layer is load-bearing infrastructure with database-level expectations.

We looked to S3 (11 nines!) and Redis for inspiration. They're simple ideas made extraordinary through relentless reliability engineering.

1 1

ElectricSQL @electric-sql.com · Aug 4

ElectricSQL recently completed a 120-day reliability sprint. Our one goal: make our sync engine so boring-reliable you stop thinking about it and just build.

We chased every incident, fixed every user-reported bug, and made unglamorous work our priority. 🧵

2 6 31

ElectricSQL @electric-sql.com · Aug 1

We just posted an RFC for a significant oft-requested feature — cross-table shape filtering — check it out and comment!

github.com/electric-sql...

RFC: Cross-Table Shape Filtering with Subquery Support · electric-sql electric · Discussion #2931

Summary Electric currently limits shapes to single-table filtering, preventing developers from expressing common authorization patterns that require cross-table relationships. This RFC proposes ext...

github.com

1 2

ElectricSQL @electric-sql.com · Jul 29

We look forward to collaborating more to make TanStack DB the future of app development with Electric and the best way to build the new generation of AI apps and agentic systems.

1

ElectricSQL @electric-sql.com · Jul 29

It's been a pleasure to partner with @tannerlinsley.com and the @tanstack.com team on this.

HT to @kyle.bricolage.io and @samwillis.uk for leading the work from our side.

1 1

ElectricSQL @electric-sql.com · Jul 29

Paired with Electric, TanStack DB provides an optimal end-to-end sync stack for local-first app development.

electric-sql.com/blog/2025/07...

Local-first sync with TanStack DB and Electric | ElectricSQL

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.

electric-sql.com

1 3 11

ElectricSQL @electric-sql.com · Jul 29

Tanstack DB is a reactive client store for building super fast apps on sync.

Based on a TypeScript implementation of differential dataflow, it's type-safe, declarative, incrementally adoptable and insanely fast.

Kyle Mathews @kyle.bricolage.io · Jul 29

TanStack DB is now in BETA!

We’ve been working on TanStack DB, an embedded, reactive client database for TanStack Query, and are proud to announce today that with the 0.1 release that it's now in BETA!

tanstack.com/blog/tanstac...

Stop Re-Rendering — TanStack DB, the Embedded Client Database for TanStack Query | TanStack Blog

Your React dashboard shouldn't grind to a halt just because one TODO turns from ☐ to ☑. Yet every optimistic update still kicks off a cascade of re-renders, filters, useMemos and spinner flashes. If y...

tanstack.com

1 5 13

Reposted by ElectricSQL

Kyle Mathews @kyle.bricolage.io · Jul 29

TanStack DB is now in BETA!

We’ve been working on TanStack DB, an embedded, reactive client database for TanStack Query, and are proud to announce today that with the 0.1 release that it's now in BETA!

tanstack.com/blog/tanstac...

Stop Re-Rendering — TanStack DB, the Embedded Client Database for TanStack Query | TanStack Blog

Your React dashboard shouldn't grind to a halt just because one TODO turns from ☐ to ☑. Yet every optimistic update still kicks off a cascade of re-renders, filters, useMemos and spinner flashes. If y...

tanstack.com

2 9 82

Reposted by ElectricSQL

Kyle Mathews @kyle.bricolage.io · Jul 25

🎉 TanStack DB now has @solidjs.com support!

3 9 51

Reposted by ElectricSQL

Kyle Mathews @kyle.bricolage.io · Jul 23

TanStack DB now has @svelte.dev support!

<script lang="ts">
import { useLiveQuery } from "@tanstack/svelte-db"
import { eq } from "@tanstack/db"
import { todoCollection } from "$lib/collections"

const todosQuery = useLiveQuery((query) =>
query
.from({ todos: todoCollection })
.where(({ todos }) => eq(todos.completed, false))
)
</script>

<List items={todosQuery.data} />

1 10 63