<-- test --!> Show HN: ElectricSQL, Postgres to SQLite active-active sync for local-first apps – Best Reviews By Consumers

Show HN: ElectricSQL, Postgres to SQLite active-active sync for local-first apps

news image

  • Access rules
  • Sync shapes
  • Live queries
  • Local writes

Craft how data syncs on and off onto your app using Shapes.

Shapes allow you to manage dynamic partial replication between Postgres in the cloud and SQLite in the local app.

const shape = await db.projects.sync({
where: {
owner_id: auth.user_id
},
include: {
issues: {
include: {
comments: {
include: {
author: true
}
}
}
}
}
});

Anurag Goel

FounderRender

ElectricSQL is a great choice for a local-first sync layer that you can run anywhere yourself.

Johannes Schickling

FounderPrisma

I’m very impressed with ElectricSQL’s approach to sync and their thoughtful API design.

José Valim

CreatorElixir

ElectricSQL brings the full power of the Erlang VM to local-first software development.

  • Instant reactivity
  • Realtime multi‑user
  • Conflict‑free offline
  • Simple to operate
  • Cheaper to run
  • Reliable by design
  • Standard open‑source
  • Drop‑in compatible
  • Existing applications

Open source

Apache 2.0 license. Open development on GitHub and Discord. Contributions welcome.

Self-host

One horizontally scalable sync service. No complex infra or durability requirements.

Read More