> So once again, how would you answer Roger's question ? Suppose changes were > made on both computers at the same time. How would you reconcile the two > copies of the databases ? If you want to use the copy from the computer to > /update/ the copy in the mobile device then the mobile device needs access to > /both/ copies of the database when it's doing the updating, so it can see > what's new. So you really have not one database but two databases
Changes would not be made on both at the same time. Initially you upload your base DB on the mobile device, gather samples somewhere in field and occasionally change/add/delete data. Come back to the lab and download the latest version of the database. Then the lab staff uses the new updated version until you go out again and repeat that sequence. John On 3/2/12 2:17 PM, "Simon Slavin" <slav...@bigfraud.org> wrote: > > On 2 Mar 2012, at 6:55pm, "Rose, John B" <jbr...@utk.edu> wrote: > >> Thanks for the very thorough reply. >> >>> Android is a red herring in this and your approach is not a good one. How >>> would you do this using two different regular computers? How would you >>> deal with changes being made on both machines at the same time? How would >>> you copy databases ensuring you picked up the journals >> >> In this particular example, a particular researcher would be creating the >> initial version of the database on their own computer, but once they got out >> in the field they may update the copy they have on their mobile device and >> take that copy back to replace the original on their desktop. > > So once again, how would you answer Roger's question ? Suppose changes were > made on both computers at the same time. How would you reconcile the two > copies of the databases ? If you want to use the copy from the computer to > /update/ the copy in the mobile device then the mobile device needs access to > /both/ copies of the database when it's doing the updating, so it can see > what's new. So you really have not one database but two databases. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
