This isnt a question per say, but I am looking for some feedback on a situation at hand.
I've been developing on Oracle Apex for the past 2 years and have successfully developed and deployed a dozen or so Apps to meet our business needs into production.
3 of these applications have been deployed are mobile versions and are being used by Ipad minis which require a live internet connection.
I have been working on an application which is right now being tested and debugged.
At a recent board meeting it was requested that this application be available offline. I know out of the box this is not possible so I have been brainstorming on how to make this available offline.
The one solution I have come up with is to deploy the application on Windows 8.1 tablets(thinking about Dell Venue's) with a constant vpn connection back to our network.
The way I am thinking about doing this is by installing Oracle XE on the tablets, and having a sync button so that data is sent back and forth throughout the day whenever an internet connection -> VPN is available.
Main Oracle 11gr2 Enterprise sits at our facility.
80 or so tablets with Windows 8.1, VPN and Oracle XE.
Sync button on Apex front end would send and retrieve new data
Tablets would access front via localhost (http://127.0.0.1:8080/apex/
Is this a practical solution? Can someone shed some light on why I should or should not pursue this road.
Also if anyone have any alternative solutions that do not require me learning a new programming language, i'd love to hear them.