I recently started working on an application that will serve as a Medicine Finder using PhoneGap (Version 2.8.0). In the past I created a web version of the tool which used jQuery Mobile and PHP to access a remote SQL database.
PhoneGap seemed like an attractive choice for turning the application into something that I could deploy to the iPhone/Android app stores but required that I re-write my previous web app in HTML5 & JavaScript. Because a majority of the people using the app would be on an iPad where internet connectivity is not always guaranteed, the plan for the app was to use a pre-populated local database.
Although the functionality of the app seemed very simple to implement, it appears that using pre-existing local db with PhoneGap is not so trivial. I have spent 15+ hours trying to find an easy way to do this with no success. I am aware that numerous phonegap+sqlite plugins exist on github but due to a lack of documentation and incompatibility with newer versions of PhoneGap I was unable to get them to work.
If there is anybody that has any experience with this I would really appreciate their input.
ALSO - If necessary, what is the easiest tool for converting my .sql database (2 tables, one has around 360 entries the other has 20) into a SQLite database.
