On 31 Jul 2011, at 8:50pm, Roger Binns wrote: > Multi-master replication is always hard > which is why it is so rare. > > The simplicity of the document model is because you put everything relevant > into a single item which typically matches the programmer's idea of an object.
These two go together. Multi-master replication (one example of which is a document store) is relatively easy. Datestamp every value (document) and whichever one has the lastest date is the one you want. One reason multi-master replication of SQL databases is hard to do properly is that every key has many values, and without customised logic which understands exactly how your app uses its data the app won't know how to reconcile them. If I have a 'customers' table and one user changes a customer's phone number and another changes the same customer's address, the app has to know what that means. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users