Quota exceeded error

[SteffenDE]

I'm trying to use a webpage that uses PouchDB to manage some of its state. In Webkit browsers WebSQL is used as storage backend, but in WPE I get the following error:
Unhandled promise rejection {"status":500,"name":"web_sql_went_bad","message":"unknown","reason":"The quota has been exceeded."}.
I tested this using buildroot and yocto, but it's always the same error. Is this something which is known or why do you think this happens?
Device: Raspberry Pi 3 (buildroot master branch/meta-wpe master branch).

To reproduce: https://codepen.io/anon/pen/xpXRab
Try this in Chrome/Firefox/Safari and you should see something like { "ok": true, "id": "testdoc", "rev": "1-58db569cc5fa4ea6b4ffe989a457c07a" } , but in WPE I get the quota error from above.

Thanks for any help!

To make sure that enough disk space is left:

root@raspberrypi3:~# df -h
Filesystem                Size      Used Available Use% Mounted on
/dev/root               406.5M    236.1M    148.9M  61% /
devtmpfs                300.6M         0    300.6M   0% /dev
tmpfs                   305.1M    136.0K    304.9M   0% /run
tmpfs                   305.1M    248.0K    304.8M   0% /var/volatile

[SteffenDE]

https://codepen.io/anon/pen/Eowroz tests if opening a WebSQL database works. Same error as above.

[SteffenDE]

IndexedDB works as expected, saving database files to /root/.local/share/wpe/databases/indexeddb/ so this seems to be an error with WebSQL only.

[wouterlucas]

Ahhn my bad, I don't think WebSQL is supported at all in WebKit. It's an abandoned spec at W3, last update is nov 2010. The spec is, as far as I understand, superseded by IndexedDB support. Also doesn't seem to work on my Safari.

Is there any reason you are looking for WebSQL support in particular?

[SteffenDE]

WebSQL does work in Webkit, at least in Safari on macOS.
The reason is that PouchDB is using WebSQL in Webkit based browsers (like Safari) because the IndexedDB implementation wasn't working correctly in previous versions. They want to change this soon, but currently my project doesn't work in WPE because WebSQL support is advertised, but it just doesn't work.

Also doesn't seem to work on my Safari.

You're not getting the quota error, are you? I'm getting err 18 (SecurityError), but that seems to be because of some Safari privacy settings (Codepen runs the code in an iframe). Try opening the page directly. This should display true.

[wouterlucas]

Interesting, I tried that link you've shared earlier on Safari nightly and that didn't work. The html5 test indeed show the same as your screenshot.

Quick search shows there are indeed bits and pieces of WebSQL in the WPE code tree. We could see if there is a flag to enable it, but you're boldly going where no man has gone before on WPE :)

[SteffenDE]

Well I think it would be nice to have the same support for WebSQL as in Safari, but it wouldn't be bad if there was no support at all. The main problem is that WPE shouldn't expose any WebSQL APIs if they don't work.

[albertd]

@SteffenDE in the latest wpe-2017 WebSQL and IndexedDB should be properly supported. Closing ticket for now.