Best way to use strapi along with a database sync system for offline mode on mobiles

I am currently developing a mobile & web application using react-native and would like the app to work offline too.
Eventually, each user would have a local database with a number of rows growing up to 100k to 1M in the long term. The main feature of the app needs to run a groupby offline on these rows.

I found several posts online advocating that SQlite or SQLite-based alternatives like WatermelonDB would be a good match for this purpose, and I am now wondering if there would be a simple way to sync these local databases with an online database managed by strapi.

If anyone has comments, ideas or feedback of any kind, it would be very appreciated! :slightly_smiling_face:
Thanks

2 Likes

Have you tried this GitHub - sehgalsakshi/Offline-POST-PWA---Service-Worker: Service worker for handling post requests in offline mode using indexed db