[jadbox]

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),

[ochiba]

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.

[thruflo]

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.