SQLite storage size

1

Hi,

With one of my apps, i store records from our server in tables using sqlite.
I’m running the latest NSB. I’ve noticed that after importing a lot of records, i am now seeing the below message in Chrome which i never used to

kvstorageWrite() QuotaExceededError: Failed to execute ‘setItem’ on ‘Storage’: Setting the value of ‘kvvfs-local-392’ exceeded the quota.

Has the storage size changed or something else?

Thanks

2

SQLite databases created by Chrome are stored in the „localStorage“ area, so the size limit for localStorage applies to them (used to be 10MB, but that may depend on Chrome version, OS version, …). And anything else that‘s stored in localStorage also has to be considered.
You can find multiple functions (mostly javascript) that calculate the current size of localStorage, so check using Google. It seems that there’s no simple way to find the overall capacity apart from filling localStorage until overflow happens - but I haven’t investigated this thoroughly.
Kind regards Thomas

2 Likes
3

Thanks Thomas.
The message i am seeing seems to be across Chrome, and my native Android and iOS apps. I guess something must have changed. I’ll have to come up with an alternative way to handle the records.

4

H,i don’t know about sqlite and file system,but I would suggest using a native npm library to create a file in the android or iOS phone.i guess it would be a better aternative.best regs,tst

5

If you’re running on a device, make a native app. You can use a Cordova plugin which has no such limits on the database size.

1 Like