I recently started working on an application that will serve as a Finder for medications using PhoneGap (version 2.8.0). In the past, I created a web version of a tool that used jQuery Mobile and PHP to access a remote SQL database.
PhoneGap seemed like an attractive choice for turning the app into something that I could deploy to iPhone / Android app stores, but demanded to rewrite my previous web app in HTML5 and JavaScript. Since most people using the application will be on an iPad, where an Internet connection is not always guaranteed, the application plan should have used a pre-populated local database.
Despite the fact that the application functionality seemed very simple to implement, it seems that using the existing local db using PhoneGap is not so simple. I spent 15 hours trying to find an easy way to do this without success. I know that on github there are numerous phonegap + sqlite plugins, but due to the lack of documentation and incompatibility with newer versions of PhoneGap, I was unable to get them to work.
If there is anyone who has any experience, I would really appreciate their input.
ALSO - If necessary, which is the easiest tool to convert my .sql database (2 tables, one of which contains about 360 records, the other 20) into a SQLite database.
source share