[Question] Does your library support Watermelon or Powersync, the offline first solution?

[ducpt-bili]

Hi @ospfranco , just want to ask that your library can integrate with two offline first solution WatermelonDb or Powersync.
You did really great job with op-sqlite.

Thank you

[ospfranco]

Watermelon has it's own SQLite driver which is already JSI. Power sync is a complete different product AFAIK.

[ducpt-bili]

hi @ospfranco , i have 2 question more.

1. Does Watermelon sqlite is good/bad compare to op-sqlite?
2. Can we using op-sqlite in Watermelon db using db adapter or something else?
   Have a good day @ospfranco , really appriciate your work on op-sqlite.
   Thanks

[ospfranco]

No, watermelon it's a separate library, closing this.

[iliapnmrv]

@ducpt-bili i moved from watermelon db and i'm happy with this library and my users are happy too. This library has high level of abstraction and it gives you a ton of flexibility. I can share my experience if you have any questions

[ducpt-bili]

hi @iliapnmrv , for more clear, what are your meaning by "moved from watermelondb", do you not using it and using some replace tool like powersync? Or if you mean you are using watermelondb, how can i use op-sqlite with it?
Thank you.

[iliapnmrv]

@ducpt-bili We no longer use WatermelonDB. Instead, I implemented server sync using REST APIs. For data requests, you can use RTK Query or React Query with their polling functionality and also websockets, which has worked perfectly for my needs

[ducpt-bili]

hi @iliapnmrv , thank you for your response.
Just one more question, so i understand you are using op-sqlite on mobile app without any support offline first solution. So on FE side like React Native, do you use any ORM to query data from sqlite? like Kysely, Drizzle?
Thank you.

[iliapnmrv]

Sorry if im being unclear but I do use op-sqlite as offline first solution.
I have the flow like this

1. I request data from server (around 100k rows in peak)
2. User uses app completely offline
3. as soon as internet connection establishes, I sync data using REST apis (both sending and receiving data from server)

I do not use any ORMs, I have quite complex SQL queries, I dont think orms could handle it.

If you have any questions, don't hesitate to ask

[ducpt-bili]

hi @iliapnmrv , sorry for being uclear, i mention "offline first solution meaning PowerSync or WatermelonDb", they sit on top of sqlite and do a lot of stuff for you like ORM, handle migration...
Op-sqlite have vector search feature that i really want to use in my application, but both of the solutions i meantion above is not support that.
Right now maybe i will go with PowerSync solution, because when i ask them, they said they will migrate to Op-sqlite soon.
So thank you @iliapnmrv , i'm really appreciate your support.

[rkistner]

For the PowerSync side, we're tracking the status of supporting op-sqlite here: powersync-ja/react-native-quick-sqlite#42