On Mon, Apr 2, 2012 at 8:37 PM, Webdude <[email protected]> wrote: > It's not important that the 2 db files are exactly the same all the time > that people are editing them, but only when they 'finalise' a 'package'. > So what if some code in the 'packaging' process performed a sequence of > queries that read all the data from the db, table by table, and inserted it > into a new db.
This is normally known as canonicalization of data. Sure, if you do this and in particular make sure that all rows are ordered, and if you take care of such things as ensuring that you set the page_size the same on all hosts that might access this DB, then it's possible, likely perhaps, that you can make this do what you want. But, I wouldn't rely on this without getting a guarantee from the SQLite3 team that they won't break that in the future. Nico -- _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
