Mobile SQLite to Cloud MYSQL Replication
Budget: $30 – $250 USD
Pascal Delphi 11 Mobile app data replication to cloud based central database.
Data replication.
Device SQLite Cloud MYSQL
Must use a secure connection.
Must use a certificate stored in code to connect.
Each Device has a unique ID. this is used in DB records
Integrity must be assured. Test record after upload.
Device to cloud.
Upload all data from the txn table. To cloud.
Upload all records from each table with flag of new or update to cloud. Table to have date device data
Cloud to device.
Download all data to device linked to is for each table. Device / table / record sync flag
For example. If I have a table called customer.
I want to update a customer record (abc123) to devices 1 3 & 4
I will add records for the id of the table record and device.
If that table has an entry for a table and device but no record you will download the entire table.
Customer abc123 1
Customer abc123 3
Customer abc123 4
Data replication.
Device SQLite Cloud MYSQL
Must use a secure connection.
Must use a certificate stored in code to connect.
Each Device has a unique ID. this is used in DB records
Integrity must be assured. Test record after upload.
Device to cloud.
Upload all data from the txn table. To cloud.
Upload all records from each table with flag of new or update to cloud. Table to have date device data
Cloud to device.
Download all data to device linked to is for each table. Device / table / record sync flag
For example. If I have a table called customer.
I want to update a customer record (abc123) to devices 1 3 & 4
I will add records for the id of the table record and device.
If that table has an entry for a table and device but no record you will download the entire table.
Customer abc123 1
Customer abc123 3
Customer abc123 4