I'm in the process of attempting to replicate a working (development) website into an offline app.
The basic premise of the website is that is gives a simple front-end search (HTML / JS / Ajax) of a large (800k+ records) MySQL database. Results are provided in an HTML table (DataTables).
I am essentially looking to achieve the same function, but with a one-time download, so the database (in a suitable format?) is packaged with the app download and we use an AEM mobile article to provide the front-end querying of the database. I have been able to get a simple HTML version working with a limited data-set, but the sheer volume of records for the full version means that's not an option.
Is this something that could be achieved with a bit of work / customisation, or am I setting off down the wrong route? Open to the idea of paid development work if someone has the skills to solve.
Any guidance, suggestions or criticisms most welcome!
If not you may just add active online connection as a requirement for the app to function. If users will mostly run it from the office you may assume they will have WiFi.