[sqlite] does sqlite work with Apple iCloud and IOS 5

[Andy Davidson]

Hi 
I have an iPhone app that uses a sqlite base . Apple's iCloud is very cool
It automatically syncs your changes back to the cloud and out to all your
other devices. Does anyone know  what I need to do to get sqlite to work
with Apple's iCloud.



After watching one of the WWDC presentations it looks like iCloud is going
to try to sync changes to the file using something  like a 'patch file'.  I
do not know how sqlite manages it database file. Is the "patch" going to
work correctly with delete, update, and insert functions?

 

Apple provides a lot of support for sync with iCloud in their UIDocument
class. It handles read/write and sync with the cloud along with conflict
resolution. Any idea what I need to do to add this functionality to sqlite?

Thanks

 

Andy


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] does sqlite work with Apple iCloud and IOS 5

[Simon Slavin]

On 10 Oct 2011, at 9:55pm, Andy Davidson wrote:

> I have an iPhone app that uses a sqlite base . Apple's iCloud is very cool
> It automatically syncs your changes back to the cloud and out to all your
> other devices. Does anyone know  what I need to do to get sqlite to work
> with Apple's iCloud.

There's really no point to integrating them.  They both do similar things.  
Just one stores data in a file an your hard disk (or networked server) and the 
other stores data at Apple's server farm.

I'm afraid I can't give details until the iCloud APIs go public, which is not 
yet.  The same is true of everything to do with iOS 5.  But basically yes, 
stuff works, roughly the way you'd expect it to.

It's worth bearing in mind that your device's communications with the cloud 
might be going through a poor quality phone connection, at phone connection 
speeds.  You do not want to store more than a few K in the cloud.  Thirty or 
forty important locations for your GPS device ?  Fine.  Every place you've ever 
stopped ?  No.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] does sqlite work with Apple iCloud and IOS 5

[Alex Bowden]

Andy

Simon's answer is totally nonsense.  I suspect that he has misunderstood 
something that he's read.

The only thing that he is right about, is that neither of us can tell you 
anything about iOS 5 until the cloud API is public.

However, what I can tell you, which isn't about iOS 5, is this.

Apple uses sqlite for pretty much all iOS based data storage.  You can use 
other storage mechanisms, but sqlite is the default.

Most code that has been developed for iOS (rather than ported to iOS) does not 
use sqlite directly.  It uses core data which is a persistent object store for 
objective C objects.  The default choice for storing these persistent objects 
is to let core data store them in sqlite.

Core data really is an excellent facility which is tightly integrated with 
Objective C, Xcode, with iOS's User Interface facilities, iOS's undo stack, 
etc..  It is unlikely that Apple would walk away from that as a primary storage 
mechanism.

If you have an iPhone app, then you are probably a registered developer, in 
which case you can watch the video's from the recent WWDC.  Search for any with 
iCloud in their name, and watch them.

Otherwise, why not spend the time from now until release, finding out what core 
data will do.

Alex


On 11 Oct 2011, at 17:34, Simon Slavin wrote:

> 
> On 10 Oct 2011, at 9:55pm, Andy Davidson wrote:
> 
>> I have an iPhone app that uses a sqlite base . Apple's iCloud is very cool
>> It automatically syncs your changes back to the cloud and out to all your
>> other devices. Does anyone know  what I need to do to get sqlite to work
>> with Apple's iCloud.
> 
> There's really no point to integrating them.  They both do similar things.  
> Just one stores data in a file an your hard disk (or networked server) and 
> the other stores data at Apple's server farm.
> 
> I'm afraid I can't give details until the iCloud APIs go public, which is not 
> yet.  The same is true of everything to do with iOS 5.  But basically yes, 
> stuff works, roughly the way you'd expect it to.
> 
> It's worth bearing in mind that your device's communications with the cloud 
> might be going through a poor quality phone connection, at phone connection 
> speeds.  You do not want to store more than a few K in the cloud.  Thirty or 
> forty important locations for your GPS device ?  Fine.  Every place you've 
> ever stopped ?  No.
> 
> 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