Roy Hashimoto

I was describing alternatives to the Web Locks API to someone, and when I got to the absurd-sql approach I happened on something suspicious that seems worth investigating as a...

[wa-sqlite](https://github.com/rhashimoto/wa-sqlite) is _not_ a version of [SQL.js](https://github.com/sql-js/sql.js). No code is derived from SQL.js and it has a completely different API.

Unfortunately the suitability of the File System Access API for SQLite seems to be going nowhere, despite its [recent support in Safari](https://developer.apple.com/documentation/safari-release-notes/safari-15_2-release-notes). First of all, [Firefox seems pretty strongly opposed...

I don't know how the bug was originally triggered, but I tried adding `-s MODULARIZE=1` to the emcc flags, changed the output filename to end with .mjs (to output an...

@phiresky I haven't written an Emscripten FS, so this is based on my understanding of it. As you note, the SQLite VFS interface is higher level than the Emscripten FS...

> By the way, did you try using Atomics.wait() with a separate worker for communication instead of asyncify? I have not tried Atomics at all. I generally try to avoid...

Here are some timings for various VFS combinations. For each combination I did some simple operations: * Create a database * Create a table * Insert 1300 rows * Sum...

I created a [demo page](http://www.shoestringresearch.com/wa-sqlite/demo/) with several SQLite VFS combinations of filesystems (default, memory, IndexedDB) and builds (standard, Asyncify). It seems to work on Chrome, Firefox, and Safari (haven't tried...

@Taytay There isn't very much overhead for opening and closing a database, at least in terms of i/o. That seems unintuitive because we're trained to consider opening and closing files...

@Taytay Regarding WAL mode, that's a question for someone who knows more about database implementation and its trade-offs than I do. I probably only know enough to be horribly wrong....