I’m delving into my first Ionic Vue cross-platform offline-first app and would love to hear any advice for tools to go about it, particularly for local data storage and two-way sync to server. Here’s a simple summary of technical needs for the app:
Offline, local storage by default
Optional account signup enables two-way sync with server
CRUD operations on text data (no images or other file types for now)
Cross-platform Android, iOS, and web
The two-way sync needs to be robust enough to handle frequent usage back and forth between mobile and web apps, and I’d like to use a library that handles as much of the sync logic as possible. If it has integrations for Ionic and/or Vue even better.
From what I’ve researched these seem to be the existing options for local storage with sync to server:
I am working on an offline first app in PWA, using my home-brew sync mechanism (not fully two way) using Ionic Storage and Firebase. I am not sure if this was the best choice. SQL could have been easier/better? Knowing that read speeds from server arent that critical anymore (for UI response times) in an offline first app. Syncing tables is maybe an easier task.
PWA and localstorage on iOS - not sure if that is a happy marriage too - if there is lots of data.
So besides your backend choices, it is interesting to know how you want to deploy the app.
In a capacitor/cordova solution, it is easy to implement sqlite.
I assume, there is a lot written/available about sync strategies in sql only situation. But not aware of libraries nor experience.
Offline first app development is an amazing concept which will reduce the probability of users uninstalling apps. Yes, due to lousy internet speed or poor connection, tons of mobile apps have been discarded by the users from their smart phones across the globe yearly. Apparently these circumstances will affect any business if that app seems a primary source for that business. With offline apps, this can be fixed.
I went with PouchDB and pouchdb-adapter-cordova-sqlite. I’ve been using it essentially just to manage and persist data to local storage on iOS and Android. It’s been over a year and it’s worked fine for myself and a small number of beta testers.
That said I’ve done little actual syncing aside from to my own personal test account. Last I checked Cloudant and a couple other CouchDB hosts (or self-hosted CouchDB) are the only options, and I’m not sure how involved it’s gonna be setting it up for multiple users each with their own database.
I evaluated all the possibilities and think the best free solution is to use PouchDB as a frontend storage and CouchDB as a database for seamless scaling. Of course CouchDB has its drawback as it can’t keep up with e.g. MongoDBs performance for a huge number of documents, but that is not what it was built for.
We just want to have a easy sync with eventual consistency and high availability.
In case someone needs an example solution i recently created an Udemy Course on Offline First Apps with Angular and Ionic, building a waiter ordering app using PouchDB and CouchDB sync with the possibility to just lose the internet connection and keep on ordering.