I am starting an Appstudio project for a client to use Android for data collection. The crews work contracts for large power utility tasked with trimming trees. Some work locations are very remote with no internet so I need to build an offline capability into the app.
I built a management backend that is created in Asp.net Core, and has an API for getting and posting Json data.
I need the crew to be able to work offline and the add or update records via Rest Api when online.
Should I consider using SQLite or json files on Android so they persist data?
I am interested in anyone’s experience with this.