I have 2 Apps with very similar structure using sqlite. The older one, originally written under AppStudio 7.x runs fine in offline mode. The newer one written under 8.x fails to load sqlite without a network connection.
The older app has been re-built under the latest AppStudio version and still works fine. Both apps appear to be trying to get to the following URL: https://use.fontawesome.com/530b34dcfd.js. It still works without this in the older app (cached?), but not the new one.
The only other obvious result of this (besides sqlite failing?!) is the disappearance of the camera icon and therefore no way of taking a photo in the new app while offline.