Roy Hashimoto

> Can't you always have an IDB transaction open that is committed and a new one created when xSync is called? I think that IDB's auto-committing transactions make this complicated....

That's really nice work, @jlongster! I love how the locking can be handled so elegantly with IndexedDB transactions; I think that's my favorite part. Your wa-sqlite benchmark code looks reasonable....

FYI Safari apparently re-enabled [support for SharedArrayBuffer](https://caniuse.com/sharedarraybuffer) in [release 15.2](https://webkit.org/blog/12140/new-webkit-features-in-safari-15-2/) last month. This means that the Atomics trick used by @phiresky and @jlongster to call asynchronous APIs (e.g. IndexedDB) synchronously...

> I am looking for a way to use a storage backend such as Torrent You could also look over this unmerged [SQLite over WebTorrent PR](https://github.com/rhashimoto/wa-sqlite/pull/21) for a different SQLite...

@lovasoa Honestly I find it difficult to work in the sql.js tree because the coding standard is ES5 and you have to run emcc for changes that only affect the...

I use sql.js in a Worker, but I'm not using the provided WebWorker API. Instead I wrote my own Proxy-based interface to the non-Worker API, with mechanics similar to [Comlink](https://github.com/GoogleChromeLabs/comlink)....

I think `ATTACH` already works in sql.js, e.g. this works in the [sql.js online demo](https://sql.js.org/examples/GUI/https://sql.js.org/examples/GUI/): ```sql ATTACH DATABASE "foo.db" AS foo; CREATE TABLE IF NOT EXISTS foo.bar (x, y, z);...

I've built SQLite filesystems with both Origin Private File System access handles and IndexedDB. In my benchmarks OPFS was somewhat slower. This may in part be because I used non-synchronous...

Firefox has objections to the full File System Access API proposal, but has been [more encouraging](https://github.com/mozilla/standards-positions/issues/562#issuecomment-908295605) on the parts used for Origin Private File System, including the AccessHandle API (which...

In the [previous comment](https://github.com/sql-js/sql.js/issues/284#issuecomment-544469088), the [linked pastebin](https://pastebin.com/d70TyxZq) uses a modified sql-wasm.js. I think all it really does is add `export {initSqlJs};` at the end so it's an easy hack, but...