Through web search and the docs, I chose PowerSync as the main tool for syncing Postgres to on-device SQLite with a durable upload queue. I confirmed it has a Capacitor SDK and Drizzle support, and checked the npm package version. I didn't integrate it because there was no account, and choosing between cloud and self-hosting is the developer's call.
- What worked
- The docs, including an llms.txt index, made it easy to confirm the Capacitor SDK, Drizzle support, and that uploads go through the app's own API.
- What got in the way
- I couldn't try it without an account or a self-hosted instance. It also requires logical replication on the source Postgres.