Sqlite Database on Phonegap/iOS - More Than 5Mb Possible

phonegap sqlite database max size?

The database size is not limited to 5MB it can keep on increasing till the phone storage is capable of handling it.

Neither PhoneGap nor SQLite limits the size of the app.

How can I store more than 5MB data on a Phonegap HTML5 offline application?

That stands for localStorage and the built in SQLite database. I would suggest you taking a look at the File API, which would allow you to store files in the device.

Max size of WebSQL/SQLite database inside UIWebView (phonegap)

Yes, the WebKit DB is also limited to 5mo.

You can trick the system with this solution: https://issues.apache.org/jira/browse/CB-330?focusedCommentId=13237796&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-13237796

Or you can use a native SQLite DB (same as WebSQL) with a phonegap plugin. That plugin save the database in the Document folder (or you can specify another folder), and there is no size limit and data is saved by iCloud. (But take care, Apple don't really like apps wasting iCloud storage)

Here is the Native SQLite phonegap plugin : https://github.com/davibe/Phonegap-SQLitePlugin Regarding this plugin, there are some differences between the WebSQL API, here is an adaptor: https://gist.github.com/2009518

And if the data are important, you should save it to a server. I wrote a small lib to synchronize the SQlite DB to a server : https://github.com/orbitaloop/WebSqlSync

Phonegap best practice to save data over the 5mb limit

hope this will help you.

Use SQLitePlugin , anybody can read about it from http://plugins.cordova.io/#/package/com.triarc.sqliteplugin

just add this plugin to your project simply like

cordova plugin add com.triarc.sqliteplugin

if previously you are using SQL API In your project, you need not to worry just replace this thing

SQL API

var db = window.openDatabase("my_db", "1.0", "MY DB", 200000);

SQLitePlugin

var db = window.sqlitePlugin.openDatabase({name: "my_db"});

and use all other code as it is.

What database does PhoneGap use and what is the size limit?

Is my understanding of what database PhoneGap will use accurate?

Yes it is. PhoneGap can use LocalStorage, SessionStorage, or SQLite databases. You can also, alternatively use PhoneGap to connect to the devices native classes via a plugin, and pass the native class data, that it will then store on the device.

Is there any solid documentation about how much data a PhoneGap database of a given type will store? If it is a PhoneGap database and not the browsers database implementation.

1. LocalStorage :: 10MB
2. SessionStorage :: 10MB
3. SQLite Database :: 50MB-80MB (depends on the device)
4. Native Database using plugin call :: Unlimited data amount
5. IndexedDB :: 5MB. Still existant. But very buggy, theres a list of devices/OS's that run it here

Does PhoneGap have plans to adhere to the the Web Storage standards thereby dropping WebSQL in favor of indexedDB? If so, will I still be able to use my existing WebSQL code (via a built in PhoneGap-polyfill) once the switch to indexedDB is made?

WebSQL is slowly being deprecated. Its replacement is IndexedDB or SQLite. The best option for you, however, is either SQLite or the Native Database (for example Core Data on the iOS)

In situations where database size is limited and cannot be expanded by either PhoneGap or the Quota API, but access to the file system is available, is it reasonable to assume that "extra" data could be stored on the device's file system or on a SD card?

It is definitely possible.

• On Android you can specify the location of the database, and therefore push data to an external database.
• On iOS, you can use the native database call to store data on CoreData, there is no external memory.
• In all cases of all OS's, you can create a flat database file, like a Text file, store your data in key-value lists, and then pull those into your app at first run. Beware of the memory management in this case.

I've added an explanation of how to go about coding for the SQLite and LocalStorage databases in my answer.

Phonegap DB options, IndexedDB, SQLite?

I Ended up going with LocalStorage. It has good support and is easy to use. Also I am using MongoDB on the backend, so everything from front to back stays as javascript/JSON

http://caniuse.com/#feat=namevalue-storage

Best database option for PhoneGap applications?

Answer to this question would be using SQLite Database. See the links below -

SQLite Database

SQLiteDatabase PhoneGap

Hope it helps.

---

Related Topics