Hacker News new | ask | show | jobs
by belalw 931 days ago
Looks a lot like a light version of ElectricSQL (https://github.com/electric-sql/electric). Why should I use PowerSync instead?
1 comments

A detailed comparison can be found here: https://www.powersync.com/blog/electricsql-vs-powersync
Hi! I'm not familiar with either engine, but I'm confused with the text in the comparison (see below). Couldn't ElectricSQL be used within the backend to enforce policies or am I missing something?

> Writes are made directly to your Postgres database via the Electric sync service (bypassing your backend application),

ElectricSQL's architecture is documented here:

https://electric-sql.com/docs/reference/architecture#primary...

https://electric-sql.com/docs/reference/architecture#data-fl...

The docs explain how the Electric sync service publishes a logical replication stream that the Postgres database subscribes to. The Electric sync service is responsible for validating permissions based on the DDLX configuration.

Yup, this is correct.

We have had some requests / discussions around adding hooks to the sync service that will support custom logic on the write path (as per https://github.com/electric-sql/electric/discussions/565). This seems like a good idea but they don't exist yet.