electric VS EteSync Server

I'm interested in this problem also!

I think there is a large overlap with projects that market/focus on offline-first experiences.

AFAIK this problem can be solved by:

1) Considering a client-side copy of the database that gets synced with the remote DB. This is an approach [PowerSync](https://www.powersync.com/) and [ElectricSql](https://electric-sql.com/) and [rxdb](https://rxdb.info/) take!

Yeah I agree with it being an exaggeration. They are certainly riding the admittedly dated perception that realtime is so hard it's only available to the Googles and Figmas. But there's now some amazing open source solutions available like Y.js and ElectricSQL[1]. The barrier has certainly come down.

[1] https://github.com/electric-sql/electric

https://github.com/electric-sql/electric :

> ElectricSQL is a local-first software platform that makes it easy to develop high-quality, modern apps with instant reactivity, realtime multi-user collaboration and conflict-free offline support.

> Local-first is a new development paradigm where your app code talks directly to an embedded local database and data syncs in the background via active-active database replication. Because the app code talks directly to a local database, apps feel instant. Because data syncs in the background via active-active replication it naturally supports multi-user collaboration and conflict-free offline

"SQLedge: Replicate Postgres to SQLite on the Edge" (2023)

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.

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

A few days ago I saw some guys in this community saying that they uses https://www.etesync.com/ in order to sync contacts between Proton + Thunderbird (Desktop) + Mobile. I haven't used it yet, but I saved the link.

https://inteltechniques.com/book7a.html Benefits of iOS Risks of iOS Privacy & Security Considerations Settings Remove unused stock apps App Store login vs iCloud login App funding DNS: https://nextdns.io/ Calendars & Contacts: https://www.etesync.com/ Password Manager: https://strongboxsafe.com/ VoIP App: https://acrobits.net/ VoIP Service: https://voip.ms/en/invite/Mzc2NjM3 Data Service: https://refer.telnyx.com/refer/zrfmo Custom App Settings Shortcuts for Home Screen Next Week

EteSync - Secure Data Sync (version 2.4.0): Secure, private and end-to-end encrypted calendar, contacts and tasks sync

The programs will allow me to sync both my Google and my Etesyc Contacts and Calendars. Etesync also needs Etesync-Dav installed on the desktop but that is well explained on Github.

There is https://www.etesync.com