Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Chrome (Webkit) WebSQL Database maximum file size?

I'm trying to find some information on the maximum size a WebSQL (SQLite) database can be on Google Chrome. I've read conflicting information such as max size is 5MB and the User is prompted when DB reaches 10, 50, 100MB etc.

I've tried creating DB's of various sizes and they open fine at 500MB and 5,000MB, however I've yet to try adding data up to these large sizes.

Does anyone have any first hand experience with large WebSQL DB's or can point me at relevant information?

like image 896
nevf Avatar asked Dec 19 '10 00:12

nevf


People also ask

Is Websql deprecated?

Web SQL was deprecated and removed for third-party contexts in Chromium 97. [📍 We are here.] Web SQL access in insecure contexts is deprecated as of Chromium 105 at which time a warning message will be shown in the Chrome DevTools Issue panel.

How big is too big for SQLite?

SQLite database files have a maximum size of about 140 TB. On a phone, the size of the storage (a few GB) will limit your database file size, while the memory size will limit how much data you can retrieve from a query. Furthermore, Android cursors have a limit of 1 MB for the results.

Can SQLite store datasets larger than 1 petabyte?

Very large datasetsAn SQLite database is limited in size to 281 terabytes (248 bytes, 256 tibibytes). And even if it could handle larger databases, SQLite stores the entire database in a single disk file and many filesystems limit the maximum size of files to something less than this.

What is Websql used for?

Web SQL is a deprecated web page API for storing or managing the data in databases that can be queried using a variant of SQL like creating databases, opening the transaction, creating tables, inserting values to tables, deleting values, and reading data.


3 Answers

Here's a link to the most solid article on the subject I've found so far:http://html5doctor.com/introducing-web-sql-databases/. Helped me a lot.

like image 90
slacktracer Avatar answered Sep 18 '22 12:09

slacktracer


i'm not sure about the max size for a database on a normal webpage, but if you need a lot of storage, you can make an extension that requests the "unlimitedStorage" permission. See http://code.google.com/chrome/extensions/manifest.html.

like image 41
XZVASFD Avatar answered Sep 19 '22 12:09

XZVASFD


If you try to create a database over the size of the default database size, 5MB. The popup is shown the image below, asking whether you want to grant the database permission to scale up to the next size of database — 5MB++ to onwards. In short, you can have unlimited size but if user want.

enter image description here

like image 26
Muhammad Hassan Avatar answered Sep 18 '22 12:09

Muhammad Hassan