I'm currently working on a mobile app (implemented using Sencha Touch 2 and designed to run on an iPad). There is a requirement to pull a fairly large amount of data (3000+ objects, objects have around 30 fields) down to the app from a web service and then persist the data locally for use offline. I've investigated the standard solutions discussed here and elsewhere whereby localstorage proxies are used to persist the data after pulling it from the web service, but I run into the dreaded QUOTA_EXCEEDED_ERR due to the amount of data I'm trying to persist.

There are a handful of threads around discussing things like SQLLite and Lawnchair (including this thread where someone mentions integrating Sencha with Lawnchair and refers to a guide which I can't find anywhere) but no concrete examples or success stories. Can anyone remend a tried/tested method of persisting large datasets using Sencha Touch?

EDIT: After asking a similar question on the Sencha Forums I'm investigating the use of SQLite using the SQLite Proxy for ST2. Will update this thread further for the benefit of others once I have made progress.

I'm currently working on a mobile app (implemented using Sencha Touch 2 and designed to run on an iPad). There is a requirement to pull a fairly large amount of data (3000+ objects, objects have around 30 fields) down to the app from a web service and then persist the data locally for use offline. I've investigated the standard solutions discussed here and elsewhere whereby localstorage proxies are used to persist the data after pulling it from the web service, but I run into the dreaded QUOTA_EXCEEDED_ERR due to the amount of data I'm trying to persist.

There are a handful of threads around discussing things like SQLLite and Lawnchair (including this thread where someone mentions integrating Sencha with Lawnchair and refers to a guide which I can't find anywhere) but no concrete examples or success stories. Can anyone remend a tried/tested method of persisting large datasets using Sencha Touch?

EDIT: After asking a similar question on the Sencha Forums I'm investigating the use of SQLite using the SQLite Proxy for ST2. Will update this thread further for the benefit of others once I have made progress.

• javascript
• sqlite
• sencha-touch
• local-storage

1 Answer 1

Ended up using the SQLite Proxy for ST2 to solve my problem regarding persistence of a large dataset. Highly remended, and with a really helpful munity on the Sencha forums who were invaluable in getting the solution working.