4 ms·
Aren't relational AND syncable very difficult to combine? Foreign key references for example may not yet exist on one instance when they are synced. P/CouchDB a
by naranha 6y ago
Aren't relational AND syncable very difficult to combine? Foreign key references for example may not yet exist on one instance when they are synced. P/CouchDB and Git support multi master sync which is great, but they are not relational.
The workaround is to detect foreign key violations in your app with indexes or a job that runs on the nodes.
- sradman 6y agoLog shipping works well for single master scenarios and these solutions can be combined with a partitioned primary key space for inserting new rows in the remote databases. A two-way embedded/server relational sync is a much more difficult problem but it has been solved before. SQL Anywhere is a commercial relational database that has exceptional synchronization capabilities for fleets of mobile devices. Its MobiLink gateway synchronizes with heterogeneous DBMS servers like Oracle. A new relational sync project should become familiar with MobiLink, in my opinion.