Offline, Searchable Database

Tom_Myatt

08-08-2016

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. 

Accepted Solutions (0)

Answers (1)

Answers (1)

GennadyK

09-08-2016

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.