Response title
This is preview!
jquery mobile and local database
in jQuery Mobile
•
12 years ago
I have an app on iPhone - which is a database (implemented using Sqlite) with few thousand rows. The app populates various screens by querying this database.
I am planning to port it to Android, and decided to check out HTML5 and jquery.
This is my first attempt with html/js based mobile app, so I am trying to figure out really basic stuff.
The app will be packaged with PhoneGap or such frameworks (have not investigated that side yet), and will be available on iPhone and Android platforms.
Therefore, since this will be an offline app, the app built with jquery mobile should be able to bundle the database file along with the app files (html/css/js/images etc.).
I have not been able to find an example where a local database is bundled with the app; opened and queried to populate the screens. I have come across examples where data was download from a server, and the local database was created when the app is accessed.
Another thing I found is that there is not a standard local database solution that everyone has agreed on. So I assume sqlite is not the right database to use for html based app? I looked at few examples of IndexedDb, but not sure if it can do relational queries that I would need. Any insights would be helpful.
I have few thoughts that I can hack something to make it all work, but I am trying to figure out whats the right approach/architecture for this kind of app.
Thank you for reading.
1
