News for hackers. Stuff that matters.

A comment on Show HN: ElectricSQL, Postgres to SQLite active-active sync for local-first apps. Parent comment

Re:Show HN: ElectricSQL, Postgres to SQLite active-active sy... by mnahkies on Wednesday September 20, 2023 @02:19PM (#37587821)
Are you / have you considered leveraging postgres' row level security for this (row filtering)? Feels like a natural fit for ensuring the right subset of data gets to the right users https://www.postgresql.org/docs/current/ddl-rowsecurity.html

E2E encryption would also be nice to have, it could be worth having a look at https://www.etesync.com/ for inspiration

[ Parent | on HN ]
Re:Show HN: ElectricSQL, Postgres to SQLite active-active sy... by vbalegas on Wednesday September 20, 2023 @04:49PM (#37589965)
You definitely can do row-level filtering (and a lot more) using DDLX[1], an extension we made to Postgres language that allows expressing flexible permission rules in a data-centric way.

[1] https://electric-sql.com/docs/api/ddlx

[ Parent | on HN ]