Offline, Searchable Database

[Tom_Myatt]

Hi all,

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!

Thanks, Tom. 

[GennadyK]

Hi Tom,

You will need javascript database solution to convert your MySQL web app to an HTML offline app (e.g. offline SQLite database). But it might be slow for ~1M records search - you need to test it. IMO, better google on those specific topics and look for answer somewhere else.

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.

Regards,

G.