Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Offline, Searchable Database

Avatar

Avatar
Validate 1
Level 1
Tom_Myatt
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
Tom_Myatt
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
Tom_Myatt
Level 1

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)

Avatar

Avatar
Boost 1
Level 2
GennadyK
Level 2

Like

1 like

Total Posts

24 posts

Correct Reply

2 solutions
Top badges earned
Boost 1
Affirm 1
View profile

Avatar
Boost 1
Level 2
GennadyK
Level 2

Like

1 like

Total Posts

24 posts

Correct Reply

2 solutions
Top badges earned
Boost 1
Affirm 1
View profile
GennadyK
Level 2

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.