[Webkit-unassigned] [Bug 252138] New: Sqlite wasm opfs support

[bugzilla-daemon at webkit.org]

https://bugs.webkit.org/show_bug.cgi?id=252138

            Bug ID: 252138
           Summary: Sqlite wasm opfs support
           Product: WebKit
           Version: Safari Technology Preview
          Hardware: Mac (Apple Silicon)
                OS: macOS 13
            Status: NEW
          Severity: Normal
          Priority: P2
         Component: New Bugs
          Assignee: webkit-unassigned at lists.webkit.org
          Reporter: mybztg at icloud.com

I tried to use Sqlite WASM with OPFS as described in https://developer.chrome.com/blog/sqlite-wasm-in-the-browser-backed-by-the-origin-private-file-system/.
The release version of Safari 16.3 (18614.4.6.1.5) does not support nested webworkers (https://bugs.webkit.org/show_bug.cgi?id=22723), so I used 163 (Safari 16.4, WebKit 18615.1.18.100.1).

Expected:
A working persistence sqlite database using opfs, actually the same results like in Chrome (109.0.5414.119 (arm64))

```
Loading and initializing sqlite3 module...
Done initializing. Running demo...
sqlite3 version 3.40.0 2022-10-25 16:04:44 ff4fc29c38b78dfd471e25942304cba352469d6018f1c09158172795dbdd438c
The OPFS is available.
transient db = /mydb.sqlite3
Create a table...
Insert some data using exec()...
Query data with exec() using rowMode 'array'...
row  1 = 20
row  2 = 21
row  3 = 22
```

Actual behaviour:
16.3 (18614.4.6.1.5):
```
Loading and initializing sqlite3 module...
Done initializing. Running demo...
sqlite3 version 3.40.0 2022-10-25 16:04:44 ff4fc29c38b78dfd471e25942304cba352469d6018f1c09158172795dbdd438c
The OPFS is not available.
transient db = /mydb.sqlite3
Create a table...
Insert some data using exec()...
Query data with exec() using rowMode 'array'...
row  1 = 20
row  2 = 21
row  3 = 22
```

163 (Safari 16.4, WebKit 18615.1.18.100.1):
```
Loading and initializing sqlite3 module...
```

While 16.3 release does not support opfs, it is using the kvvs fallback.
With the latest preview, opfs is supported, but there are no results/errors at all.

To reproduce:
Open https://sqlite-wasm-opfs.glitch.me

I did open the issue in webkit and not in sqlite, because it works with chrome.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.webkit.org/pipermail/webkit-unassigned/attachments/20230212/61ef606c/attachment.htm>