How would you... (synchronization between 2 databases)
-
Hello all, Some time ago I created a PHP web page that works against a MySQL database to keep track of all my worked hours as a freelance. That works well, and I use it extensively. The biggest issue I have while using it is when I am at a customer company without a reliable internet connection, and I can't remotely connect my office server to use it. I've been thinking of installing XAMPP in my laptop and copying the server database there to be able to work while being offline. Then I could backup the database as soon as I have internet connection or use a backup program to keep it safe. BUT: I am not the only one working with the database at the same time and this makes things much more interesting. How would you approach this situation? Of course, I can keep doing what I am doing nowadays: write everything in any other offline program or editor and do it when I get into a hotel or the office again. Thank you all!
www.robotecnik.com[^] - robots, CNC and PLC programming
-
Hello all, Some time ago I created a PHP web page that works against a MySQL database to keep track of all my worked hours as a freelance. That works well, and I use it extensively. The biggest issue I have while using it is when I am at a customer company without a reliable internet connection, and I can't remotely connect my office server to use it. I've been thinking of installing XAMPP in my laptop and copying the server database there to be able to work while being offline. Then I could backup the database as soon as I have internet connection or use a backup program to keep it safe. BUT: I am not the only one working with the database at the same time and this makes things much more interesting. How would you approach this situation? Of course, I can keep doing what I am doing nowadays: write everything in any other offline program or editor and do it when I get into a hotel or the office again. Thank you all!
www.robotecnik.com[^] - robots, CNC and PLC programming
[https://stackoverflow.com/questions/7722659/online-offline-database-synchronization-mysql-php\](https://stackoverflow.com/questions/7722659/online-offline-database-synchronization-mysql-php)
"Before entering on an understanding, I have meditated for a long time, and have foreseen what might happen. It is not genius which reveals to me suddenly, secretly, what I have to say or to do in a circumstance unexpected by other people; it is reflection, it is meditation." - Napoleon I
-
[https://stackoverflow.com/questions/7722659/online-offline-database-synchronization-mysql-php\](https://stackoverflow.com/questions/7722659/online-offline-database-synchronization-mysql-php)
"Before entering on an understanding, I have meditated for a long time, and have foreseen what might happen. It is not genius which reveals to me suddenly, secretly, what I have to say or to do in a circumstance unexpected by other people; it is reflection, it is meditation." - Napoleon I
-
Hello all, Some time ago I created a PHP web page that works against a MySQL database to keep track of all my worked hours as a freelance. That works well, and I use it extensively. The biggest issue I have while using it is when I am at a customer company without a reliable internet connection, and I can't remotely connect my office server to use it. I've been thinking of installing XAMPP in my laptop and copying the server database there to be able to work while being offline. Then I could backup the database as soon as I have internet connection or use a backup program to keep it safe. BUT: I am not the only one working with the database at the same time and this makes things much more interesting. How would you approach this situation? Of course, I can keep doing what I am doing nowadays: write everything in any other offline program or editor and do it when I get into a hotel or the office again. Thank you all!
www.robotecnik.com[^] - robots, CNC and PLC programming
Assuming your timesheet entry is flat and there is no conflict between in house and of site work I would store it locally in a copy of the server DB. Then simply bulk copy from the local DB to the server. Or It should be a simple exercise to write an off site storage and entry app (excel would do) that you can then load into the server DB.
Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP