Saving XML response to SQLite and Parse using jquery

4 posts, 0 answers
  1. Keen
    Keen avatar
    101 posts
    Member since:
    Mar 2013

    Posted 31 May 2013 Link to this post

    Hi
       I'm targeting iOS phone, I currently post a thread about SAVING XML to Local, I learned about Apache Cordova local Storage. But since there a size limit in 5mb and I'm having a large amount of data that I fetch in Web Service. I want to use SQLite. Is there a step-by-step tutorial of SQLite? and imagine "req" is the variable represent the XML response of Web Service. How to save it using SQLite and parse using Jquery? Thank you for who will response!

    Thanks
    Keen
  2. David Silveria
    David Silveria avatar
    234 posts
    Member since:
    May 2006

    Posted 03 Jun 2013 Link to this post

    Here's how to handle databases from Cordova:http://cordova.apache.org/docs/en/2.4.0/cordova_storage_storage.md.html#Database
    You can check stackoverflow for answers as well e.g.: http://stackoverflow.com/questions/8375382/how-to-store-json-in-sqlite
    http://stackoverflow.com/questions/12153857/how-can-i-insert-a-json-object-into-a-sqlite-table-in-javascript-phonegap-cord
    https://groups.google.com/forum/?fromgroups#!topic/phonegap/EE7JzNN1MNI
  3. Keen
    Keen avatar
    101 posts
    Member since:
    Mar 2013

    Posted 03 Jun 2013 Link to this post

    Hi David,
     Thanks for the help. But using SOAP XML ,I can get the response and save the data using the SQLITE,as whole XML, but what I need is to parse the data from SQLite
  4. David Silveria
    David Silveria avatar
    234 posts
    Member since:
    May 2006

    Posted 04 Jun 2013 Link to this post

    Here is a thread about this: http://stackoverflow.com/questions/4935632/how-to-parse-json-in-javascript

    It is much easier to find generic info by using google than waiting for someone else to point a reading to you.
Back to Top