What is the maximum size of a Web SQL DB in iOS (Safari) on the iPad? How about LocalStorage?

Question

What is the maximum data size when using HTML5's Web SQL to store data locally on the iPad?

When you reach that, does it just prompt the user to increase it? Is that a simple yes/no permission request? If so, what's the hard limit (beyond which there isn't even the option of the user allowing it to expand)?

Does LocalStorage work the same way?

score 4 · Answer 1 · edited May 23 '17 at 12:17

The total limit for all WEB SQL Databases created by your site on Mobile Safari is 50Mb. Users are asked to confirm acceptance above 5Mb and you cannot later increase the size of an existing database, you can only create a new, secondary, db, so you have to plan well and set the size when you first create the db.

var theBiggestDB = openDatabase('databaseName', '1.0', 'My Database', 50*1024*1024);

See this answer: https://stackoverflow.com/a/6281947/1233018

score 0 · Answer 2 · answered Jun 11 '12 at 19:05

0

After 5MB, I believe it prompts the user if they would like to allocate more space. That's for WebSQL.

There is no maximum limit to the size, as far as I've seen.

answered Jun 11 '12 at 19:05

Brendan Lesniak

2,271
4
24
48

2

5mb then I believe it to be 50mb after getting user approval. – zybroxz Jun 11 '12 at 19:20
I've never hit that limit, nor came close; but its good to know (if it truly is 50mb). – Brendan Lesniak Jun 11 '12 at 19:22
To be honest the 50mb limit is only what I have been told for ios safari. Going to try and confirm :) – zybroxz Jun 11 '12 at 19:27
@zybroxz Were you able to confirm if that's the limit? – Don Rhummy May 07 '13 at 19:09
1

The following is a great resource that allows you to test your devices memory capabilities http://demo.agektmr.com/storage/ – Christopher Grigg Oct 30 '14 at 08:24

Sergey Galchenko · Answer 3 · 2013-04-12T11:05:14.113

0

For HTML5 Application Cache limit is 50 MB. I tried following manifest (more than 50MB in total)

CACHE MANIFEST

CACHE:
icon.gif
font.ttf
index.htm
5mb.mp4
7_4mb.mp4
19mb.mp4
19_1mb.mp4

And it says "Application cache update failed because size quota was exceeded"

If I change manifest to following (less than 50MB in total)

CACHE MANIFEST

    CACHE:
    icon.gif
    font.ttf
    index.htm
    # 5mb.mp4
    7_4mb.mp4
    19mb.mp4
    19_1mb.mp4

It asks me to increase application cache size to 50MB and save all data correctly.

Tested it on iPad, iPad 2, The new iPad

For WEB SQL storage should be the same limit.

edited Apr 12 '13 at 11:05

answered Jun 29 '12 at 13:38

Sergey Galchenko

722
4
9

2

The question is about Web SQL API databases, not the offline application cache (for static data). – TomW Apr 12 '13 at 00:34

What is the maximum size of a Web SQL DB in iOS (Safari) on the iPad? How about LocalStorage?

3 Answers3

Linked