IMPORTANT: The current approach RESETS all the database tables apart from the users table EVERY TIME that the server restarts.
This means that the .csv files have to be vigilantly watched and corrected if needed.
IMPORTANT: We have stopped using auto-increments for the primary keys in order to avoid behind-the-scenes change of the trackerId and driverId in jeepneys on deletion of records.
See the following for the same problem: https://stackoverflow.com/questions/24355325/csv-and-id-problems
Consideration: I'm trying to write an alternative that connects to Google Sheets via Coefficient.
IMPORTANT: The current approach RESETS all the database tables apart from the users table EVERY TIME that the server restarts. This means that the .csv files have to be vigilantly watched and corrected if needed.
IMPORTANT: We have stopped using auto-increments for the primary keys in order to avoid behind-the-scenes change of the trackerId and driverId in jeepneys on deletion of records. See the following for the same problem: https://stackoverflow.com/questions/24355325/csv-and-id-problems
Consideration: I'm trying to write an alternative that connects to Google Sheets via Coefficient.