I agree, and the other downside is that with the server-free approach described in the article, there wouldn't be a backup of your data off your device. The au

I agree, and the other downside is that with the server-free approach described in the article, there wouldn't be a backup of your data off your device. The author does mention privacy concerns — hence the appeal of storing the data locally on your device. I work on PowerSync https://www.powersync.com/ https://www.powersync.com/ — using embedded SQLite for local-first/offline-first which syncs with Postgres in the background. I think using an architecture like that where an encrypted version of the data is synced to Postgres, and decrypted for access on the client, would balance the trade-offs well.