On 30 Jul 2011, at 10:57pm, Roger Binns wrote: > On 07/30/2011 01:43 PM, Alexey Pechnikov wrote: >> Multi-master replication can be easy with correct data structures. > > It takes more than a few lines of SQL. You've also got to be careful how > you write data (result is a DAG), you need replication code and you need > conflict resolution code.
Conflict resolution is so hard it's sometimes impossible. The situation where two or more copies had the same record modified at the same time is the test case for exactly what the data mean and what it means to update a row. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users