On 13 Jun 2012, at 8:43pm, Dima Bodrov <dbod...@hotmail.com> wrote: > I’m considering SQLite for a multi-device mobile application. Is there > anything in SQLite that allows a database on a mobile device to be synced > with the master database in the cloud incrementally? Looks like iOS can do > this through Core Data API. I imaging they're moving some kind of > “transaction” or “update” log back and forth bidirectionally.
Yes, iOS (and the Mac OS if you want to write a Mac client too) has an API which allows you to code up whatever change you made and send it to the cloud, which then pushes that change to all your devices. It's a fully documented API. One disadvantage is that, of course, your devices have to all be connected to the internet before they can send or receive changes. The other disadvantage is that as far as I know there's no client for anything Apple didn't make, so if you want to write an Android version of your App, it can't use the same mechanism. > Is such > transaction log functionality built into SQLite? No. And there's no way to implement it in a 'standard' way, because different programmers would need it to work differently. Theres no way of solving the problem which would be useful for all SQLite users. So don't expect it to appear. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
