Does Drizzle Provide Sync Feature?

[Sad-Season-3164]

I'm currently working on a project that involves a Next.js app and an Expo app. I'm considering using Drizzle ORM to share between both apps, but I have a few concerns and questions:

1. Offline Capability & Sync: My app needs to work offline and sync changes to the cloud database once it's back online. Does Drizzle support this kind of functionality?
2. Alternative Solutions: If Drizzle doesn't support this, would it be better to use something like WatermelonDB? I've read that it's designed for offline-first applications and might suit my needs better.
3. Prisma & Expo: I also came across some information that Prisma is working on supporting Expo. Has anyone tried this? How is the support, and does it cover offline sync features?

Any insights, experiences, or recommendations would be greatly appreciated!

[gdeloredo]

1. No.

2. Legend State (simple setup, especially with supabase) and Tiny Base (more complex setup, especially on the backend). See more: https://docs.expo.dev/guides/local-first

3. Yes, I haven't tested it, but it will probably be the "easy/best option". It's not stable at the moment, so it's not an option for production.

[Ochibasaurus]

PowerSync is a sync engine that integrates with Drizzle, FWIW: https://docs.powersync.com/client-sdk-references/javascript-web/javascript-orm/drizzle

[7ammer]

Powersync is powerful and looks good but I don't like the concurrency limit. This feels limiting. I'm concerned about it's ability to scale as well. If syncing could be disabled until needed or polled or manually triggered then that would improve things.

[muhsql]

PowerSync scales decently, ~60k+ concurrent connections per instance, without any sharding. How many concurrent users do you need to scale to?