1

i was wondering if there is a way to enable cloud features for a SQLite database application.

Should i save the whole database to the cloud each time ? For example when i quit the application is it required to save the whole database to the cloud.

What do you suggest ?

Should i drop SQLite and use another database for cloud programming .

alexandertr
  • 943
  • 1
  • 9
  • 18

2 Answers2

0

iCloud supports SQLite databases.

When properly setup it will only sync change logs instead of the entire database. In theory it's pretty nice. I haven't however had the best of luck using it yet, it seems to be a little too buggy to actually use in ios 5, hopefully it's better in 6.

joshOfAllTrades
  • 1,982
  • 14
  • 10
  • do you know any other better database for cloud programming ? should i use free sql server express ? are there any other cloud enabled databases ? – alexandertr Jul 08 '12 at 18:19
  • I haven't tried any of the other cloud databases, we re-architected and used a file based approach with iCloud instead. It works much better and more reliably but the core data approach was definitely cleaner to work with (too bad it doesn't work well quite yet, fingers crossed for ios6). I'm definitely interested to see how any other alternatives work out but haven't had time to experiment myself quite yet. – joshOfAllTrades Jul 08 '12 at 20:31
0

To be most efficient you could manage a changelog of objects that are modified by the app. Then when its time to sync (while closing the app for instance), you can make operational requests to the Cloud. For add and update you can send the entire object, while for delete just the oid should suffice.

This is a very simple sync scenario. Things can get complicated fast if you are looking to send changes that happen in the Cloud down to the device. That is a scenario for a different thread.

Based on your question, you just need to sync from the device to the Cloud.

openmobster
  • 1,027
  • 5
  • 17