On 11 Jun 2012, at 10:14pm, Brent Shifley <brentshif...@yahoo.com> wrote:
> I was wondering. If you had a SQLite database on two different iPads, then > had different changes applied to each database, is it possible to sync the > changes to each database? Suppose you have a list of contacts in a database and both copies have had one contact's phone number changed. Which 'new' phone number should appear in the merged copy ? If you are the writer of the application which accesses the databases, and you understand exactly how the application uses them, and how the users have been told to use the application, then you can build some synchrony features into your software. But writing a general solution -- something which will work on two copies of any SQL database -- is impossible. Not only for SQLite but for all relational databases no matter what DBMS is used. There are questions about how various changes should be handled which need either answering by a human or detailed information about how the application uses the database. It's not possible to write one program which can tell how to get the 'best' merging of the two copies without it. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
