I have developed a PHP application for my company, the problem is that I have just discovered that the application must work offline too. The application works like this: some data is loaded from a MySQL Database, then you have to compile some checklists, insert new data in the database and, in the end, generate a JSON.
The application will be used by a lot of people of our company, so we thought about installing on their computers a webserver (Apache) and make the application run on their machines. The problem is that, if we decide to go this way, we have to:
- Download all the data from MySQL BEFORE starting the application
(when the user has access to internet) and save this data into a JSON
file
- Change all the queries in the project in order to take the data from the JSON instead of the database
- Also, there are a lot of functions which insert data into the database in real-time, so we would have to use SQLite and then transfer the data to the MySQL Database
- Finally, in this way, the people who use this program would have access to ALL PHP files, and they could modify them at any time.
We don't have the time to think about a real Desktop Java application because this app will be used starting from January, so we don't have the time to develop it.
Have you got any suggestions? Is there something I'm not thinking about, or a technology which could help me? Thank you!
PS. I have considered programs like Nightrain of PHP Desktop but they only avoid the installation of Apache, nothing more...