SQLite database on PhoneGap

by

We ended up using the PhoneGap SQLite plugin, here’s why:

We started off using a plain old Web SQL Database in our PhoneGap app, but ran into the following limitations:

  • Size of database is limited to 5MB (the user can be prompted to allow more, but we didn’t want such prompts in our app)
  • Pre-populating the database via javascript adds to initial app load time

We initially worked around this issue by copying a pre-populated sqlite3 database to a special directory where it would be picked up by WebKit (e.g. as described here)

However, in our latest attempt to submit the app, we were told the app violated iOS Data Storage Guidelines, presumably because it was copying the database file to a non-standard location.

So we went with using the PhoneGap SQLite plugin instead: This allowed us to include a large pre-populated sqlite3 database in our app and access it from javascript via the plugin. Unfortunately, the plugin doesn’t provide exactly the same javascript interface as the browser, but it’s fairly close.

More Related Contents:

  1. how to save the data in sqlite3 in iphone
  2. Use CoreData or SQLite on iPhone? [closed]
  3. Location permission alert on iPhone with PhoneGap
  4. iOS 7 status bar overlapping UI
  5. SQLite Exception: SQLite Busy
  6. Where’s the best SQLite 3 tutorial for iPhone-SDK? [closed]
  7. How get a datetime column in SQLite with Objective C
  8. Add an SQLite database to an iPhone app
  9. Best Cocoa/Objective-C Wrapper Library for SQLite on iPhone [closed]
  10. Error: Whitelist rejection in Phonegap
  11. Where would you place your SQLite database file in an iPhone app?
  12. How do I install this script into PhoneGap for iOS
  13. how to get rowNum like column in sqlite IPHONE
  14. Best practices for in-app database migration for Sqlite
  15. How to view the data in sqlite file running in iphone application? [closed]
  16. Synchronizing an SQLite client database with a MySQL server database
  17. Creating an SQLite3 database file through Objective-C
  18. iPhone UIWebview: How to force a numeric keyboard? Is it possible?
  19. Encrypting SQLite Database file in iPhone OS
  20. sqlite database update when app version changes on Appstore in iPhone
  21. UIWebView to view self signed websites (No private api, not NSURLConnection) – is it possible?
  22. NSCalendar first day of week
  23. Can I force an iPhone user to upgrade an application?
  24. How do I use CaptiveNetwork to get the current WiFi Hotspot Name
  25. How to add a right button to a UINavigationController?
  26. How to get the center of the thumb image of UISlider
  27. How to convert ASCII value to a character in Objective-C?
  28. How to use ldid?
  29. Force portrait orientation while pushing from landscape View Controller
  30. How to override -drawrect in UIButton subclass?

Leave a Comment