0

I need to build a PHP/MySQL app that allows offline access on iPads (for travelling salesmen often in deep country without internet connection). I have to manage a daily (or on demand when the device is online) sync between the local data and my remote server. I have a large database, which cannot fit in the 5M localStorage limitation. IndexedDB or Filesystem API are not available on Safari (according to http://caniuse.com/).

Is there other ways that would be appropriate to get it done?

Radim Köhler
  • 122,561
  • 47
  • 239
  • 335
Florian Motteau
  • 3,467
  • 1
  • 22
  • 42

1 Answers1

0

Can't you use WebSQL? ( see question What is the maximum size of a Web SQL DB in iOS (Safari) on the iPad? How about LocalStorage? ).

If you coded it for LocalStorage you could easily use that LocalStorage API to access WebSQL on iOS devices...

Perhaps a jump to PhoneGap would solve some of your problems?

Do you need to store ALL data from your database?

I have a library for doing Syncrhonization, it's LocalStorage at the moment but the next update will allow me to use nearly any storage mechanism as it only needs one index. Purging data that is no longer required is on the list too... It's located at https://github.com/forbesmyester/SyncIt and you can even see a presentation courtesy of SkillsMatter / LondonAJAX.

Community
  • 1
  • 1
Forbesmyester
  • 936
  • 6
  • 15
  • 1
    Thanks for your answer. I thought about storing only relevant datas from the db, but it rises some big political problems (defining what is relevant). WebSQL seems to be really slower than other options (and is deprecated AFAIK). PhoneGap seems to help a lot (I just read about it, and Titanium also). I'll give a try to SyncIt ! – Florian Motteau Jun 21 '13 at 09:04